This is a migrated thread and some comments may be shown as answers.

Exporting to Excel. Error about the format

1 Answer 60 Views
Grid
This is a migrated thread and some comments may be shown as answers.
TedH
Top achievements
Rank 1
TedH asked on 19 Apr 2010, 10:38 PM
I know this has been posted and reposted to this forum but I wanted to bring it up again just in case there's some new work-around.

When using the RadGrid control if I allow the user to export to Excel when I try to open the file that's generated I get the following message.

"The file you are trying to open, '[filename]', is in a different format" Excel Error


If I export is as .xls or .xlsx I get the same message.
I get this message every time I open the file.

The following page is pointed to by admins on this site, but it really just blames the problem on Microsoft.

http://www.grinn.net/blog/dev/2008/06/file-you-are-trying-to-open-is-in.html

Anyone know a way around this that works? Can the grid export an Excel file that Excel actually likes?

Thanks.



1 Answer, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 20 Apr 2010, 01:30 PM
Hello Ted,

Here is what Microsoft says (and suggests) about this warning:
Excel 2007 Extension Warning On Opening Excel Workbook from a Web Site

Unfortunately there is no feasible way to avoid the warning using server-side approach.

Quote from Grinn's blog:
"After searching for hours, I finally ran into this document from MS that essentially says this is a "feature" of the new Excel and no matter how much everyone hates it, they won't fix it. Here's an excerpt from that document:..."


Regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
Grid
Asked by
TedH
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Share this question
or