How to customize font style, size in print settings while printing RadSpreadsheet (Export Telerik RadGridView to Workbook) in wpf?

[Barani]

Hello,

With reference to the below link,
https://www.telerik.com/forums/add-header-to-each-pages-when-export-telerik-radgridview-to-a-workbook-exporttoworkbook-in-wpf

I need to set font size for the workbook (overwrite default settings) and also apply word wrap for the columns. I have implemented with the above reference. Can you please guide me to achieve this? or if any idea or lead much appreciated. Please let me know if you need more information.

Thanks in advance.

[Barani]

Hi,

Is there any update on the above issue?

[Dimitar]

Hi Barani,

To achieve this you can export the grid to a Workbook and then set the properties. Here is an example of this: 

private void RadButton_Click(object sender, RoutedEventArgs e)
{
    var workbook = radGridView1.ExportToWorkbook();
    var worksheet = workbook.Worksheets[0];

    var selection = worksheet.Cells[0,0,worksheet.UsedCellRange.RowCount,worksheet.UsedCellRange.ColumnCount];
    selection.SetFontSize(22);
    selection.SetIsWrapped(true);

    XlsxFormatProvider provider = new XlsxFormatProvider();
    File.WriteAllBytes(@"..\..\..\result.xlsx", provider.Export(workbook));
}

More information is available here: SpreadProcessing - Get, Set, and Clear Cell Properties - Telerik Document Processing

I hope this helps. Should you have any other questions do not hesitate to ask.

Regards,
Dimitar
Progress Telerik

[Barani]

Hi Dimitar, thank you for your response. It helped to achieve my requirement. Also I have another issue, can we customize the worksheet to color specific cells with some logic e.g. I need to color the cells which have same words. How to do this and where to write the logic after ExportToWorkbook() functionality.

[Dimitar]

Hi Barani, 

You can use conditional formatting for this. Detailed information is available here: SpreadProcessing - Conditional Formatting.

Let me know if I can assist you further.