Import Export Excel
IronXL allows you to Load and Save XLS, XLSX, CSV, TSV, JSON & XML files.
Each can be edited as if it were an Excel WorkSheet.
using IronXL;
//This is how you import excel file, same for xlsx
WorkBook workbook = WorkBook.Load("test.xls");
workbook.CreateWorkSheet("new_sheet");
workbook.Metadata.Title = "Import & Export Example";
//You can export to both formats with fluent saving
//Other supported formats for saving include: XLS, XLSX, CSV, TSV, JSON, XML
workbook.SaveAs("ExportAndImportToExcel.xls");
Imports IronXL
'This is how you import excel file, same for xlsx
Private workbook As WorkBook = WorkBook.Load("test.xls")
workbook.CreateWorkSheet("new_sheet")
workbook.Metadata.Title = "Import & Export Example"
'You can export to both formats with fluent saving
'Other supported formats for saving include: XLS, XLSX, CSV, TSV, JSON, XML
workbook.SaveAs("ExportAndImportToExcel.xls")
