Rendering a GridView

20 Nov 2007 1:03 AM

Gerhard

I have a GridView that I want to return as an Excel spreadsheet. I am using
vb.net in a web application.

The following code works, with the exception of special characters.

            dt = MyDataSet.Tables(0)

            GridView1.DataSource = dt
            GridView1.DataBind()

            'Response.ContentType = "application/ms-excel"
            'Response.ContentEncoding = Encoding.ASCII
            'Response.Charset = "ISO-LATIN-1"
            Response.ContentType = "application/vnd.xls"

            Response.AddHeader("Content-Disposition", _
              "inline;filename=" & strReportName)

If I look in the data in the GridView I see:
Associates, LLC, CPA's
Wilson - CPA

What shows up in the spreadsheet returned is:
Associates, LLC, CPAÃ¢â‚¬â„¢s
Wilson Ã¢â‚¬â€œ CPA

If I uncomment out the setting of the ContentEndoding and Charset, I get:
Associates, LLC, CPA?s
Wilson ? CPA

How do I get it to render the ' and - properly?

Thanks.

20 Nov 2007 9:39 AM

Jialiang Ge [MSFT]

Hello Gerhard,

From your post, my understanding on this issue is: you wonder how to render
the character' when you output the data table to a excel worksheet. If I'm
off base, please feel free to let me know.

Based on my test, I think the character ' that you referred to might be '.
The default charset that Excel build for ' is "windows-1252", so in my
side, the issue is resolved when I change your code to

Response.ContentType = "application/ms-excel";
Response.ContentEncoding = Encoding.GetEncoding("windows-1252");
Response.Charset = "windows-1252";
Response.AddHeader("Content-Disposition", "inline;filename=test.xls");

Please have a try and let me know if it works in your side.

Sincerely,
Jialiang Ge (jia***@online.microsoft.com, remove 'online.')
Microsoft Online Community Support

==================================================
For MSDN subscribers whose posts are left unanswered, please check this
document: http://blogs.msdn.com/msdnts/pages/postingAlias.aspx

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications. If you are using Outlook Express/Windows Mail, please make sure
you clear the check box "Tools/Options/Read: Get 300 headers at a time" to
see your reply promptly.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

20 Nov 2007 4:24 PM

Gerhard

Awesome! Worked perfectly. Thanks.

Show quoteHide quote

"Jialiang Ge [MSFT]" wrote:

> Hello Gerhard,
>
> From your post, my understanding on this issue is: you wonder how to render
> the character' when you output the data table to a excel worksheet. If I'm
> off base, please feel free to let me know.
>
> Based on my test, I think the character ' that you referred to might be '.
> The default charset that Excel build for ' is "windows-1252", so in my
> side, the issue is resolved when I change your code to
>
> Response.ContentType = "application/ms-excel";
> Response.ContentEncoding = Encoding.GetEncoding("windows-1252");
> Response.Charset = "windows-1252";
> Response.AddHeader("Content-Disposition", "inline;filename=test.xls");
>
> Please have a try and let me know if it works in your side.
>
> Sincerely,
> Jialiang Ge (jia***@online.microsoft.com, remove 'online.')
> Microsoft Online Community Support
>
> ==================================================
> For MSDN subscribers whose posts are left unanswered, please check this
> document: http://blogs.msdn.com/msdnts/pages/postingAlias.aspx
>
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications. If you are using Outlook Express/Windows Mail, please make sure
> you clear the check box "Tools/Options/Read: Get 300 headers at a time" to
> see your reply promptly.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>