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")
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.