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

Export to Excel Custom Header Issue

2 Answers 114 Views

Grid

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

Rob asked on 03 Jun 2013, 05:52 PM

ExportIssue.jpg

I'm using v2011.3.1305.40, VS2010, & IE8. I'm attempting to export a custom header above the grid. Everything is working fine except cell A1 had a border around it by default. Please see attatchment. I was able to reproduce the issue at the simplest level. How can I make this not happen?

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="TestGrid.aspx.vb" Inherits="Pages_Business_TestGrid" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

</telerik:RadScriptManager>

<telerik:RadGrid ID="dg" runat="server" AutoGenerateColumns="false">

<MasterTableView>

<Columns>

<telerik:GridBoundColumn HeaderText="ID" DataField="ID"></telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:Button ID="btnExport" runat="server" Text="Export" />

</div>

</form>

</body>

</html>

Partial Class Pages_Business_TestGrid

Inherits System.Web.UI.Page

Protected Sub dg_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles dg.NeedDataSource

Dim dt As New DataTable

Dim r As DataRow

Dim col As New DataColumn("ID", GetType(Integer))

dt.Columns.Add(col)

For i As Integer = 1 To 10

r = dt.NewRow

r("ID") = i

dt.Rows.Add(r)

Next

dg.DataSource = dt

End Sub

Protected Sub btnExport_Click(sender As Object, e As System.EventArgs) Handles btnExport.Click

Dim sb As New StringBuilder

sb.Append("<table>")

sb.Append("<tr>")

sb.Append("<table >")

sb.Append("<tr>")

sb.Append("<td>Date : </td>")

sb.Append("<td>")

sb.Append(Now.ToShortDateString)

sb.Append("</td>")

sb.Append("</tr>")

sb.Append("<tr>")

sb.Append("<td>Time : </td>")

sb.Append("<td>")

sb.Append(Now.ToShortTimeString)

sb.Append("</td>")

sb.Append("</tr>")

sb.Append("<tr>")

sb.Append("<td> </td>")

sb.Append("<td></td>")

sb.Append("</tr>")

dg.MasterTableView.Caption = sb.ToString

dg.ExportSettings.OpenInNewWindow = True

dg.ExportSettings.ExportOnlyData = True

dg.ExportSettings.IgnorePaging = True

dg.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html

dg.MasterTableView.ExportToExcel()

sb.Append("</table>")

sb.Append("</tr>")

sb.Append("</table>")

End Sub

End Class

2 Answers, 1 is accepted

Accepted

answered on 06 Jun 2013, 10:07 AM

Hi Rob,

You could remove the border by setting GridLine to None. Check out the following code snippet.

<telerik:RadGrid ID="dg" runat="server" AutoGenerateColumns="false" OnGridExporting="dg_GridExporting" GridLines="None">

<MasterTableView>

<Columns>

<telerik:GridBoundColumn HeaderText="ID" DataField="ID"></telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

Regards,
Kostadin
Telerik

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 the blog feed now.