Fails to open Excel

[ZW]

Hi there,

I use following code to convert a datagrid data to Excel.
However, if I use IE to access the page, it opens an empty
excel page. If I access it by Netscape, it can open it
with excel (or save it). Does any one have experience to
fix the problem?

//
Response.ClearC ontent();
Response.ClearH eaders();
Response.Conten tType = "applicatio n/vnd.ms-excel";
//Response.Conten tType = "applicatio n/x-msexcel"; // Same
result
Response.Charse t = string.Empty ;
this.EnableView State = false;
object content = Session["datagrid"];
if (content != null)
{
Response.Write( content.ToStrin g());
Response.End();
}
TIA

ZW

[Dan Bass]

remove the line ClearControls from my method.

"ZW" <an*******@disc ussions.microso ft.com> wrote in message
news:04******** *************** *****@phx.gbl.. .

Hi there,

I use following code to convert a datagrid data to Excel.
However, if I use IE to access the page, it opens an empty
excel page. If I access it by Netscape, it can open it
with excel (or save it). Does any one have experience to
fix the problem?

//
Response.ClearC ontent();
Response.ClearH eaders();
Response.Conten tType = "applicatio n/vnd.ms-excel";
//Response.Conten tType = "applicatio n/x-msexcel"; // Same
result
Response.Charse t = string.Empty ;
this.EnableView State = false;
object content = Session["datagrid"];
if (content != null)
{
Response.Write( content.ToStrin g());
Response.End();
}
TIA

ZW

[Dan Bass]

This method works if there are no controls (buttons, dropdowns etc) in the
data grid:

public static void ExportToXls(Dat aGrid dgExport, HttpResponse
response)
{

response.Clear( );
response.Buffer = true;
response.Charse t = "";
response.Conten tType = "applicatio n/vnd.ms-excel";

System.IO.Strin gWriter stringWrite = new
System.IO.Strin gWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter( stringWrite);

ClearControls(d gExport);
dgExport.GridLi nes = GridLines.None;
dgExport.Header Style.Font.Bold = true;
dgExport.Altern atingItemStyle. BackColor =
System.Drawing. Color.WhiteSmok e;
dgExport.Header Style.ForeColor =
System.Drawing. Color.DarkBlue;
dgExport.Header Style.BackColor =
System.Drawing. Color.LightGray ;
dgExport.Render Control(htmlWri te);

response.Write( stringWrite.ToS tring());
response.End();

}

"ZW" <an*******@disc ussions.microso ft.com> wrote in message
news:04******** *************** *****@phx.gbl.. .

Hi there,

I use following code to convert a datagrid data to Excel.
However, if I use IE to access the page, it opens an empty
excel page. If I access it by Netscape, it can open it
with excel (or save it). Does any one have experience to
fix the problem?

//
Response.ClearC ontent();
Response.ClearH eaders();
Response.Conten tType = "applicatio n/vnd.ms-excel";
//Response.Conten tType = "applicatio n/x-msexcel"; // Same
result
Response.Charse t = string.Empty ;
this.EnableView State = false;
object content = Session["datagrid"];
if (content != null)
{
Response.Write( content.ToStrin g());
Response.End();
}
TIA

ZW

[ZW]

Hi Don,

Thanks for the reply.

However, it doesn't work.

Although I didn't mention, I already use
datagrid.Render Control(HtmlTex tWriter) put data to
StringWriter in DataGrid page and save the data in
Session, then in the excel report page retrieve the data
and write to Response. As I mentioned, the weird thing is
it works fine in Netscape, but not work for IE.

ZW

-----Original Message-----
remove the line ClearControls from my method.

"ZW" <an*******@disc ussions.microso ft.com> wrote in messagenews:04******* *************** ******@phx.gbl. ..

Hi there,

I use following code to convert a datagrid data to Excel. However, if I use IE to access the page, it opens an empty excel page. If I access it by Netscape, it can open it
with excel (or save it). Does any one have experience to
fix the problem?

//
Response.ClearC ontent();
Response.ClearH eaders();
Response.Conten tType = "applicatio n/vnd.ms-excel";
//Response.Conten tType = "applicatio n/x-msexcel"; // Same result
Response.Charse t = string.Empty ;
this.EnableView State = false;
object content = Session["datagrid"];
if (content != null)
{
Response.Write( content.ToStrin g());
Response.End();
}
TIA

ZW

.

[Dan Bass]

What version of IE, and what version of Office do you have installed?

"ZW" <an*******@disc ussions.microso ft.com> wrote in message
news:13******** *************** *****@phx.gbl.. .

Hi Don,

Thanks for the reply.

However, it doesn't work.

Although I didn't mention, I already use
datagrid.Render Control(HtmlTex tWriter) put data to
StringWriter in DataGrid page and save the data in
Session, then in the excel report page retrieve the data
and write to Response. As I mentioned, the weird thing is
it works fine in Netscape, but not work for IE.

ZW

-----Original Message-----
remove the line ClearControls from my method.

"ZW" <an*******@disc ussions.microso ft.com> wrote in

message

news:04****** *************** *******@phx.gbl ...

Hi there,

I use following code to convert a datagrid data to Excel. However, if I use IE to access the page, it opens an empty excel page. If I access it by Netscape, it can open it
with excel (or save it). Does any one have experience to
fix the problem?

//
Response.ClearC ontent();
Response.ClearH eaders();
Response.Conten tType = "applicatio n/vnd.ms-excel";
//Response.Conten tType = "applicatio n/x-msexcel"; // Same result
Response.Charse t = string.Empty ;
this.EnableView State = false;
object content = Session["datagrid"];
if (content != null)
{
Response.Write( content.ToStrin g());
Response.End();
}
TIA

ZW

.

[ZW]

IE 6 (sp1) and Office 2000.

BTW I tried IE in one computer with Office 97, it seems OK.

-----Original Message-----
What version of IE, and what version of Office do you have installed?
"ZW" <an*******@disc ussions.microso ft.com> wrote in messagenews:13******* *************** ******@phx.gbl. ..

Hi Don,

Thanks for the reply.

However, it doesn't work.

Although I didn't mention, I already use
datagrid.Render Control(HtmlTex tWriter) put data to
StringWriter in DataGrid page and save the data in
Session, then in the excel report page retrieve the data
and write to Response. As I mentioned, the weird thing is it works fine in Netscape, but not work for IE.

ZW

-----Original Message-----
remove the line ClearControls from my method.

"ZW" <an*******@disc ussions.microso ft.com> wrote in

message

news:04***** *************** ********@phx.gb l...
Hi there,

I use following code to convert a datagrid data to

Excel.

However, if I use IE to access the page, it opens an

empty

excel page. If I access it by Netscape, it can open it
with excel (or save it). Does any one have experience to fix the problem?

//
Response.ClearC ontent();
Response.ClearH eaders();
Response.Conten tType = "applicatio n/vnd.ms-excel";
//Response.Conten tType = "applicatio n/x-msexcel"; //

Same

result
Response.Charse t = string.Empty ;
this.EnableView State = false;
object content = Session["datagrid"];
if (content != null)
{
Response.Write( content.ToStrin g());
Response.End();
}
TIA

ZW
.

.

[Dan Bass]

and I know it works with IE 5.01 + with Office 97, and also with IE 6.0+
with Office 2003...

Hmm. Do you have any controls in your grid? (buttons, drop downs etc?)

Have you seen this?

http://www.c-sharpcorner.com/Code/20...ridToExcel.asp
"ZW" <an*******@disc ussions.microso ft.com> wrote in message
news:16******** *************** *****@phx.gbl.. .

IE 6 (sp1) and Office 2000.

BTW I tried IE in one computer with Office 97, it seems OK.

-----Original Message-----
What version of IE, and what version of Office do you

have installed?

"ZW" <an*******@disc ussions.microso ft.com> wrote in

message

news:13****** *************** *******@phx.gbl ...

Hi Don,

Thanks for the reply.

However, it doesn't work.

Although I didn't mention, I already use
datagrid.Render Control(HtmlTex tWriter) put data to
StringWriter in DataGrid page and save the data in
Session, then in the excel report page retrieve the data
and write to Response. As I mentioned, the weird thing is it works fine in Netscape, but not work for IE.

ZW
-----Original Message-----
remove the line ClearControls from my method.

"ZW" <an*******@disc ussions.microso ft.com> wrote in
message
news:04**** *************** *********@phx.g bl...
> Hi there,
>
> I use following code to convert a datagrid data to
Excel.
> However, if I use IE to access the page, it opens an
empty
> excel page. If I access it by Netscape, it can open it
> with excel (or save it). Does any one have experience to> fix the problem?
>
> //
> Response.ClearC ontent();
> Response.ClearH eaders();
> Response.Conten tType = "applicatio n/vnd.ms-excel";
> //Response.Conten tType = "applicatio n/x-msexcel"; //
Same
> result
> Response.Charse t = string.Empty ;
> this.EnableView State = false;
> object content = Session["datagrid"];
> if (content != null)
> {
> Response.Write( content.ToStrin g());
> Response.End();
> }
>
>
> TIA
>
> ZW
.

.

[Dan Bass]

I think it's a bug in Office 2000 (pre SR-1)

creating excel from datagrif ->
http://support.microsoft.com/default...b;en-us;317719
bug affecting you -> http://support.microsoft.com/kb/264143/EN-US/

why it works with netscape though i don't know.

"ZW" <an*******@disc ussions.microso ft.com> wrote in message
news:16******** *************** *****@phx.gbl.. .

IE 6 (sp1) and Office 2000.

BTW I tried IE in one computer with Office 97, it seems OK.

-----Original Message-----
What version of IE, and what version of Office do you

have installed?

"ZW" <an*******@disc ussions.microso ft.com> wrote in

message

news:13****** *************** *******@phx.gbl ...

Hi Don,

Thanks for the reply.

However, it doesn't work.

Although I didn't mention, I already use
datagrid.Render Control(HtmlTex tWriter) put data to
StringWriter in DataGrid page and save the data in
Session, then in the excel report page retrieve the data
and write to Response. As I mentioned, the weird thing is it works fine in Netscape, but not work for IE.

ZW
-----Original Message-----
remove the line ClearControls from my method.

"ZW" <an*******@disc ussions.microso ft.com> wrote in
message
news:04**** *************** *********@phx.g bl...
> Hi there,
>
> I use following code to convert a datagrid data to
Excel.
> However, if I use IE to access the page, it opens an
empty
> excel page. If I access it by Netscape, it can open it
> with excel (or save it). Does any one have experience to> fix the problem?
>
> //
> Response.ClearC ontent();
> Response.ClearH eaders();
> Response.Conten tType = "applicatio n/vnd.ms-excel";
> //Response.Conten tType = "applicatio n/x-msexcel"; //
Same
> result
> Response.Charse t = string.Empty ;
> this.EnableView State = false;
> object content = Session["datagrid"];
> if (content != null)
> {
> Response.Write( content.ToStrin g());
> Response.End();
> }
>
>
> TIA
>
> ZW
.

.

[ZW]

I think it might be problem of Office 2000. I also tried
to load Word file to web page, I got the same problem with
IE 6 + Office 2000.

Thanks,

ZW

-----Original Message-----
and I know it works with IE 5.01 + with Office 97, and also with IE 6.0+with Office 2003...

Hmm. Do you have any controls in your grid? (buttons, drop downs etc?)
Have you seen this?

http://www.c- sharpcorner.com/Code/2003/Sept/ExportASPNetDat aGridToExcel.
asp

"ZW" <an*******@disc ussions.microso ft.com> wrote in messagenews:16******* *************** ******@phx.gbl. ..

IE 6 (sp1) and Office 2000.

BTW I tried IE in one computer with Office 97, it seems OK.

-----Original Message-----
What version of IE, and what version of Office do you

have installed?

"ZW" <an*******@disc ussions.microso ft.com> wrote in

message

news:13***** *************** ********@phx.gb l...
Hi Don,

Thanks for the reply.

However, it doesn't work.

Although I didn't mention, I already use
datagrid.Render Control(HtmlTex tWriter) put data to
StringWriter in DataGrid page and save the data in
Session, then in the excel report page retrieve the data and write to Response. As I mentioned, the weird thing

is

it works fine in Netscape, but not work for IE.

ZW
>-----Original Message-----
>remove the line ClearControls from my method.
>
>"ZW" <an*******@disc ussions.microso ft.com> wrote in
message
>news:04*** *************** **********@phx. gbl...
>> Hi there,
>>
>> I use following code to convert a datagrid data to
Excel.
>> However, if I use IE to access the page, it opens an
empty
>> excel page. If I access it by Netscape, it can open it>> with excel (or save it). Does any one have experience

to

>> fix the problem?
>>
>> //
>> Response.ClearC ontent();
>> Response.ClearH eaders();
>> Response.Conten tType = "applicatio n/vnd.ms-excel";
>> //Response.Conten tType = "applicatio n/x-

msexcel"; // Same
>> result
>> Response.Charse t = string.Empty ;
>> this.EnableView State = false;
>> object content = Session["datagrid"];
>> if (content != null)
>> {
>> Response.Write( content.ToStrin g());
>> Response.End();
>> }
>>
>>
>> TIA
>>
>> ZW
>
>
>.
>
.

.