主题：[求助]关于EXCEL报表自动换行及根据长度换页

Dim Book As New XLS.Book(ProjectPath & "Attachments\Greport.xls")
Dim fl As String = ProjectPath & "Reports\Greport.xls"
Book.Build() '生成细节区
Book.Save(fl) '保存工作簿

Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Dim Rg As MSExcel.Range = Ws.Cells
Rg.WrapText = True
'Rg.EntireColumn.AutoFit   '自动调整列宽
Rg.EntireRow.AutoFit  '自动调整行高
App.Visible = True

你可以这样做。这句代码去掉 Rg.WrapText = True

然后，你在细节区那里，设置单元格格式->勾选自动换行。

你要重复打印表头？设置一下

    Ws.PageSetup.PrintTitleRows = Ws.Rows(5:8).Address '打印行标题(在每一页的顶部重复出现)