Articles in this section
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.

 

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied