Export to Excel 2007

A

Amitabh

Hi All,
I have an web application where user can export the results of search action
to an excel file so he can locally store it.. I have done this with very
simple code which is
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("content-disposition", "attachment;
filename=StackRanking.xls");
Response.Charset = "";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new
System.Web.UI.HtmlTextWriter(sw);
(........fils dataset..... hw.RenderBeginTag)
(System.Web.UI.HtmlTextWriterTag.Html);
dg.RenderControl(hw);
hw.RenderEndTag();
Response.Write(sw);
Response.End();

All work fine when end user has Excel 2003 but when he has Excel 2007 it
gives a warning err message when he tries to open the rendered (downloaded)
Excel File,
I guess i need framework 3.0 to Support the file format of Excel 2007. What
in the code needs to be changed to have compatibility with Excel 2007
File.....

Thanks for reading my query...
 
J

Jim Rech

I'm not a .Net developer but I'd guess your code creates a text file. Excel
2007 is equally capable of opening a text file as Excel 2003 so that
shouldn't be a problem. Even if your code creates an Excel 2003 files
(.XLS) Excel 2007 can open that too.

So I don't know what the problem is, but a clue would probably be found in
the exact text of the error message which you should have included in your
message.

--
Jim
| Hi All,
| I have an web application where user can export the results of search
action
| to an excel file so he can locally store it.. I have done this with very
| simple code which is
| Response.ContentType = "application/vnd.ms-excel";
| Response.AppendHeader("content-disposition", "attachment;
| filename=StackRanking.xls");
| Response.Charset = "";
| System.IO.StringWriter sw = new System.IO.StringWriter();
| System.Web.UI.HtmlTextWriter hw = new
| System.Web.UI.HtmlTextWriter(sw);
| (........fils dataset..... hw.RenderBeginTag)
| (System.Web.UI.HtmlTextWriterTag.Html);
| dg.RenderControl(hw);
| hw.RenderEndTag();
| Response.Write(sw);
| Response.End();
|
| All work fine when end user has Excel 2003 but when he has Excel 2007 it
| gives a warning err message when he tries to open the rendered
(downloaded)
| Excel File,
| I guess i need framework 3.0 to Support the file format of Excel 2007.
What
| in the code needs to be changed to have compatibility with Excel 2007
| File.....
|
| Thanks for reading my query...
| --
| Software Engineer
|
 
A

Amitabh

Thanks Jim for reply,
Yeah sorry Jim I forgot to give the Error Message. Below is the Error
message.

The file your are trying to open, "StackRanking.xls, is in a different
format than specified by the file extension. Verify that the file is not
corrupted and is from a trusted source before opening the file. Do you want
to open the file now?
and with three Command Buttons viz.. Yes, No, Help..

On hitting yes everything goes smoothly and opens correctly but the above
error message may confuse our clients...so I'm lookin for a way to avoid the
above error message.

And yes Jim, the code creates a HTML Text file I'll give you a little glance
of it when open that XLS file in notepad

<html>
<table cellspacing="0" rules="all" border="1"
style="border-collapse:collapse;">
<tr><td>ProposalId</td></tr>
<tr><td>11070</td></tr>
</table>
</html>
 
J

Jim Rech

Ahh, yes Excel 2007 'protects' users from opening files that do not have the
format that their file extensions suggest. If the file is an HTML file any
reason not to give it the HTM extension?

--
Jim
| Thanks Jim for reply,
| Yeah sorry Jim I forgot to give the Error Message. Below is the Error
| message.
|
| The file your are trying to open, "StackRanking.xls, is in a different
| format than specified by the file extension. Verify that the file is not
| corrupted and is from a trusted source before opening the file. Do you
want
| to open the file now?
| and with three Command Buttons viz.. Yes, No, Help..
|
| On hitting yes everything goes smoothly and opens correctly but the above
| error message may confuse our clients...so I'm lookin for a way to avoid
the
| above error message.
|
| And yes Jim, the code creates a HTML Text file I'll give you a little
glance
| of it when open that XLS file in notepad
|
| <html>
| <table cellspacing="0" rules="all" border="1"
| style="border-collapse:collapse;">
| <tr><td>ProposalId</td></tr>
| <tr><td>11070</td></tr>
| </table>
| </html>
| --
| Software Engineer,
| Cybage Software Pvt. Ltd.
| Pune, India
|
|
| "Jim Rech" wrote:
|
| > I'm not a .Net developer but I'd guess your code creates a text file.
Excel
| > 2007 is equally capable of opening a text file as Excel 2003 so that
| > shouldn't be a problem. Even if your code creates an Excel 2003 files
| > (.XLS) Excel 2007 can open that too.
| >
| > So I don't know what the problem is, but a clue would probably be found
in
| > the exact text of the error message which you should have included in
your
| > message.
| >
| > --
| > Jim
| > | > | Hi All,
| > | I have an web application where user can export the results of search
| > action
| > | to an excel file so he can locally store it.. I have done this with
very
| > | simple code which is
| > | Response.ContentType = "application/vnd.ms-excel";
| > | Response.AppendHeader("content-disposition", "attachment;
| > | filename=StackRanking.xls");
| > | Response.Charset = "";
| > | System.IO.StringWriter sw = new System.IO.StringWriter();
| > | System.Web.UI.HtmlTextWriter hw = new
| > | System.Web.UI.HtmlTextWriter(sw);
| > | (........fils dataset..... hw.RenderBeginTag)
| > | (System.Web.UI.HtmlTextWriterTag.Html);
| > | dg.RenderControl(hw);
| > | hw.RenderEndTag();
| > | Response.Write(sw);
| > | Response.End();
| > |
| > | All work fine when end user has Excel 2003 but when he has Excel 2007
it
| > | gives a warning err message when he tries to open the rendered
| > (downloaded)
| > | Excel File,
| > | I guess i need framework 3.0 to Support the file format of Excel 2007.
| > What
| > | in the code needs to be changed to have compatibility with Excel 2007
| > | File.....
| > |
| > | Thanks for reading my query...
| > | --
| > | Software Engineer
| > |
| >
| >
| >
 
A

Amitabh

Yep Jim, I tired it by changing Extension and Excel 2007 can open it without
any error but I have to first save it and then manually open it in Excel 2007
becaues by default .htm Extension are associated with IE and on directly
opening, it opens up in IE.
Jim, If there is any way to force from Server Application to directly open
file in Excel 2007, then it would solve the query.

Cindy Meister (Word MVP) Suggested me an alternative and I am working on it
too.
Please folloiw the link for her solution.
http://forums.microsoft.com/MSDN/showpost.aspx?postid=1469919&siteid=1
 
J

Jim Rech

Sorry so slow to respond to you.

I have one workaround you might consider. The warning you get opening in
Excel 2007 is controlled by a registry entry that is read just when a file
is opened in Excel. So you could set the entry, open the file and reset the
registry back.

HKCU\Software\Microsoft\Office\12.0\Excel\Security\ExtensionHardening

Set this to 0 to bypass warning. Set to 1 or delete to re-establish the
warning.


--
Jim
| Yep Jim, I tired it by changing Extension and Excel 2007 can open it
without
| any error but I have to first save it and then manually open it in Excel
2007
| becaues by default .htm Extension are associated with IE and on directly
| opening, it opens up in IE.
| Jim, If there is any way to force from Server Application to directly open
| file in Excel 2007, then it would solve the query.
|
| Cindy Meister (Word MVP) Suggested me an alternative and I am working on
it
| too.
| Please folloiw the link for her solution.
| http://forums.microsoft.com/MSDN/showpost.aspx?postid=1469919&siteid=1
|
| --
| Software Engineer,
| Cybage Software Pvt. Ltd.
| Pune, India
|
|
| "Jim Rech" wrote:
|
| > Ahh, yes Excel 2007 'protects' users from opening files that do not have
the
| > format that their file extensions suggest. If the file is an HTML file
any
| > reason not to give it the HTM extension?
| >
| > --
| > Jim
| > | > | Thanks Jim for reply,
| > | Yeah sorry Jim I forgot to give the Error Message. Below is the Error
| > | message.
| > |
| > | The file your are trying to open, "StackRanking.xls, is in a different
| > | format than specified by the file extension. Verify that the file is
not
| > | corrupted and is from a trusted source before opening the file. Do you
| > want
| > | to open the file now?
| > | and with three Command Buttons viz.. Yes, No, Help..
| > |
| > | On hitting yes everything goes smoothly and opens correctly but the
above
| > | error message may confuse our clients...so I'm lookin for a way to
avoid
| > the
| > | above error message.
| > |
| > | And yes Jim, the code creates a HTML Text file I'll give you a little
| > glance
| > | of it when open that XLS file in notepad
| > |
| > | <html>
| > | <table cellspacing="0" rules="all" border="1"
| > | style="border-collapse:collapse;">
| > | <tr><td>ProposalId</td></tr>
| > | <tr><td>11070</td></tr>
| > | </table>
| > | </html>
| > | --
| > | Software Engineer,
| > | Cybage Software Pvt. Ltd.
| > | Pune, India
| > |
| > |
| > | "Jim Rech" wrote:
| > |
| > | > I'm not a .Net developer but I'd guess your code creates a text
file.
| > Excel
| > | > 2007 is equally capable of opening a text file as Excel 2003 so that
| > | > shouldn't be a problem. Even if your code creates an Excel 2003
files
| > | > (.XLS) Excel 2007 can open that too.
| > | >
| > | > So I don't know what the problem is, but a clue would probably be
found
| > in
| > | > the exact text of the error message which you should have included
in
| > your
| > | > message.
| > | >
| > | > --
| > | > Jim
| > | > | > | > | Hi All,
| > | > | I have an web application where user can export the results of
search
| > | > action
| > | > | to an excel file so he can locally store it.. I have done this
with
| > very
| > | > | simple code which is
| > | > | Response.ContentType = "application/vnd.ms-excel";
| > | > | Response.AppendHeader("content-disposition",
"attachment;
| > | > | filename=StackRanking.xls");
| > | > | Response.Charset = "";
| > | > | System.IO.StringWriter sw = new
System.IO.StringWriter();
| > | > | System.Web.UI.HtmlTextWriter hw = new
| > | > | System.Web.UI.HtmlTextWriter(sw);
| > | > | (........fils dataset..... hw.RenderBeginTag)
| > | > | (System.Web.UI.HtmlTextWriterTag.Html);
| > | > | dg.RenderControl(hw);
| > | > | hw.RenderEndTag();
| > | > | Response.Write(sw);
| > | > | Response.End();
| > | > |
| > | > | All work fine when end user has Excel 2003 but when he has Excel
2007
| > it
| > | > | gives a warning err message when he tries to open the rendered
| > | > (downloaded)
| > | > | Excel File,
| > | > | I guess i need framework 3.0 to Support the file format of Excel
2007.
| > | > What
| > | > | in the code needs to be changed to have compatibility with Excel
2007
| > | > | File.....
| > | > |
| > | > | Thanks for reading my query...
| > | > | --
| > | > | Software Engineer
| > | > |
| > | >
| > | >
| > | >
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top