Richard.Huang 发表于 2023-11-16 13:45
您好，能否将您的这份Excel文件提供一下，以及提供可以复现该问题的步骤，我们将详细复现后找出原因所在 ...
下面是测试代码，我上传不了文件、我拍了照片、你可以参照一下、图片是模板和Save之后的Excel文件，保存之后的文件里面的合计就不能显示出来
Public gobjSh_Print As IWorksheet
Function Main(args As String()) As Integer
Dim workbook = New Workbook()
workbook.Path = "F:\\test\\Test.xlsx"
workbook.Open("F:\\test\\Test.xlsx", OpenFileFormat.Xlsx)
gobjSh_Print = workbook.Worksheets("Test")
gobjSh_Print.Cells(0, 1).Value = 10
gobjSh_Print.Cells(0, 2).Value = 20
gobjSh_Print.Cells(0, 3).Value = 30
gobjSh_Print.Cells(0, 4).Value = 40
gobjSh_Print.Cells(1, 1).Value = 100
gobjSh_Print.Cells(1, 2).Value = 200
gobjSh_Print.Cells(1, 3).Value = 300
gobjSh_Print.Cells(1, 4).Value = 400
workbook.Save("F:\\test\\Test_001.xlsx")
Return 0
End Function |
陕公网安备：61019002000258 |
隐私政策 |
网站地图