Convert XML file into Excel file in C# MVC

Question

I have an XML file  in which formatting and no. of columns.When i have export data into excel from XML file it is save as in Excel file. ScreenShot of Excel File : https://www.screencast.com/t/qqCVqRFL

Nilesh Shah · Answer

Hi I will suggest you to always post your existing code what you have done and what problem you are facing. This way it is better for others to answer

Hussam Barouqa · Answer

Consider using a professional toolkit like the LEADTOOLS SDK (https://www.leadtools.com/sdk/document/document-converter).This SDK has the ability to convert between different document formats including all of the Office documents such as XLS. Here is an example of how to use the DocumentConverters class to achieve this with minimal code: using ( DocumentConverter documentConverter = new DocumentConverter ()) { var format = DocumentFormat .Xls; var jobData = DocumentConverterJobs .CreateJobData(inFile outFile format); jobData.JobName = conversion job ; var job = documentConverter.Jobs.CreateJob(jobData); documentConverter.Jobs.RunJob(job); }

alice yang · Answer

Hello You can use Spire.XLS to easily convert XML to Excel. Code for your Reference: Workbook workbook = new Workbook(); workbook.LoadFromFile(@ ..\..	est.xml ); workbook.SaveToFile( result.xlsx ExcelVersion.Version2010); You can refer the below article for more information: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Export-Excel-to-XML-and-Import-XML-to-Excel.html

Vijay Kumar · Answer

I found two older post here on stackoverflow. I hope one of them will help: Create Excel (.XLS and .XLSX) file from C# What is the best way to store XML data in an Excel file