@mullu,
Good to know that the suggested code segment works for your needs.
You may try to use WorksheetRender.ToPrinter(). See the following line of code: e.g Sample code:
.......... //Print worksheet using SheetRender SheetRender sr = new WorkbookRender(worksheet, new ImageOrPrintOptions()); sr.ToPrinter(...........);
hello, the samplecode is not working. In sheetrender is not method for the printersettings.
Is there perhaps an other way or do i have to delete every worksheet except the one that has to be printed?
Thank you Dominik
Yes, there is no overload of the method which accepts printer settings as an argument.
I think you may easily cope with it. You can hide all the worksheet except your desired worksheet (in the workbook) before rendering via WorkbookRender.