Generated Excel through Spreadsheet XML via Windows Service still throws different format warning

Question

0.00/5 (No votes)

See more:

I am generating an Excel file through the API outlined in http://msdn.microsoft.com/en-us/library/office/aa140066(v=office.10).aspx[^]. I believe the file name for this format is XLS.

It is generated and emailed through a Windows Service and not ASP.NET download via browser. But still when I open the attachment it throws a warning in excel that the file is different format than the extension (mimetype) conveys.

I admit that the shell hardening feature is meaningful when I export a HTML and emit as XLS or CSV but I am using a valid spreadsheet XML so can some one help me in understand what is still causing this error to crop up?

Posted 3-Apr-13 5:48am

Vasudevan Deepak Kumar

Add a Solution

Comments

Kenneth Haugland 3-Apr-13 12:00pm

ITs a faily old excel format, but your approach for generating the file seems to be cumebersome, at least to me. Since you are using a WCF service, I mean.

Vasudevan Deepak Kumar 3-Apr-13 13:15pm

What do you recommend for the new formats?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sergey Alexandrovich Kryukov · Answer 1 · 2013-04-03T07:41:00

Vasudevan Deepak Kumar wrote:
What do you recommend for the new formats?

The XLS Excel format is quite obsolete, but you still can use it. Let's start from the very beginning.

You are recommended to support new XML-based Office formats (such as .DOCX, .XLSX), ECMA-376 standard:
http://en.wikipedia.org/wiki/Microsoft_Office_XML_formats[^],
http://en.wikipedia.org/wiki/Office_Open_XML[^].

You can either use Microsoft Office Interop assemblies which are installed when you install Office components, but you can better do it in a way not depending of Office installation; you can use Open XML SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=30425[^].

Also, the documents are supported by 3rd-party software. Please see my past answers:
Convert Office-Documents to PDF without interop[^],
Need a rather unique WPF text editor control[^],
Hi how can i display word file in windows application using c#.net[^],
Read a word file without using Interop.word dll...Do not want to install word in IIS..[^].

This is another option: http://npoi.codeplex.com/[^].

—SA