Hi there
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/1zg69sj.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i48.tinypic.com/2mx1o3n.png
How can I restrict RadGrid to export each field into a single cell?
I found this topic, describing the same problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
I'm using an old dll of Telerik but RadGrid has OnGridExporting or OnHTMLExporting events available
OnGridExporting="grdRapor_GridExporting"
This didnt help me
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/1zg69sj.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i48.tinypic.com/2mx1o3n.png
How can I restrict RadGrid to export each field into a single cell?
I found this topic, describing the same problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
I'm using an old dll of Telerik but RadGrid has OnGridExporting or OnHTMLExporting events available
OnGridExporting="grdRapor_GridExporting"
Protected
Sub
grdRapor_GridExporting(
ByVal
source
As
Object
,
ByVal
e
As
GridExportingArgs)
If
e.ExportType = ExportType.Excel
Then
Dim
css
As
String
=
"<style type='text/css'> br { mso-data-placement: same-cell; } </style>"
e.ExportOutput = e.ExportOutput.Replace(
"</head>"
, css &
"</head>"
)
End
If
End
Sub
5 Answers, 1 is accepted
0

William
Top achievements
Rank 1
answered on 28 Dec 2012, 09:32 AM
Hi there
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/35jjd37.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i50.tinypic.com/fw0xky.png
How can I restrict RadGrid to export each field into a single cell?
I'm using an old version of Telerik but these 2 Events are available in RadGrid
OnGridExporting="grdRapor_GridExporting" OnHTMLExporting="grdRapor_GridExporting"
I found this topic exactly my problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
My column value is
How should I write this method?
This didn't help me
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/35jjd37.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i50.tinypic.com/fw0xky.png
How can I restrict RadGrid to export each field into a single cell?
I'm using an old version of Telerik but these 2 Events are available in RadGrid
OnGridExporting="grdRapor_GridExporting" OnHTMLExporting="grdRapor_GridExporting"
I found this topic exactly my problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
My column value is
<
table
width
=
"600"
class
=
"MsoNormalTable"
style
=
"width: 450pt; mso-cellspacing: .7pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;"
border
=
"0"
cellspacing
=
"1"
cellpadding
=
"0"
> <
tbody
> <
tr
style
=
"mso-yfti-irow: 0; mso-yfti-firstrow: yes;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; width: 20%; padding-right: 0.75pt;
background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Ãœlke<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>CEZAYÄ°R<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 1;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
colspan
=
"2"
><
b
>Talep Sahibinin<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 2;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Adı<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>EMÄ°NE AYDIN ÃœNAL<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 3;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Firma Vergi No<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>1750352027<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 4;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Firma Unvanı<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>BÄ°NA YAPI SANAYÄ° VE TÄ°CARET LTD. ÅžTÄ°.<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 5;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>e-Posta Adresi<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
><
a
href
=
"mailto:emine@bina.com.tr"
><
span
style
=
"color: #0000ff; text-decoration: underline;"
>emine@bina.com.tr</
span
></
a
><
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 6;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
colspan
=
"2"
><
b
>Talep<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 7;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Türü<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>Sektörel İthalatçı Adresi Talep Ediyorum...<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 8; mso-yfti-lastrow: yes;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Konusu<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>Firmamız
İnşaat Sektöründe Dekoratif ve İzolasyon Malz. üretmektedir ve 25 ten
fazla ülkeye satış yapmaktadır. Ne yazık ki henüz Cezaire satış
yapamadık. Bu konuda bize destek verebilirseniz çok memnun oluruz.
Cezair de bulunan Expanded Polystyrene (EPS)üreticileri ve İnşaat veya
Yalıtım Malz. Satıcıları-İnşaat Maz. Toptancılarına ve İnşaat ve
Mütaitlik firmalarına ulaşmamızda yardımcı olursanız çok memnun oluruz.
G.T.I.P. numaralarımız: 3921110000 ve 3925908009 Saygılarımla <
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> </
tbody
> </
table
>
This didn't help me
Protected
Sub
grdRapor_GridExporting(
ByVal
source
As
Object
,
ByVal
e
As
GridExportingArgs)
If
e.ExportType = ExportType.Excel
Then
Dim
css
As
String
=
"<style type='text/css'> br { mso-data-placement: same-cell; } </style>"
e.ExportOutput = e.ExportOutput.Replace(
"</head>"
, css &
"</head>"
)
End
If
End
Sub
0

William
Top achievements
Rank 1
answered on 28 Dec 2012, 09:39 AM
Hi there
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/35jjd37.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i50.tinypic.com/fw0xky.png
How can I restrict RadGrid to export each field into a single cell?
I found this topic, describing the same problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
I'm using an old dll of Telerik but RadGrid has OnGridExporting or OnHTMLExporting events available
OnGridExporting="grdRapor_GridExporting"
This didnt help me
My column generates this
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/35jjd37.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i50.tinypic.com/fw0xky.png
How can I restrict RadGrid to export each field into a single cell?
I found this topic, describing the same problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
I'm using an old dll of Telerik but RadGrid has OnGridExporting or OnHTMLExporting events available
OnGridExporting="grdRapor_GridExporting"
Protected
Sub
grdRapor_GridExporting(
ByVal
source
As
Object
,
ByVal
e
As
GridExportingArgs)
If
e.ExportType = ExportType.Excel
Then
Dim
css
As
String
=
"<style type='text/css'> br { mso-data-placement: same-cell; } </style>"
e.ExportOutput = e.ExportOutput.Replace(
"</head>"
, css &
"</head>"
)
End
If
End
Sub
My column generates this
<
table
width
=
"600"
class
=
"MsoNormalTable"
style
=
"width: 450pt; mso-cellspacing: .7pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;"
border
=
"0"
cellspacing
=
"1"
cellpadding
=
"0"
> <
tbody
> <
tr
style
=
"mso-yfti-irow: 0; mso-yfti-firstrow: yes;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; width: 20%; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Ãœlke<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>CEZAYÄ°R<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 1;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
colspan
=
"2"
><
b
>Talep Sahibinin<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 2;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Adı<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>EMÄ°NE AYDIN ÃœNAL<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 3;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Firma Vergi No<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>1750352027<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 4;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Firma Unvanı<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>BÄ°NA YAPI SANAYÄ° VE TÄ°CARET LTD. ÅžTÄ°.<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 5;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>e-Posta Adresi<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
><
a
href
=
"mailto:emine@bina.com.tr"
><
span
style
=
"color: #0000ff; text-decoration: underline;"
>emine@bina.com.tr</
span
></
a
><
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 6;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
colspan
=
"2"
><
b
>Talep<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 7;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Türü<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>Sektörel İthalatçı Adresi Talep Ediyorum...<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 8; mso-yfti-lastrow: yes;"
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Konusu<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>Firmamız İnşaat Sektöründe Dekoratif ve İzolasyon Malz. üretmektedir ve 25 ten fazla ülkeye satış yapmaktadır. Ne yazık ki henüz Cezaire satış yapamadık. Bu konuda bize destek verebilirseniz çok memnun oluruz. Cezair de bulunan Expanded Polystyrene (EPS)üreticileri ve İnşaat veya Yalıtım Malz. Satıcıları-İnşaat Maz. Toptancılarına ve İnşaat ve Mütaitlik firmalarına ulaşmamızda yardımcı olursanız çok memnun oluruz. G.T.I.P. numaralarımız: 3921110000 ve 3925908009 Saygılarımla <
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> </
tbody
> </
table
>
0

William
Top achievements
Rank 1
answered on 28 Dec 2012, 09:41 AM
Hi there
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/35jjd37.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i50.tinypic.com/fw0xky.png
How can I restrict RadGrid to export each field into a single cell?
I found this topic, describing the same problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
I'm using an old dll of Telerik but RadGrid has OnGridExporting or OnHTMLExporting events available
OnGridExporting="grdRapor_GridExporting"
This didnt help me
My column value is like this
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/35jjd37.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i50.tinypic.com/fw0xky.png
How can I restrict RadGrid to export each field into a single cell?
I found this topic, describing the same problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
I'm using an old dll of Telerik but RadGrid has OnGridExporting or OnHTMLExporting events available
OnGridExporting="grdRapor_GridExporting"
Protected
Sub
grdRapor_GridExporting(
ByVal
source
As
Object
,
ByVal
e
As
GridExportingArgs)
If
e.ExportType = ExportType.Excel
Then
Dim
css
As
String
=
"<style type='text/css'> br { mso-data-placement: same-cell; } </style>"
e.ExportOutput = e.ExportOutput.Replace(
"</head>"
, css &
"</head>"
)
End
If
End
Sub
My column value is like this
<table width=
"600"
class
=
"MsoNormalTable"
style=
"width: 450pt; mso-cellspacing: .7pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;"
border=
"0"
cellspacing=
"1"
cellpadding=
"0"
> <tbody> <tr style=
"mso-yfti-irow: 0; mso-yfti-firstrow: yes;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; width: 20%; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><b>Ãœlke<o:p _rdEditor_exists=
"1"
></o:p></b></td> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>CEZAYÄ°R<o:p _rdEditor_exists=
"1"
></o:p></td> </tr> <tr style=
"mso-yfti-irow: 1;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
colspan=
"2"
><b>Talep Sahibinin<o:p _rdEditor_exists=
"1"
></o:p></b></td> </tr> <tr style=
"mso-yfti-irow: 2;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><b>Adı<o:p _rdEditor_exists=
"1"
></o:p></b></td> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>EMÄ°NE AYDIN ÃœNAL<o:p _rdEditor_exists=
"1"
></o:p></td> </tr> <tr style=
"mso-yfti-irow: 3;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><b>Firma Vergi No<o:p _rdEditor_exists=
"1"
></o:p></b></td> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>1750352027<o:p _rdEditor_exists=
"1"
></o:p></td> </tr> <tr style=
"mso-yfti-irow: 4;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><b>Firma Unvanı<o:p _rdEditor_exists=
"1"
></o:p></b></td> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>BÄ°NA YAPI SANAYÄ° VE TÄ°CARET LTD. ÅžTÄ°.<o:p _rdEditor_exists=
"1"
></o:p></td> </tr> <tr style=
"mso-yfti-irow: 5;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><b>e-Posta Adresi<o:p _rdEditor_exists=
"1"
></o:p></b></td> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
><a href=
"mailto:emine@bina.com.tr"
><span style=
"color: #0000ff; text-decoration: underline;"
>emine@bina.com.tr</span></a><o:p _rdEditor_exists=
"1"
></o:p></td> </tr> <tr style=
"mso-yfti-irow: 6;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
colspan=
"2"
><b>Talep<o:p _rdEditor_exists=
"1"
></o:p></b></td> </tr> <tr style=
"mso-yfti-irow: 7;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><b>Türü<o:p _rdEditor_exists=
"1"
></o:p></b></td> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>Sektörel İthalatçı Adresi Talep Ediyorum...<o:p _rdEditor_exists=
"1"
></o:p></td> </tr> <tr style=
"mso-yfti-irow: 8; mso-yfti-lastrow: yes;"
> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><b>Konusu<o:p _rdEditor_exists=
"1"
></o:p></b></td> <td style=
"padding-bottom: 0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background: aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>Firmamız İnşaat Sektöründe Dekoratif ve İzolasyon Malz. üretmektedir ve 25 ten fazla ülkeye satış yapmaktadır. Ne yazık ki henüz Cezaire satış yapamadık. Bu konuda bize destek verebilirseniz çok memnun oluruz. Cezair de bulunan Expanded Polystyrene (EPS)üreticileri ve İnşaat veya Yalıtım Malz. Satıcıları-İnşaat Maz. Toptancılarına ve İnşaat ve Mütaitlik firmalarına ulaşmamızda yardımcı olursanız çok memnun oluruz. G.T.I.P. numaralarımız: 3921110000 ve 3925908009 Saygılarımla <o:p _rdEditor_exists=
"1"
></o:p></td> </tr> </tbody> </table>
0
Hello William,
The mso-data-placement style works for br tags, but it is not a panacea. To put the long story short, Microsoft Excel decides on its own how to parse the HTML code according to the Office HTML specification. Unfortunately we cannot control this behavior.
Regards,
Daniel
the Telerik team
The mso-data-placement style works for br tags, but it is not a panacea. To put the long story short, Microsoft Excel decides on its own how to parse the HTML code according to the Office HTML specification. Unfortunately we cannot control this behavior.
Regards,
Daniel
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0

William
Top achievements
Rank 1
answered on 28 Jan 2013, 01:49 PM
Hi there
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/1zg69sj.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i48.tinypic.com/2mx1o3n.png
How can I restrict RadGrid to export each field into a single cell?
I'm using an old version of Telerik but these 2 Events are available in RadGrid
OnGridExporting="grdRapor_GridExporting" OnHTMLExporting="grdRapor_GridExporting"
I found this topic exactly my problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
My column value is
How should I write this method?
This didn't help me
I have a situation where my RadGrid has some rows Containing HTML code
http://i47.tinypic.com/1zg69sj.png
When I export this to Excel, I see separate Excel cells instead of a Single one.
http://i48.tinypic.com/2mx1o3n.png
How can I restrict RadGrid to export each field into a single cell?
I'm using an old version of Telerik but these 2 Events are available in RadGrid
OnGridExporting="grdRapor_GridExporting" OnHTMLExporting="grdRapor_GridExporting"
I found this topic exactly my problem
http://www.telerik.com/community/forums/aspnet-ajax/grid/export-to-excel-with-line-breaks.aspx#1553210
My column value is
<
table
width
=
"600"
class
=
"MsoNormalTable"
style
=
"width: 450pt; mso-cellspacing: .7pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;"
border
=
"0"
cellspacing
=
"1"
cellpadding
=
"0"
> <
tbody
> <
tr
style
=
"mso-yfti-irow: 0; mso-yfti-firstrow: yes;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; width: 20%; padding-right: 0.75pt;
background: #cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Ãœlke<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>CEZAYÄ°R<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 1;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
colspan
=
"2"
><
b
>Talep Sahibinin<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 2;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Adı<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>EMÄ°NE AYDIN ÃœNAL<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 3;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Firma Vergi No<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>1750352027<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 4;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Firma Unvanı<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>BÄ°NA YAPI SANAYÄ° VE TÄ°CARET LTD. ÅžTÄ°.<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 5;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>e-Posta Adresi<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
><
a
href
=
"mailto:emine@bina.com.tr"
><
span
style
=
"color: #0000ff; text-decoration: underline;"
>emine@bina.com.tr</
span
></
a
><
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 6;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
colspan
=
"2"
><
b
>Talep<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 7;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Türü<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>Sektörel İthalatçı Adresi Talep Ediyorum...<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> <
tr
style
=
"mso-yfti-irow: 8; mso-yfti-lastrow: yes;"
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
#cee7ff; padding-top: 0.75pt;border: #f0f0f0;"
><
b
>Konusu<
o:p
_rdEditor_exists
=
"1"
></
o:p
></
b
></
td
> <
td
style
=
"padding-bottom:
0.75pt; padding-left: 0.75pt; padding-right: 0.75pt; background:
aliceblue; padding-top: 0.75pt;border: #f0f0f0;"
>Firmamız
İnşaat Sektöründe Dekoratif ve İzolasyon Malz. üretmektedir ve 25 ten
fazla ülkeye satış yapmaktadır. Ne yazık ki henüz Cezaire satış
yapamadık. Bu konuda bize destek verebilirseniz çok memnun oluruz.
Cezair de bulunan Expanded Polystyrene (EPS)üreticileri ve İnşaat veya
Yalıtım Malz. Satıcıları-İnşaat Maz. Toptancılarına ve İnşaat ve
Mütaitlik firmalarına ulaşmamızda yardımcı olursanız çok memnun oluruz.
G.T.I.P. numaralarımız: 3921110000 ve 3925908009 Saygılarımla <
o:p
_rdEditor_exists
=
"1"
></
o:p
></
td
> </
tr
> </
tbody
> </
table
>
This didn't help me
Protected
Sub
grdRapor_GridExporting(
ByVal
source
As
Object
,
ByVal
e
As
GridExportingArgs)
If
e.ExportType = ExportType.Excel
Then
Dim
css
As
String
=
"<style type='text/css'> br { mso-data-placement: same-cell; } </style>"
e.ExportOutput = e.ExportOutput.Replace(
"</head>"
, css &
"</head>"
)
End
If
End
Sub