Export to Excel

07-24-2008

Hi

I am trying to export a GridView to Excel.
It exports the data but transforms it in the process.
for instance, this RBHK-17+RCHJ-24A2 becomes RBHK-17ä¡24A2
so basically anywhere i have a '+' sign the rest of the data chnages
to special characters ...like FC/MC62Dã…ç˜î“—

i have tried setting various Response.Charset and encoding but to no
avail...

Please help!

TIA

07-25-2008

Did you try enclosing the field in double quotes?

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

<> wrote in message
news:e2929a41-a883-496d-8144-...
Hi

I am trying to export a GridView to Excel.
It exports the data but transforms it in the process.
for instance, this RBHK-17+RCHJ-24A2 becomes RBHK-17ä¡24A2
so basically anywhere i have a '+' sign the rest of the data chnages
to special characters ...like FC/MC62Dã…ç˜î“—

i have tried setting various Response.Charset and encoding but to no
avail...

Please help!

TIA

07-25-2008

On Jul 24, 8:34Â*pm, "Jonathan Wood" <jw...@softcircuits.com> wrote:
> Did you try enclosing the field in double quotes?
>
> --
> Jonathan Wood
> SoftCircuits Programminghttp://www.softcircuits.com
>
> <harshdeeps...@gmail.com> wrote in message
>
> news:e2929a41-a883-496d-8144-...
> Hi
>
> I am trying to export a GridView to Excel.
> It exports the data but transforms it in the process.
> for instance, this RBHK-17+RCHJ-24A2 becomes RBHK-17ä¡24A2
> so basically anywhere i have a '+' sign the rest of the data chnages
> to special characters ...like FC/MC62Dã…ç˜î“—
>
> i have tried setting various Response.Charset and encoding but to no
> avail...
>
> Please help!
>
> TIA

Nope....but i should have...
It works!

Thnx

07-25-2008

Spoke too soon...it works for a csv but adds double quotes to the
extract for xls.

On Jul 24, 8:34Â*pm, "Jonathan Wood" <jw...@softcircuits.com> wrote:
> Did you try enclosing the field in double quotes?
>
> --
> Jonathan Wood
> SoftCircuits Programminghttp://www.softcircuits.com
>
> <harshdeeps...@gmail.com> wrote in message
>
> news:e2929a41-a883-496d-8144-...
> Hi
>
> I am trying to export a GridView to Excel.
> It exports the data but transforms it in the process.
> for instance, this RBHK-17+RCHJ-24A2 becomes RBHK-17ä¡24A2
> so basically anywhere i have a '+' sign the rest of the data chnages
> to special characters ...like FC/MC62Dã…ç˜î“—
>
> i have tried setting various Response.Charset and encoding but to no
> avail...
>
> Please help!
>
> TIA

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Export to Excel (Default File Type - Excel)	=?Utf-8?B?SGVtYW50IFNpcGFoaW1hbGFuaQ==?=	ASP .Net	15	05-21-2009 12:01 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007	=?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=	ASP .Net	15	10-24-2007 01:34 PM
Export to excel in asp.net using excel template	Grey	ASP .Net	4	10-17-2007 08:08 AM
using Microsoft Excel image for Export to Excel button	=?Utf-8?B?U3JpZGhhcg==?=	ASP .Net	0	12-09-2005 08:58 PM
Invalid export DLL or export format	=?Utf-8?B?RGF2aWQgVmFsbGU=?=	ASP .Net	0	10-29-2003 11:46 AM