This is a migrated thread and some comments may be shown as answers.

Print Workbook wihout use of RadSpreadsheet

1 Answer 45 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Bartek
Top achievements
Rank 1
Bartek asked on 03 Dec 2018, 08:28 PM

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

1 Answer, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 06 Dec 2018, 04:45 PM
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
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Spreadsheet
Asked by
Bartek
Top achievements
Rank 1
Answers by
Martin
Telerik team
Share this question
or