«

The following piece of code is being used to export HTML to excel.

HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
HttpContext.Current.Response.AddHeader("content-disposition",
"attachment;filename=ABC.xls")
HttpContext.Current.Response.Write(strHTML)
HttpContext.Current.Response.End()

However when the user tries to save it the Default File Type is Web
Page(*.htm; *.html)
How do we change the Default File Type to Excel

Try putting a Response.Clear() line at the beggining of your code block.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net


"Hemant Sipahimalani" <Hemant > wrote
in message news:C0FC2030-600D-4D1D-88FB-...
> The following piece of code is being used to export HTML to excel.
>
> HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
> HttpContext.Current.Response.AddHeader("content-disposition",
> "attachment;filename=ABC.xls")
> HttpContext.Current.Response.Write(strHTML)
> HttpContext.Current.Response.End()
>
> However when the user tries to save it the Default File Type is Web
> Page(*.htm; *.html)
> How do we change the Default File Type to Excel

Steve,
Thank you for the prompt reply. Response.Clear does not help though.
Listing out the full piece of code for better clarity.

Dim strFileName As String
Dim strHTML As String
Dim strAddInfo As String

HttpContext.Current.Response.Clear()
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
strReportName = "EXPORT REPORT"
strFileName = "ABC.xls"
strAddInfo = "Additional Info"
strHTML = GetGHTML() 'This is responsible for getting report in HTML format
HttpContext.Current.Response.AddHeader("content-disposition",
"attachment;filename=" & strFileName)
HttpContext.Current.Response.Charset = ""
HttpContext.Current.Response.Write("<h4>" & strReportName & "</h4>")
HttpContext.Current.Response.Write(strAddInfo)
HttpContext.Current.Response.Write("<br><br>")
HttpContext.Current.Response.Write(strHTML)
HttpContext.Current.Response.End()
Hemant
"Steve C. Orr [MVP, MCSD]" wrote:

> Try putting a Response.Clear() line at the beggining of your code block.
>
> --
> I hope this helps,
> Steve C. Orr, MCSD, MVP
> http://SteveOrr.net
>
>
> "Hemant Sipahimalani" <Hemant > wrote
> in message news:C0FC2030-600D-4D1D-88FB-...
> > The following piece of code is being used to export HTML to excel.
> >
> > HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
> > HttpContext.Current.Response.AddHeader("content-disposition",
> > "attachment;filename=ABC.xls")
> > HttpContext.Current.Response.Write(strHTML)
> > HttpContext.Current.Response.End()
> >
> > However when the user tries to save it the Default File Type is Web
> > Page(*.htm; *.html)
> > How do we change the Default File Type to Excel
>
>
>

We have used this code:

objHttpContext.Response.Clear()
objHttpContext.Response.Buffer = True
objHttpContext.Response.ContentEncoding = System.Text.Encoding.UTF8
objHttpContext.Response.ContentType = "application/vnd.ms-excel"
objHttpContext.Response.AddHeader("Content-disposition",
"attachment;filename=export.xls")
objHttpContext.Response.Charset = ""

"Hemant Sipahimalani" <Hemant > wrote
in message news:C0FC2030-600D-4D1D-88FB-...
> The following piece of code is being used to export HTML to excel.
>
> HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
> HttpContext.Current.Response.AddHeader("content-disposition",
> "attachment;filename=ABC.xls")
> HttpContext.Current.Response.Write(strHTML)
> HttpContext.Current.Response.End()
>
> However when the user tries to save it the Default File Type is Web
> Page(*.htm; *.html)
> How do we change the Default File Type to Excel

Thanks Jeff ,
but this still does not show the default File Type as xls when the user
tries to save the file.
Hemant
"Jeff Dillon" wrote:

> We have used this code:
>
> objHttpContext.Response.Clear()
> objHttpContext.Response.Buffer = True
> objHttpContext.Response.ContentEncoding = System.Text.Encoding.UTF8
> objHttpContext.Response.ContentType = "application/vnd.ms-excel"
> objHttpContext.Response.AddHeader("Content-disposition",
> "attachment;filename=export.xls")
> objHttpContext.Response.Charset = ""
>
> "Hemant Sipahimalani" <Hemant > wrote
> in message news:C0FC2030-600D-4D1D-88FB-...
> > The following piece of code is being used to export HTML to excel.
> >
> > HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
> > HttpContext.Current.Response.AddHeader("content-disposition",
> > "attachment;filename=ABC.xls")
> > HttpContext.Current.Response.Write(strHTML)
> > HttpContext.Current.Response.End()
> >
> > However when the user tries to save it the Default File Type is Web
> > Page(*.htm; *.html)
> > How do we change the Default File Type to Excel
>
>
>

Well, it does for us, for every browser in the company

Jeff
"Hemant Sipahimalani" <> wrote
in message news:8B0AFB73-21B3-42E6-B9A7-...
> Thanks Jeff ,
> but this still does not show the default File Type as xls when the user
> tries to save the file.
> Hemant
> "Jeff Dillon" wrote:
>
>> We have used this code:
>>
>> objHttpContext.Response.Clear()
>> objHttpContext.Response.Buffer = True
>> objHttpContext.Response.ContentEncoding = System.Text.Encoding.UTF8
>> objHttpContext.Response.ContentType = "application/vnd.ms-excel"
>> objHttpContext.Response.AddHeader("Content-disposition",
>> "attachment;filename=export.xls")
>> objHttpContext.Response.Charset = ""
>>
>> "Hemant Sipahimalani" <Hemant >
>> wrote
>> in message news:C0FC2030-600D-4D1D-88FB-...
>> > The following piece of code is being used to export HTML to excel.
>> >
>> > HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
>> > HttpContext.Current.Response.AddHeader("content-disposition",
>> > "attachment;filename=ABC.xls")
>> > HttpContext.Current.Response.Write(strHTML)
>> > HttpContext.Current.Response.End()
>> >
>> > However when the user tries to save it the Default File Type is Web
>> > Page(*.htm; *.html)
>> > How do we change the Default File Type to Excel
>>
>>
>>

Put this all by itself in test.aspx:

<%

Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-disposition", "attachment;filename=export.xls")
Response.Charset = ""
Response.Write("Hello world")
Response.End()

%>

"Hemant Sipahimalani" <> wrote
in message news:8B0AFB73-21B3-42E6-B9A7-...
> Thanks Jeff ,
> but this still does not show the default File Type as xls when the user
> tries to save the file.
> Hemant
> "Jeff Dillon" wrote:
>
>> We have used this code:
>>
>> objHttpContext.Response.Clear()
>> objHttpContext.Response.Buffer = True
>> objHttpContext.Response.ContentEncoding = System.Text.Encoding.UTF8
>> objHttpContext.Response.ContentType = "application/vnd.ms-excel"
>> objHttpContext.Response.AddHeader("Content-disposition",
>> "attachment;filename=export.xls")
>> objHttpContext.Response.Charset = ""
>>
>> "Hemant Sipahimalani" <Hemant >
>> wrote
>> in message news:C0FC2030-600D-4D1D-88FB-...
>> > The following piece of code is being used to export HTML to excel.
>> >
>> > HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
>> > HttpContext.Current.Response.AddHeader("content-disposition",
>> > "attachment;filename=ABC.xls")
>> > HttpContext.Current.Response.Write(strHTML)
>> > HttpContext.Current.Response.End()
>> >
>> > However when the user tries to save it the Default File Type is Web
>> > Page(*.htm; *.html)
>> > How do we change the Default File Type to Excel
>>
>>
>>

Jeff,
You are correct. The piece of code that you have written does show the
Exported file as "Text (tab delimited) (*.txt) " in the "Save as type"
dropdown when the user tries to save the excel file.
However in my case the data is in tabular format as opposed to "Hello
World".
The data that I am trying to export is similar to

strHTML = "<table><tr><td>1</td><td>2</td><td>3</td></tr></table>"

HttpContext.Current.Response.Clear()
HttpContext.Current.Response.Buffer = True
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
HttpContext.Current.Response.AddHeader("Content-disposition",
"attachment;filename=export.xls")
HttpContext.Current.Response.Charset = ""
HttpContext.Current.Response.Write(strHTML)
HttpContext.Current.Response.End()

In this case when the user tries to save the exported excel the "Save as
Type" drop down shows the type as a "Web Page". This is something that I am
trying to avoid.

Thanks,
Hemant


"Jeff Dillon" wrote:

> Put this all by itself in test.aspx:
>
> <%
>
> Response.Clear()
> Response.Buffer = True
> Response.ContentType = "application/vnd.ms-excel"
> Response.AddHeader("Content-disposition", "attachment;filename=export.xls")
> Response.Charset = ""
> Response.Write("Hello world")
> Response.End()
>
> %>
>
> "Hemant Sipahimalani" <> wrote
> in message news:8B0AFB73-21B3-42E6-B9A7-...
> > Thanks Jeff ,
> > but this still does not show the default File Type as xls when the user
> > tries to save the file.
> > Hemant
> > "Jeff Dillon" wrote:
> >
> >> We have used this code:
> >>
> >> objHttpContext.Response.Clear()
> >> objHttpContext.Response.Buffer = True
> >> objHttpContext.Response.ContentEncoding = System.Text.Encoding.UTF8
> >> objHttpContext.Response.ContentType = "application/vnd.ms-excel"
> >> objHttpContext.Response.AddHeader("Content-disposition",
> >> "attachment;filename=export.xls")
> >> objHttpContext.Response.Charset = ""
> >>
> >> "Hemant Sipahimalani" <Hemant >
> >> wrote
> >> in message news:C0FC2030-600D-4D1D-88FB-...
> >> > The following piece of code is being used to export HTML to excel.
> >> >
> >> > HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
> >> > HttpContext.Current.Response.AddHeader("content-disposition",
> >> > "attachment;filename=ABC.xls")
> >> > HttpContext.Current.Response.Write(strHTML)
> >> > HttpContext.Current.Response.End()
> >> >
> >> > However when the user tries to save it the Default File Type is Web
> >> > Page(*.htm; *.html)
> >> > How do we change the Default File Type to Excel
> >>
> >>
> >>
>
>
>

On ALL our machines, my code shows Save As Excel Sheet in the Save As dialog
popup.

Do you have Excel installed on your client machines?? Which is a requirement
of course, to save in that format.

Jeff

"Hemant Sipahimalani" <> wrote
in message news:E926C9C0-B95A-4D9D-9070-...
> Jeff,
> You are correct. The piece of code that you have written does show the
> Exported file as "Text (tab delimited) (*.txt) " in the "Save as type"
> dropdown when the user tries to save the excel file.
> However in my case the data is in tabular format as opposed to "Hello
> World".
> The data that I am trying to export is similar to
>
> strHTML = "<table><tr><td>1</td><td>2</td><td>3</td></tr></table>"
>
> HttpContext.Current.Response.Clear()
> HttpContext.Current.Response.Buffer = True
> HttpContext.Current.Response.ContentType =
> "application/vnd.ms-excel"
> HttpContext.Current.Response.AddHeader("Content-disposition",
> "attachment;filename=export.xls")
> HttpContext.Current.Response.Charset = ""
> HttpContext.Current.Response.Write(strHTML)
> HttpContext.Current.Response.End()
>
> In this case when the user tries to save the exported excel the "Save as
> Type" drop down shows the type as a "Web Page". This is something that I
> am
> trying to avoid.
>
> Thanks,
> Hemant
>
>
> "Jeff Dillon" wrote:
>
>> Put this all by itself in test.aspx:
>>
>> <%
>>
>> Response.Clear()
>> Response.Buffer = True
>> Response.ContentType = "application/vnd.ms-excel"
>> Response.AddHeader("Content-disposition",
>> "attachment;filename=export.xls")
>> Response.Charset = ""
>> Response.Write("Hello world")
>> Response.End()
>>
>> %>
>>
>> "Hemant Sipahimalani" <>
>> wrote
>> in message news:8B0AFB73-21B3-42E6-B9A7-...
>> > Thanks Jeff ,
>> > but this still does not show the default File Type as xls when the
>> > user
>> > tries to save the file.
>> > Hemant
>> > "Jeff Dillon" wrote:
>> >
>> >> We have used this code:
>> >>
>> >> objHttpContext.Response.Clear()
>> >> objHttpContext.Response.Buffer = True
>> >> objHttpContext.Response.ContentEncoding = System.Text.Encoding.UTF8
>> >> objHttpContext.Response.ContentType = "application/vnd.ms-excel"
>> >> objHttpContext.Response.AddHeader("Content-disposition",
>> >> "attachment;filename=export.xls")
>> >> objHttpContext.Response.Charset = ""
>> >>
>> >> "Hemant Sipahimalani" <Hemant >
>> >> wrote
>> >> in message news:C0FC2030-600D-4D1D-88FB-...
>> >> > The following piece of code is being used to export HTML to excel.
>> >> >
>> >> > HttpContext.Current.Response.ContentType =
>> >> > "application/vnd.ms-excel"
>> >> > HttpContext.Current.Response.AddHeader("content-disposition",
>> >> > "attachment;filename=ABC.xls")
>> >> > HttpContext.Current.Response.Write(strHTML)
>> >> > HttpContext.Current.Response.End()
>> >> >
>> >> > However when the user tries to save it the Default File Type is Web
>> >> > Page(*.htm; *.html)
>> >> > How do we change the Default File Type to Excel
>> >>
>> >>
>> >>
>>
>>
>>

Jeff,
I have the following versions installed on my machine.
1. Excel - Microsoft Excel 2003 (11.5612.5606)
2. IE - 6.0.2900.2180 , SP2
Thanks,
Hemant

"Jeff Dillon" wrote:

> On ALL our machines, my code shows Save As Excel Sheet in the Save As dialog
> popup.
>
> Do you have Excel installed on your client machines?? Which is a requirement
> of course, to save in that format.
>
> Jeff
>
> "Hemant Sipahimalani" <> wrote
> in message news:E926C9C0-B95A-4D9D-9070-...
> > Jeff,
> > You are correct. The piece of code that you have written does show the
> > Exported file as "Text (tab delimited) (*.txt) " in the "Save as type"
> > dropdown when the user tries to save the excel file.
> > However in my case the data is in tabular format as opposed to "Hello
> > World".
> > The data that I am trying to export is similar to
> >
> > strHTML = "<table><tr><td>1</td><td>2</td><td>3</td></tr></table>"
> >
> > HttpContext.Current.Response.Clear()
> > HttpContext.Current.Response.Buffer = True
> > HttpContext.Current.Response.ContentType =
> > "application/vnd.ms-excel"
> > HttpContext.Current.Response.AddHeader("Content-disposition",
> > "attachment;filename=export.xls")
> > HttpContext.Current.Response.Charset = ""
> > HttpContext.Current.Response.Write(strHTML)
> > HttpContext.Current.Response.End()
> >
> > In this case when the user tries to save the exported excel the "Save as
> > Type" drop down shows the type as a "Web Page". This is something that I
> > am
> > trying to avoid.
> >
> > Thanks,
> > Hemant
> >
> >
> > "Jeff Dillon" wrote:
> >
> >> Put this all by itself in test.aspx:
> >>
> >> <%
> >>
> >> Response.Clear()
> >> Response.Buffer = True
> >> Response.ContentType = "application/vnd.ms-excel"
> >> Response.AddHeader("Content-disposition",
> >> "attachment;filename=export.xls")
> >> Response.Charset = ""
> >> Response.Write("Hello world")
> >> Response.End()
> >>
> >> %>
> >>
> >> "Hemant Sipahimalani" <>
> >> wrote
> >> in message news:8B0AFB73-21B3-42E6-B9A7-...
> >> > Thanks Jeff ,
> >> > but this still does not show the default File Type as xls when the
> >> > user
> >> > tries to save the file.
> >> > Hemant
> >> > "Jeff Dillon" wrote:
> >> >
> >> >> We have used this code:
> >> >>
> >> >> objHttpContext.Response.Clear()
> >> >> objHttpContext.Response.Buffer = True
> >> >> objHttpContext.Response.ContentEncoding = System.Text.Encoding.UTF8
> >> >> objHttpContext.Response.ContentType = "application/vnd.ms-excel"
> >> >> objHttpContext.Response.AddHeader("Content-disposition",
> >> >> "attachment;filename=export.xls")
> >> >> objHttpContext.Response.Charset = ""
> >> >>
> >> >> "Hemant Sipahimalani" <Hemant >
> >> >> wrote
> >> >> in message news:C0FC2030-600D-4D1D-88FB-...
> >> >> > The following piece of code is being used to export HTML to excel.
> >> >> >
> >> >> > HttpContext.Current.Response.ContentType =
> >> >> > "application/vnd.ms-excel"
> >> >> > HttpContext.Current.Response.AddHeader("content-disposition",
> >> >> > "attachment;filename=ABC.xls")
> >> >> > HttpContext.Current.Response.Write(strHTML)
> >> >> > HttpContext.Current.Response.End()
> >> >> >
> >> >> > However when the user tries to save it the Default File Type is Web
> >> >> > Page(*.htm; *.html)
> >> >> > How do we change the Default File Type to Excel
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>