Export to Excel with Borders

[Atlas]

In the folllowing help article: you indicated that:
Although the HTML Excel format doesn't show any grid lines in the worksheet, you can mimic them by adding the following style to the generated output:
body { border:solid 0.1pt #CCCCCC; }

but you never indicated where this code should be placed?
I was assuming it would be applied to some property related to the export, but could not figure out how to use it.

I ended up doing the following instead:

protected void RadGrid1_ExcelExportCellFormatting(object source, ExcelExportCellFormattingEventArgs e)
{
    GridDataItem item = e.Cell.Parent as GridDataItem;
    e.Cell.Style["border"] = "solid 0.1pt #000000";
}
protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
    if (e.Item is GridHeaderItem && bIsExport)
    {
        GridHeaderItem item = e.Item as GridHeaderItem;
        item.Style["border"] = "solid 0.1pt #000000";
    }
}

which works, but the header row has a border on every cell in the entire workbook.
I only want borders on cells related to the output of the grid.
What is the best way to fix this?

[Daniel]

Hello Nano,

You should add this CSS rule to the exported page's head:

protected void RadGrid1_GridExporting(object source, GridExportingArgs e)
{
    if (e.ExportType == ExportType.Excel)
    {
        string css = "<style> body { border:solid 0.1pt #CCCCCC; }</style>";
        e.ExportOutput = e.ExportOutput.Replace("</head>", css + "</head>");
    }
}

Best regards,
Daniel
the Telerik team

[Atlas]

The solution you provided puts a border on every single row and column in the enitre workbook. I only want the border around the rows and columns of the returned data. If the data is being rendered in a table to Excel, then I want to apply the css there not the entire workbook?

[Atlas]

OK,
With the help of your code, I figured it out:

protected void RadGrid1_GridExporting(object source, GridExportingArgs e)
{
    if(e.ExportType == ExportType.Excel)
    {
        string css = "<style> td { border:solid 0.1pt #000000; }</style>";
        e.ExportOutput = e.ExportOutput.Replace("</head>", css + "</head>");
    }
}

[Ed]

Would anyone like to share this solution with us VB.Net developers that are having difficulity translating this C# code to VB.Net?

Please!

[OPL]

Hi,

Try this : http://converter.telerik.com/

Bye

[Israel]

THANKS!!!!