This is a migrated thread and some comments may be shown as answers.

RadGrid exporting to multiple cells in Excel instead of one

5 Answers 131 Views
Grid
This is a migrated thread and some comments may be shown as answers.
William
Top achievements
Rank 1
William asked on 28 Dec 2012, 08:14 AM
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"

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
This didnt help me

5 Answers, 1 is accepted

Sort by
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
<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>
How should I write this method?
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"

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
This didnt help me

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"

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
This didnt help me

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
Daniel
Telerik team
answered on 02 Jan 2013, 03:52 PM
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
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
<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>
How should I write this method?
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

 
Tags
Grid
Asked by
William
Top achievements
Rank 1
Answers by
William
Top achievements
Rank 1
Daniel
Telerik team
Share this question
or