Make data downloadable in Excel XLSX format.

Is there a way to have data on a webpage downloaded in an xlsx file format?

Anything I see seems to do xls (in which Excel warns you about opening the file) or csv... which is non formatted, etc.

Thanks
Sheldon LivingstonConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
If you can download it in xls file format you can then easily save it in xlsx format.
Ryan ChongSoftware Team LeadCommented:
Make data downloadable in Excel XLSX format.
another way would be to create that Excel (xlsx) at server side and then stream it back to browser. that would also protect your data in some sense as you no need to store the data as a hyperlink in your web portal.
Chinmay PatelChief Technology NinjaCommented:
Hi Sheldon,

There are many ways you can go about it. I would list the one which I have heavily used over the period of years.
1. Open XML SDK - https://docs.microsoft.com/en-us/office/open-xml/open-xml-sdk - This is the one that I have used the most, It has a really difficult learning curve but if you want a sure shot solution, this is the way to go.
2. NPOI - https://github.com/tonyqus/npoi - This is a short cut and I have been using this library of late - and it serves the purpose most of the times.

There is another open source library which I have heard of but have never used in my mainstream engagements and that is https://github.com/JanKallman/EPPlus

Each of these libraries have sample code available which you can use to generate XSLX files.

Additionally, all of the above are non COM / non InterOP i.e. they are managed codes and you can use them with confidence (at least Open XML SDK).

Regards,
Chinmay.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sheldon LivingstonConsultantAuthor Commented:
Thank you... I'm going to pursue the SDK.
Chinmay PatelChief Technology NinjaCommented:
Glad I could help. All the best.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.