I faced 2 problem while using aspose.excel.
Firstly,I managed to export the data into excel format, and managed to save it to disk. But once i open the excel file, error occurs with this message in the pop up window :An error occurred initializing the VBA libraries.
If I continue open it, these messages will be shown:
Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\Documents and Settings\doris\Desktop\MediaPlan\MediaPlan2.xls'
The following is a list of repairs:
Lost Visual Basic project.
Lost supporting data on one or more objects.
How to fix it? Is it my coding problem or i need to install/reinstall my excel?I have tried to click the export excel file link from another computer, it gave the same error too.
I am using simple codes to test it.
Dim licenseFile As String = ConfigurationSettings.AppSettings("AsposeLicenseFile")Dim excel As Excel = New Excel(licenseFile)
Dim designerFile As String = ConfigurationSettings.AppSettings("AsposeExcelURL")excel.Open(designerFile)
Dim sheet As Worksheet = excel.Worksheets(0)
sheet.Cells("b5").PutValue("Advertiser")
sheet.Cells("b6").PutValue("Agency")
excel.Save("MediaPlan.xls", SaveType.OpenInExcel, FileFormatType.Default, Me.Response)
My 2nd problem is, if I click to open the excel file instead of save it, i need to click twice in order to open it, why?
My development environment is Dotnetnuke 3.0.13 framework, VB.Net, aspose.excel 2.4.2.0
Any helps will be much appreciated. Thanks in advance.