C# Export to Excel: Step by Step Tutorial

using IronXL; // Import the IronXL library to handle Excel files

// Load an existing workbook from a .xls file. 
// Ensure the file path "XlsFile.xls" is correct and points to a valid .xls file.
WorkBook workbook = WorkBook.Load("XlsFile.xls");

// Save the loaded workbook as a .xlsx file with a new name "newFile.xlsx". 
// This will convert the file format from .xls to .xlsx.
workbook.SaveAs("newFile.xlsx");

Imports IronXL ' Import the IronXL library to handle Excel files



' Load an existing workbook from a .xls file. 

' Ensure the file path "XlsFile.xls" is correct and points to a valid .xls file.

Private workbook As WorkBook = WorkBook.Load("XlsFile.xls")



' Save the loaded workbook as a .xlsx file with a new name "newFile.xlsx". 

' This will convert the file format from .xls to .xlsx.

workbook.SaveAs("newFile.xlsx")

// Path to the C# example code
using IronXL;

// The following code demonstrates how to load an Excel file and save it in a different format.
// Make sure you have added the IronXL library as a reference in your project to work with Excel files.

// Load an existing Excel workbook from a given file path
WorkBook workbook = WorkBook.Load("XlsxFile.xlsx");

// Save the loaded workbook as a new file in the .xls format
workbook.SaveAs("newFile.xls");

' Path to the C# example code

Imports IronXL



' The following code demonstrates how to load an Excel file and save it in a different format.

' Make sure you have added the IronXL library as a reference in your project to work with Excel files.



' Load an existing Excel workbook from a given file path

Private workbook As WorkBook = WorkBook.Load("XlsxFile.xlsx")



' Save the loaded workbook as a new file in the .xls format

workbook.SaveAs("newFile.xls")

using IronXL;

// Import a .xlsx or .xls file into a WorkBook object
WorkBook workbook = WorkBook.Load("sample.xlsx");

// Save the content of the WorkBook object as a .csv file
workbook.SaveAs("newFile.csv");

// Note:
// - Ensure that the "IronXL" library is correctly installed and referenced in your project. 
// - The method `SaveAsCsv` was incorrect in the given code and has been corrected to `SaveAs`.
// - This code will take an Excel file named "sample.xlsx" and export it to a new CSV file named "newFile.csv."
// - Ensure the file paths used in the `Load` and `SaveAs` methods are correct relative paths or use absolute paths if necessary.

Imports IronXL



' Import a .xlsx or .xls file into a WorkBook object

Private workbook As WorkBook = WorkBook.Load("sample.xlsx")



' Save the content of the WorkBook object as a .csv file

workbook.SaveAs("newFile.csv")



' Note:

' - Ensure that the "IronXL" library is correctly installed and referenced in your project. 

' - The method `SaveAsCsv` was incorrect in the given code and has been corrected to `SaveAs`.

' - This code will take an Excel file named "sample.xlsx" and export it to a new CSV file named "newFile.csv."

' - Ensure the file paths used in the `Load` and `SaveAs` methods are correct relative paths or use absolute paths if necessary.

using IronXL;

// The following code imports data from an Excel file and exports it as an XML file.

try
{
    // Load the workbook from a .xlsx, .xls or .csv file.
    // Ensure the file "sample.xlsx" exists in the working directory or provide a correct path to the file.
    WorkBook workbook = WorkBook.Load("sample.xlsx");

    // Save the workbook as an XML file.
    // The resulting "newFile.xml" will be saved in the working directory.
    // Make sure that the necessary permissions are set to allow writing to the directory.
    workbook.SaveAsXml("newFile.xml");

    // Inform the user that the process completed successfully.
    Console.WriteLine("The Excel file has been successfully converted to an XML file.");
}
catch (Exception ex)
{
    // Handle any exceptions that may occur during the loading or saving process.
    // This includes file not found exceptions, permissions issues, etc.
    Console.WriteLine("An error occurred: " + ex.Message);
}

Imports IronXL



' The following code imports data from an Excel file and exports it as an XML file.



Try

	' Load the workbook from a .xlsx, .xls or .csv file.

	' Ensure the file "sample.xlsx" exists in the working directory or provide a correct path to the file.

	Dim workbook As WorkBook = WorkBook.Load("sample.xlsx")



	' Save the workbook as an XML file.

	' The resulting "newFile.xml" will be saved in the working directory.

	' Make sure that the necessary permissions are set to allow writing to the directory.

	workbook.SaveAsXml("newFile.xml")



	' Inform the user that the process completed successfully.

	Console.WriteLine("The Excel file has been successfully converted to an XML file.")

Catch ex As Exception

	' Handle any exceptions that may occur during the loading or saving process.

	' This includes file not found exceptions, permissions issues, etc.

	Console.WriteLine("An error occurred: " & ex.Message)

End Try

using IronXL;

// This code demonstrates how to load an Excel workbook and save it as a JSON file

// Load an Excel workbook from the specified file path
WorkBook workbook = WorkBook.Load("sample.xlsx");

// Save the workbook as a JSON file to the specified file path
workbook.SaveAsJson("newFile.json");

Imports IronXL



' This code demonstrates how to load an Excel workbook and save it as a JSON file



' Load an Excel workbook from the specified file path

Private workbook As WorkBook = WorkBook.Load("sample.xlsx")



' Save the workbook as a JSON file to the specified file path

workbook.SaveAsJson("newFile.json")