Import Export Excel

VB C#

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

Try IronXL free for development

Download Free