'假设是针对第5行数据
Dim i As Integer
Dim L As Integer
Dim m() As String
'返回第5行数据区的最大列号到L
L = Excel.Application.ActiveWorkbook.Sheets("Sheet1").Cells(5, 1).CurrentRegion.Columns.Count
ReDim m(L)
For i = 1 To L
m(i) = Excel.Application.ActiveWorkbook.Sheets("Sheet1").Cells(5, i).Text
Print m(i)
Next i