For Excel 2007(Xlsx)

Aspose.Cells Product Family
1

Hi,

For Excel 2003 aspose.cells.dll is working fine. I need to upgrade to excel 2007 which is not supported by this dll. Iam using aspose.cells.dll Version 4.4. There are changes to be done in code.

_xlWorkbook = new Excel(); // Has to be modified.

changed to

_xlWorkbook = new ExcelWorkbook(();

I am getting error in

_xlWorkbook.Open(fullFilename ,fft );

cannot convert FileFormatType to string.

Please help me in this regard.

Thanks in advance,

cracks

2

Hi,

Thanks for considering Aspose.

Kindly use the latest version 4.4.3 in which we have done some more enhancements related Excel 2007: http://www.aspose.com/community/files/51/file-format-components/aspose.cells/entry121851.aspx

Following is my testing code which works fine with the template file:

Workbook workbook = new Workbook();
workbook.Open("d:\\test\\template.xlsx",FileFormatType.Excel2007Xlsx);
workbook.Worksheets["Sheet1"].Cells["A1"].PutValue("Testing...");
workbook.Save("d:\\test\\outbook.xlsx",FileFormatType.Excel2007Xlsx);

If you still find the problem, kindly post your template .xlsx file, we will check it soon.

Thank you.