This brief article covers how to convert XML to CSV using C#. It explains the environment setup, stepwise program flow, and a runnable sample code to convert XML to CSV using C#. Furthermore, any plugin or application installation is not required to integrate this feature into your project.
Steps to Convert XML to CSV using C#
- Set up the system environment to work with Aspose.Cells for .NET to convert XML files to CSV
- Create a Workbook class object to load the source XML file
- Export the output CSV file from the source XML file using the SaveFormat enum
These steps present the whole process to transform XML to CSV using C#. The process is started by loading the source XML file. Subsequently, it exports the generated comma-separated file to a stream or the disk based on your needs.
Code to Transform XML to CSV using C#
| using Aspose.Cells; | |
| using System; | |
| class Program | |
| { | |
| static void Main(string[] args) // Convert XML to CSV in C# | |
| { | |
| // Set the license | |
| new License().SetLicense("Aspose.Total.Product.Family.lic"); | |
| // Load XML file | |
| Workbook book = new Workbook("input.xml"); | |
| // Convert to XLSX | |
| book.Save("xml-to-csv.csv", SaveFormat.Csv); | |
| Console.WriteLine("Done"); | |
| } | |
| } |
This code snippet is a basic version to convert XML to CSV in Excel using C#. First of all, the source XML file is loaded with a Workbook class instance and then the Save() method is invoked while passing the value from SaveFormat enumeration. Besides, after loading the XML data into a Workbook object, you may edit or modify the file by adding or deleting the rows and columns before converting it to a CSV file.
This tutorial has elaborated on how to export XML to CSV using C#. If you are interested to learn deleting a column in Excel then read the article on how to delete a column in Excel using C#.
