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<tdProposalId</td</tr
<tr<td11070</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
"Amitabh" wrote in message
...
| 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
|