Setting cell width in an Excel cell via GridExcelBuilder

[Martillo]

When using the GridExcelBuilder to add a new cell (and row) to a worksheet when exporting from the RadGrid, is there a way to specify the width of the cell as in the pseudo-code below?

protected void Grid_ExcelMLExportRowCreated ( object source, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLRowCreatedArgs e )
{
    if ( e.RowType == GridExportExcelMLRowType.HeaderRow )
    {
        RowElement myNewRow = new RowElement();
        CellElement myNewCell = new CellElement();
        myNewCell.StyleValue = "myNewStyle";
        myNewCell.MergeAcross = e.Row.Cells.Count - 1;
        //is there something like the property below?
        myNewCell.Width = 200;
        //etc...
    }
}

Thanks,

Keith

[Daniel]

Hello Martillo,

The width of your cells depends on the width that is set to the relevant column (as in MS Excel). Here is how to set a width to given column:

bool tempFlag = false;
protected void RadGrid1_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)
{
    int colCount = e.Worksheet.Table.Columns.Count;
    if (colCount > 0 && !tempFlag)
    {
        tempFlag = true;
        e.Worksheet.Table.Columns[0].Attributes["ss:Width"] = "200";
        e.Worksheet.Table.Columns[1].Attributes["ss:Width"] = "600";
    }
    ...
}

Best regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Martillo]

Thanks Daniel. That worked like a charm.