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:
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.