How do I generate excel file using openxml-SDK v2.0 supporting to msoffice 2007

Question

1.00/5 (1 vote)

See more:

I was generated a excel file using Openxmlsdk dll(DocumentFormat.OpenXml-V2.6.0.0) and (System.IO.Packaging-V1.0.0.0) but i did not open in ms-office2007. but it is working fine with ms office 2010

What I have tried:

I was generated a excel file using Openxmlsdk dll(DocumentFormat.OpenXml-V2.6.0.0) and (System.IO.Packaging-V1.0.0.0) but i did not open in ms-office2007.

Posted 15-Nov-16 19:48pm

Raja Member 12850972

Updated 16-Nov-16 2:41am

Nelek

v2

Add a Solution

Comments

Philippe Mori 16-Nov-16 9:24am

This is almost the same question as Why the excel file is not open in office 2007 generated by using openxml SDK? Working in office 2010

Don't ask same question twice. It would be better to write one clear question than 2 unclear ones...

Philippe Mori 16-Nov-16 9:32am

Even worst, you wrote almost the same thing twice in this question.

And even worst, is that you absolutly don't provide any useful information that would allows us to help you.

Obviously, if you properly create your file it should open in any version of Excel... so if it does not open, something is wrong with your code.

You might consider using some package that wrap OpenXML and make it easier to use. There are many options that can easily be found by managing NuGet packages in Visual Studio.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2016-11-16T01:35:00

Solution 1

Have you tried saving the document as a XLS document instead of XLSX?

Posted 16-Nov-16 1:35am

#realJSOP

F-ES Sitecore · Answer 2 · 2016-11-16T02:41:00

Solution 2

Excel 2007 doesn't natively support xlst, you need an update for it.

https://support.microsoft.com/en-gb/kb/924074[^]

Posted 16-Nov-16 2:41am

F-ES Sitecore

Updated 16-Nov-16 2:42am

v2

Comments

Philippe Mori 16-Nov-16 9:37am

Excel 2003... which is not supported anymore. OP problem is that "bad" file support do vary between Excel version. Generally, we can probably assume that never versions are a bit more tolerant for some kind of errors.

How do I generate excel file using openxml-SDK v2.0 supporting to msoffice 2007

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How do I generate excel file using openxml-SDK v2.0 supporting to msoffice 2007

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us