Columns width on export

[Alex Dybenko]

     Hi,

when I manually resize columns on PivotGrid and then run Export to Excel (or PDF) - row descriptor columns (Day, Aggregates) are same size in Excel, but aggregates columns somehow resized. Is it by design or there is a way to export row descriptor columns width as well?

Alex

 

[Dimitar]

Hello Alex,

By default the custom width is not exported, however, you can set the width after the workbook is created. The following code shows how you can get the width from the pivot as well:

void button_Click(object sender, EventArgs e)
{
    PivotGridSpreadExport spreadExport = new PivotGridSpreadExport(this.radPivotGrid1);
    spreadExport.ExportVisualSettings = true;
    var renderer = new SpreadExportRenderer();
    renderer.WorkbookCreated += Renderer_WorkbookCreated;
    spreadExport.RunExport(@"D:\exported-file.xlsx", renderer);
}

private void Renderer_WorkbookCreated(object sender, WorkbookCreatedEventArgs e)
{
    var sheet = e.Workbook.Sheets[0] as Worksheet;
    sheet.Columns[0].SetWidth(new ColumnWidth(GetWidth(0), true));
    sheet.Columns[1].SetWidth(new ColumnWidth(GetWidth(1), true));
    sheet.Columns[2].SetWidth(new ColumnWidth(GetWidth(2), true));
}
public int GetWidth(int column)
{
    int width = 100;
    foreach (RadElement element in this.radPivotGrid1.PivotGridElement.RowDescriptorsArea.Children)
    {
        PivotGroupDescriptorElement group = element as PivotGroupDescriptorElement;
        if (group == null)
        {
            continue;
        }
        if (radPivotGrid1.RowGroupDescriptions.IndexOf(group.GroupDescriptor) == column)
        {
            width = group.Size.Width;
        }

    }
    return width;
}

I hope this will be useful. Let me know if you have additional questions.

Regards,
Dimitar
Progress Telerik

[Alex Dybenko]

Thanks Dimitar, works fine!