We are evaluating Aspose.Cells for .Net in our company and we have faced a problem regarding custom styles and Office 2007 .xslx documents.
We have created a template xsls file (attached). Upon opening the xlsx file, we try to programmatically insert contents into the worksheet using the following code:
var workbook = new Workbook();
var worksheet = workbook.Worksheets;
worksheet.Cells[row, 2].Style = workbook.Styles["TableBorderCurrency"];
(where 'row' is an integer).
For some reason, the custom styles created in the template xlsx (such as the "TableBorderCurrency") are not available in the workbook.Styles collection. Hence the style is not applied
However, if we change the template workbook into xls (Office 97/2003) format, Aspose.Cells recognises the styles correctly.
Can you give us any help into how we could use styles with Excel 2007 workbooks?
With best regards,