Free Support Forum - aspose.com

Creating MS office 2007 compatible excel

Hi,
I am currently using aspose.cells to create excel files.
How do i create Office 2007 compatible files using cells, also how do i convert a .xls file to the new excel format ?

regards,
Jaideep.

Hi,

Thanks for considering Aspose.

Please check the following for your reference:

Saving an Excel File

Opening an Excel File

Example:

Workbook workbook =new Workbook();

Worksheet worksheet = workbook.Worksheets[0];

Cells cells = worksheet.Cells; 

cells.Merge(0, 248, 1, 100);

cells[0,248].PutValue("Hello World!"); 

cells[1048575,16383].PutValue("Last Cell"); 

workbook.Save("d:\\test\\mybook.xlsx",FileFormatType.Excel2007Xlsx); 

how do i convert a .xls file to the new excel format ?

It’s very easy. Please check the following example for your reference:

Workbook workbook =new Workbook();

workbook.Open("d:\\test\\abc.xls");

Worksheet worksheet = workbook.Worksheets[0];

Cells cells = worksheet.Cells; 

cells[100,1].PutValue("Hello World!"); 

workbook.Save("d:\\test\\mybook.xlsx",FileFormatType.Excel2007Xlsx); 

Thank you.