Excel单元格中已经自动换行了,但是显示的内容不完整,大多数是显示了一半。请问该怎么办?
请问是我代码的问题,还是我的excel模板设置的问题?谢谢!!
代码如下:
Dim Book As New XLS.Book(ProjectPath & "Attachments\分析报告zsy.xls") '打开模板
Dim fl As String = ProjectPath & "Reports\分析报告zsy.xls"
Book.Build() '生成报表
Book.Save(fl)
Dim Proc As New Process
Proc.File = fl
Proc.Start()
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 '自动调整行高
App.Visible = True