主题：excel报表

做个按钮

Dim Book As New XLS.Book(ProjectPath & "Attachments\订单.xls")
Dim fl As String = ProjectPath & "Reports\订单.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.EntireColumn.AutoFit   '自动调整列宽
Rg.EntireRow.AutoFit  '自动调整行高
'Rg.WrapText = True
'rg.ShrinkToFit = True
App.Visible = True

你模板那里，对于要设置自动行高的单元格，要设置一下单元格的格式->勾选自动换行

呃，你不要合并单元格，合并单元格是不能再自动换行的。