Workbooks.Open(xlsPath) failed

[Yujin Wu]

Hi Team,

I want to open an .xlsx file and save it to .csv format, however error throws out when it is executed
at the code .Workbooks.Open(xlsPath);

below is my code:

            using (ExcelEngine excel = new ExcelEngine()) {
                IApplication app = excel.Excel;
                IWorkbook workbook = app.Workbooks.Open(xlsPath);
                workbook.Worksheets[0].SaveAs(csvPath, ",", Encoding.Default);
                workbook.Close();
            }

Could you help figure out what's wrong with it, could you paste correct code?

Thanks,
Wuyj

Attachment: ZZD_ZC_0725_fb5cf726.zip

[Yujin Wu]

The problem is resolved when I updated the version to 12.2.0.36.

[Dilli Babu Nandha Gopal]

Hi Yujin,

Thanks for Updating us, regarding this issue.This issue has been fixed and let us know if have any concern.

Regards,

Dilli babu

[Bill Penrose]

Using this example I have run the code below but nothing appears in the form. I am missing something obvious. The datatable definitely has rows and items.

http://www.syncfusion.com/kb/1937/how-do-i-create-a-simple-spreadsheet-using-xlsio

Private Sub frmMaster_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Shown
     
 If DSMaster.Tables.Count = 0 Then
            GetSpreadsheet(MasterFile, DSMaster)
        End If

        ' A new instance of the Excel Application is created
        Dim excelEngine As New ExcelEngine()
        Dim application As IApplication = excelEngine.Excel
        application.DefaultVersion = ExcelVersion.Excel97to2003
        ' A new workbook object [bookOne] is created
        Dim bookOne As IWorkbook = excelEngine.Excel.Workbooks.Create(1)
        Dim sheet As IWorksheet = bookOne.Worksheets(0)

        sheet.ImportDataTable(DSMaster.Tables("Master"), True, 1, 1, -1, -1) ', True)
 
End Sub