Hello,
I have Aspose.cells version 8.2.2.0 and i am not able to export any excel using latest office.
does this version support office 2016 or we need to upgrade ?
Hi,
Thanks for your posting and considering Aspose.Cells.
Aspose.Cells does support Excel 2016. However in order to see if the older version 8.2.2.0 also supports it, please test your issue with the following sample code and see if it the output excel file opens fine in Excel 2016.
If the output excel file opens fine then you do not need to upgrade. I have also attached the sample project which uses 8.2.2.1 version and the output excel file created by it for your reference.
C#
//Create workbook in XLSX format
Workbook wb = new Workbook(FileFormatType.Xlsx);
//Access first worksheet and add some data inside it
Worksheet ws = wb.Worksheets[0];
Cell cell = ws.Cells[“C5”];
cell.PutValue(“This is some sample data.”);
//Set the font color red
Style st = cell.GetStyle();
st.Font.Color = Color.Red;
cell.SetStyle(st);
//Save the workbook in XLSX format. It should open fine in Office 2016
wb.Save(CellsHelper.GetVersion() + “-output.xlsx”, SaveFormat.Xlsx);