C Sharp Export to Excel

Photo by Campaign Creators

Originally Posted On: https://ironsoftware.com/csharp/excel/docs/questions/c-sharp-export-to-excel/

It is necessary to work with different formats of Excel spreadsheets and use C Sharp Export to Excel functionalities. Projects may need to use spreadsheet data in specific formats, including .xml, .csv, .xls, .xlsx , and .json. In this tutorial, we will learn how to export Excel spreadsheet data into different formats using C#.

• Export to XLSX
• Export to XLS
• Export to CSV
• Export to XML
• Export to JSON

Export to XLSXVB  C#

1. using IronXL;
2. static void Main(string[] args)
3. {
4. WorkBook wb = WorkBook.Load(“XlsFile.xls”);//Import .xls, .csv, or .tsv file
5. wb.SaveAs(“NewXlsxFile.xlsx”);//Export as .xlsx file
6. }

Copy code to clipboardJump to Article Try IronXL free for development  Download Free

• Get the IronXL Library
• Export to XLSX files for C#
• C Sharp Export to CSV
• C# Export Excel XML files
• Export JSON file format and more

Video Link

For an easy way to work with Excel files in .NET Core, try IronXL. Download IronXL DLL or install with NuGet for free use in development projects.

PM > Install-Package IronXL.Excel

Download and add its reference in your project. IronXL classes can be accessed using IronXL namespace.

IronXL provides the most accessible way to export the data to Excel with ( .xls, .xlsx and .csv) files in .NET applications. It is also possible to export the data to .json and .xml files. Let’s see one by one how easy it can be to export Excel file data into these formats.

It is very easy to export an Excel file with an .xlsx extension. Let’s see the example. In the code below, our XlsFile.xls file exists in bin>Debug folder of the project.

Remember: Don’t forget to write extension with file name while importing or exporting.

By default, new Excel files will be created in the bin>Debug folder of the project. If we want to create a new file in a custom path then we can use wb.SaveAs(@”E:IronXLNewXlsxFile.xlsx”);. Read the tutorial here to learn more about how to export Excel files in .NET.

1. using IronXL;
2. static void Main(string[] args)
3. {
4. WorkBook wb = WorkBook.Load(“XlsFile.xls”);//Import .xls, .csv, or .tsv file
5. wb.SaveAs(“NewXlsxFile.xlsx”);//Export as .xlsx file
6. }

Copy code to clipboardVB  C#

It is also possible to export a file with the .xls extension using IronXL. For this purpose, lets see the example below.

1. using IronXL;
2. static void Main(string[] args)
3. {
4. WorkBook wb = WorkBook.Load(“XlsxFile.xlsx”);//Import .xlsx, .csv or .tsv file
5. wb.SaveAs(“NewXlsFile.xls”);//Export as .xls file
6. }

Copy code to clipboardVB  C#

We can easily export our .xlsx or .xls file into .csv using IronXL. Let’s see one case that shows how to export Excel file to CSV (.csv) file.

1. using IronXL;
2. static void Main(string[] args)
3. {
4. WorkBook wb = WorkBook.Load(“sample.xlsx”); //Import .xlsx or xls file
5. wb.SaveAsCsv(“NewCsvFile.csv”); //Export as .xls file
6. }

Copy code to clipboardVB  C#

The above code will create the following three CSV files:

It is very simple to understand why it created three .csv files. It is because sample.xlsx contains three Worksheets. Therefore, it will create three .csv files, and each Worksheet’s Excel file data would export to the corresponding .csv file.

We can see the number of sheets in sample.xlsx here:

However, if there is one worksheet in the Excel file, then just one .csv file would be created.

We can export our Excel file data into .XML file format. The below code will export sample.xlsx file data into a .xml file. It will create three XML files because sample.xlsx has three worksheets, same as in the earlier example.

1. using IronXL;
2. static void Main(string[] args)
3. {
4. WorkBook wb = WorkBook.Load(“sample.xlsx”); //Import .xlsx, .xls or .csv file
5. wb.SaveAsCsv(“NewXmlFile.xml”); //Export as .xml file
6. }

Copy code to clipboardVB  C#

Using IronXL makes it very easy to export Excel file data into JSON file format, as in the below code example. The code will export sample.xlsx file data into a .json file. It will again create three .json files due to the three Workheets of sample.xlsx.

1. using IronXL;
2. static void Main(string[] args)
3. {
4. WorkBook wb = WorkBook.Load(“sample.xlsx”); //import Excel file
5. wb.SaveAsJson(“NewjsonFile.json”); //Export as JSON file
6. }

Copy code to clipboardVB  C#

Read the IronXL Documentation including all namespaces, feature sets, methods fields, classes, and enums.

Read Object Reference