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.
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.
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
0
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.
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.