Import Export Excel

Name: C# Excel Library - IronXL
Rating: 4.81 (173 reviews)

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

Install-Package IronXL.Excel

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.

Previous Example

Next Example

Ready to get started? Version: 2022.9 just released

View Licenses >