How to save .xls file using OpenXML in dot net core?

Question

I want to create a .xls file using OpenXML SDK. I am able to create .xlsx and .xlsm files but when i save it as .xls and open in my system it pops an error. Then I have to do save as again for it to work properly. Is there any way to save files directly in .xls format?

Durga Prasad · Accepted Answer · 2020-07-14 18:12:44Z

1

Simple answer is No, you cannot do it.

The reason being .xls format is proprietary to Microsoft. OpenXml SDK cannot understand or write to that format. If you want to store data in .xls format, then you need to use Microsoft office excel interop objects.

Excel namespace interop

If you indeed want to take the route of adding interops to your application to save to .xls format, I would also suggest you to look into following SO answer because adding reference to interop objects in .NET core is not straight forward.

ms interop in .net core

answered Jul 14, 2020 at 18:12

Durga Prasad

1,00912 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to save .xls file using OpenXML in dot net core?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related