Excel Import

Dear Support

When we try to import the excel file then getting error message “This file's format is not supported or you don't specify a correct format.” Please find here the excel file and provide us the solution for it. We need to import this file and then save as CSV format.

Product use – Aspose.cells for .Net

Version – 4.8.2.0

With Regards,

Mehul Panchal

Truetzschler

Manager (IT)

India


This message was posted using Email2Forum by salman.sarfraz.

Hi,

Thanks for providing us the sample file.

When I open your template file “QA_CMM0.xls” in MS Excel(2003), I can see it’s format type is old i.e…, “Microsoft Excel 2.1 Worksheet”. For your information, Aspose.Cells only supports BIFF8 and greater formats (MS Excel 97 - 2010).

To enable Aspose.Cells open the file fine, you need to save it as “Microsoft Office Excel Workbook”. The procedure is very simple:

Open the file into MS Excel (e.g 2003) and Save it As “Microsoft Office Excel Workbook”. I did convert it and it works fine using the code.

Workbook book = new Workbook();
book.Open(“e:\test\QA_CMM0.xls”);
book.Save(“e:\test\OutFile.csv”, FileFormatType.CSV);

Thank you.