CODEWITHSUNDEEP
c#excelopenxmlxlsxlsx
Alag
Alag

Reputation: 1408

Creating excel - improve performance

Good afternoon, we have a small problem with performance of generating excel.

Because we can load XML file from database, we tried used XSLT and from these two files create xls file. It is nice, but after open this file there is error message shown (it is because of problem or bug in registry). User has to accept this message and after excel is opened. We want to eliminate this error message. However we don't know how.

We was thinking about convert this xls file into xlsx but we are unable to do it becouse we can't install office on server (we cannot use Interop) and OpenXML libraries don't know work with normal xls file. So my question is:

  1. Is possible to generate from XML file with using of some XLST (or something) the xlsx file?
  2. Eventually can what files do we need to create and zip together if we want create xlsx file?

Thank you for information

Upvotes: 0

Views: 565

Answers (1)

Justin Killen
Justin Killen

Reputation: 737

You mention not being able to use the OpenXML libraries because they don't work with .xls files, but you also say "creating cell by cell", which implies that you are generating the file from scratch. Where is the xls file coming from? You mention excel opening, but then say you can't install it on the server. So, it appears to me that a user is uploading an xls file to your server, and then you are doing something with it and giving it back to them? If that is the case and you must be able to read/write an xls file without installing office, then I would suggest using ExcelLibrary, as mentioned in this post

Indeed, creating an xlsx file is much magnitudes faster with the open xml sdk.

Upvotes: 1

Related Questions