Print Workbook wihout use of RadSpreadsheet

[Bartek]

I have created a Telerik.Windows.Documents.Spreadsheet.Model.Workbook (with a single Worksheet) programmatically. I can export it to Excel no problem.

How can I print it?

I have found the following article: https://docs.telerik.com/devtools/wpf/controls/radspreadsheet/features/ui-printing#How_to_print_RadSpreadsheet

...but this would force me to work with the UI Control, which I don't want to do. Is it possible to print the Worksheet without the use of the UI control. I still want all the printing options, such as setting a header and footer, forcing the first row to be repeated on every page, control over portrait vs. landscape printing, etc.

Is there any way to do this?

Thanks in advance,

Bartek

[Martin]

Hi Bartek,

In the article that you mentioned, there is a section which explains how to programmatically print a Workbook from RadSpreadsheet. Using the PrintWhatSettings class you can specify whether to print the Active Sheet, the Entire Workbook or the current Selection. If you need to set a different print option of the Worksheet, you can take a look at the Worksheet Page Setup article for detailed information.

Printing the Workbook directly is not possible as the content should be prepared for visualizing before sending it to the printer. This operation is possible with the help of RadSpreadsheet.

Hope that printing silently using the control would fit your needs.

 

Regards,
Martin
Progress Telerik