Export datagrid to excel file

[Amirallia]

Hello

Here is my code to export a datagrid to Excel, it's work but the no
ASCII caracter are not correctly exported (for example : caracter "é"
)

Response.Clear()
Response.Buffer = True

Response.AddHeader("content-disposition",
"attachment;filename=Final.xls")
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = "UTF-8"

Dim monStringWriter As System.IO.StringWriter = New
System.IO.StringWriter
Dim monHtmlTextWriter As HtmlTextWriter = New
HtmlTextWriter(monStringWriter)
Me.dg1.RenderControl(monHtmlTextWriter)
Response.Write(monStringWriter.ToString())
Response.End()

Any idea to export correctly ?

[John Timney \(MVP\)]

I believe you need to set your charcater encoding type along with yuor
application. Its something like this but you'll need to dig about to get it
right.

Response.ContentType = "application/vnd.ms-excel;charset=windows-1251"

Regards

John Timney (MVP)
"Amirallia" <bn**@bluewin.chwrote in message
news:mn***********************@bluewin.ch...

Hello

Here is my code to export a datagrid to Excel, it's work but the no ASCII
caracter are not correctly exported (for example : caracter "é" )

Response.Clear()
Response.Buffer = True

Response.AddHeader("content-disposition", "attachment;filename=Final.xls")
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = "UTF-8"

Dim monStringWriter As System.IO.StringWriter = New System.IO.StringWriter
Dim monHtmlTextWriter As HtmlTextWriter = New
HtmlTextWriter(monStringWriter)
Me.dg1.RenderControl(monHtmlTextWriter)
Response.Write(monStringWriter.ToString())
Response.End()

Any idea to export correctly ?

[Amirallia]

John Timney (MVP) avait prétendu :

I believe you need to set your charcater encoding type along with yuor
application. Its something like this but you'll need to dig about to get it
right.

Response.ContentType = "application/vnd.ms-excel;charset=windows-1251"

Regards

John Timney (MVP)
"Amirallia" <bn**@bluewin.chwrote in message
news:mn***********************@bluewin.ch...

>Hello

Here is my code to export a datagrid to Excel, it's work but the no ASCII
caracter are not correctly exported (for example : caracter "é" )

Response.Clear()
Response.Buffer = True

Response.AddHeader("content-disposition", "attachment;filename=Final.xls")
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = "UTF-8"

Dim monStringWriter As System.IO.StringWriter = New System.IO.StringWriter
Dim monHtmlTextWriter As HtmlTextWriter = New
HtmlTextWriter(monStringWriter)
Me.dg1.RenderControl(monHtmlTextWriter)
Response.Write(monStringWriter.ToString())
Response.End()

Any idea to export correctly ?

Thanks, but it doesn't work !

But what do you mean when you write: charcater encoding type along with
your application

[clickon]

charset=windows-1251 is character charcater encoding type

application/vnd.ms-excel;charset=windows-1251 is charcater encoding type
along with your application

"Amirallia" wrote:

John Timney (MVP) avait prétendu :

I believe you need to set your charcater encoding type along with yuor
application. Its something like this but you'll need to dig about to get it
right.

Response.ContentType = "application/vnd.ms-excel;charset=windows-1251"

Regards

John Timney (MVP)
"Amirallia" <bn**@bluewin.chwrote in message
news:mn***********************@bluewin.ch...

Hello

Here is my code to export a datagrid to Excel, it's work but the no ASCII
caracter are not correctly exported (for example : caracter "é" )

Response.Clear()
Response.Buffer = True

Response.AddHeader("content-disposition", "attachment;filename=Final.xls")
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = "UTF-8"

Dim monStringWriter As System.IO.StringWriter = New System.IO.StringWriter
Dim monHtmlTextWriter As HtmlTextWriter = New
HtmlTextWriter(monStringWriter)
Me.dg1.RenderControl(monHtmlTextWriter)
Response.Write(monStringWriter.ToString())
Response.End()

Any idea to export correctly ?

Thanks, but it doesn't work !

But what do you mean when you write: charcater encoding type along with
your application