Free Support Forum - aspose.com

Opening xlsx (Excel 2007 Format) using WorkbookDesigner

I notice that a Workbook object can open an xlsx using the following:

Workbook workbook = new Workbook();

		<p style="margin: 0pt; line-height: 14.4pt;"><span style="font-family: 'Courier New'; font-size: 8.5pt;">workbook.Open("C:\\book1.xlsx", FileFormatType.Excel2007Xlsx);</span></p><p style="margin: 0pt; line-height: 14.4pt;"><br><span style="font-family: 'Courier New'; font-size: 8.5pt;"></span></p><p style="margin: 0pt; line-height: 14.4pt;">But I don't notice such overloaded Open method in the WorkbookDesigner class. In other words, what I want is something like this:<br></p><br><p style="margin: 0pt; line-height: 14.4pt;"><span style="font-family: 'Courier New'; font-size: 8.5pt;">WorkbookDesigner wd = new </span><span style="font-family: 'Courier New'; font-size: 8.5pt;">WorkbookDesigner</span><span style="font-family: 'Courier New'; font-size: 8.5pt;">();</span></p>

wd.Open("C:\\book1.xlsx", FileFormatType.Excel2007Xlsx);


We'd like to know if Aspose Cells supports SmartMarker in Excel 2007 files. We are currently evaluating the product and this is a major blocker for us to move forward.

- Jason Chan

Hi Jason,

Thanks for considering Aspose.

Yes, Aspose.Cells supports smart markers for MS Excel 2007 format too. The WorkbookDesigner internally uses Workbook object to open any type of template Excel file (xls, xlsx etc.).

Please check the following sample code:

WorkbookDesigner wd = new WorkbookDesigner();
wd.Workbook.Open("d:\\test\\MyTemplate.xlsx",FileFormatType.Excel2007Xlsx);
wd.SetDataSource(dt);
wd.SetDataSource(dt1);
wd.Process();
wd.Save("d:\\test\\outBook.xlsx",FileFormatType.Excel2007Xlsx);

Thank you.