+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Excel export set parameters without user interaction


(Patrick Horn) #1

When exporting to Excel the LLPrintOptionsDialog allows the user to check / uncheck “All pages into one table”. I want this unchecked, but do not want the user dialog. So how do I set this to false in code?


(combit Support - Christian Rauchfuß) #2

Hi Patrick,

thank you for your post.

You can check/uncheck this property by using the LL ExportOption “XLS.AllPagesOneSheet”:

//check property - "0" for uncheck
LL.ExportOptions.Add(LlExportOption.XlsAllPagesOneSheet, "1")		
//suppress print options dialog
LL.AutoShowPrintOptions = False;									
LL.Print();

More detailed information you will find in your programmer’s reference in chapter "7.3.1. Excel Export ". In chapter “2.4.9. Export > Export Without User Interaction” and “7.2.5. Export Without User Interaction” you will find some code snippets or you can have a look in our export examples, which are delivered for many programming languages (…combit\LL19\Programmable Samples and Declarations<ProgrammingLanguage>\Export Sample).

Best regards,

Christian Rauchfuß
Technical Support
combit GmbH