Convert a xml to xlsx in C#

Question

I have a large grid and i need those data exported to excel.i implemented my solution using openxml, however having nested loops fill each row's columns to set cell values is time consuming.

I'm now trying to export it to xml and then export to xlsx to improve performance.i converted the dataset to xml, now i'm stuck with converting to xlsx. is there a way to convert to xlsx without having nested loops to fill each cell value ?

UPDATE : I was able to do it using following library -

Open XML Format SDK 2.0 Sample - Convert XML to Excel File

Those two are totally different formats for different purposes. — marsze, Jun 26 '17 at 10:00
@marsze what would you suggest i should do in this scenario ? — Buddhima Naween Rathnayake, Jun 26 '17 at 10:10
Write your data directly to an Excel format using appropriate libraries. — marsze, Jun 26 '17 at 10:13
It's hard to tell what's going on without seeing your original code but it doesn't sound like converting your data to XML only to convert it to XLSX (which is XML) will be any quicker. Have you tried using a SAX approach with OpenXML? See [this answer](https://stackoverflow.com/a/32787219/3791802) for more details. — petelids, Jun 26 '17 at 12:48

score 0 · Accepted Answer · answered Jun 26 '17 at 10:05

0

There is no direct conversion, but your best bet if you have the XML is to deserialise this so you have access to the data via code, then build an Excel document using an Excel Library (e.g.: http://epplus.codeplex.com)

answered Jun 26 '17 at 10:05

Mark Redman

24,079
20
92
147

Convert a xml to xlsx in C#

1 Answers1