Do While (ts.EOF = False)
For j = 0 To ts.Fields.Count - 1
xlsheet.Cells(i + 2, j + 1) = "'" & ts.Fields(j)
Next j
ts.MoveNext
i = i + 1
Loop
For j = 0 To ts.Fields.Count - 1
xlsheet.Cells(i + 2, j + 1) = "'" & ts.Fields(j)
Next j
ts.MoveNext
i = i + 1
Loop
参考一下这里http://bingning.net/VB/SOURCE/programing/xlsedittblfmt.html
For j = 0 To ts.Fields.Count - 1
xlsheet.Cells(i + 2, j + 1) = "'" & ts.Fields(j)
Next j
ts.MoveNext
i = i + 1
Loop