Category / Section
Does XlsIO support 2013 format file
1 min read
Yes. XlsIO supports Excel 2013 format by setting workbook version as ExcelVersion.2013.
C#
workbook = application.Workbooks.Open(inputPath,ExcelOpenType.Automatic); //The first worksheet object in the worksheets collection is accessed. IWorksheet worksheet = workbook.Worksheets[0]; fileName = "CreateSpreadsheet.xlsx"; workbook.Version = ExcelVersion.Excel2013; workbook.SaveAs(“Output.xlsx”);
VB
workbook = application.Workbooks.Open(inputPath, ExcelOpenType.Automatic) 'The first worksheet object in the worksheets collection is accessed. Dim worksheet As IWorksheet = workbook.Worksheets(0) fileName = "CreateSpreadsheet.xlsx" workbook.Version = ExcelVersion.Excel2013 workbook.SaveAs(“Output.xlsx”);
Please refer to the sample here.