hihide column & format cells when export excel

[appdev]

hi,
how do i hide column from a grid? i use data to bind to the grid and have autogenerate columns enable.  i tried radgrid1.masterviewtable.items(0).visible=false. could you tell me what the correct syntax is? Also when i export data how do i format the columns or cells ? thank you very much for helping.

[Princy]

Hello Duy,

You can try out the following code, where the column UniqueName property is used to hide autogenerated columns on exporting. The UniqueName for AutoGenerated Columns will be same as its DataField.
cs:

protected void ExportButton_Click(object sender, EventArgs e)
    {
        RadGrid1.MasterTableView.GetColumnSafe("ColumnUniqueName").Visible = false;

        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();

    }

For more information on exporting you can refer to the following link
Exporting tips and tricks

Thanks
Princy.

[appdev]

thank you and sorry my english isn't good. what i meant is to hide column when display on the web. and for exporting, i want to make a header column bold with gridline...etc so two separate things. thank you for the other advise now i know how to hide column when exporting. very nice.

[appdev]

anyone could help me?

[Daniel]

Hello Duy,

This is a possible approach with CSS:

<style type="text/css">
.GridHeader_yourSkinName
{
    border: solid 1px black !important;
    font-weight: bold !important;
}
</style>

Please modify the code-snippet to use the actual name of your skin.

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Shinu]

Hi Duy,

You can also give a try with the following code snippet which set the style for the Grid header in the click event of the Export Button.

CS:

 protected void Button1_Click(object sender, EventArgs e)
    {

        foreach (GridHeaderItem header in RadGrid1.MasterTableView.GetItems(GridItemType.Header))
        {
            header.BorderStyle = BorderStyle.Solid;
            header.Font.Bold = true;

        }
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

Thanks
Shinu.