|
| [WD19] Print settings Excel via xlsDocument variable |
| Iniciado por guest, 04,sep. 2015 11:06 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 04,septiembre 2015 - 11:06 |
Hi all,
I create in my software an Excel-file via xlsDocument, xlsColumn and xlsCell variables.
That works quit good. But is it also possible to set a number of print settings via this xlsDocument variable ?
I would like to set the print orientation to Landscape, the marges to Small and the scale to Fitting for one page. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,septiembre 2015 - 08:52 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,septiembre 2015 - 09:54 |
Hi Stefan,
This won't work with the standard xlsxxx functions as these create a standard application independent workbook file.
You'll need to do this using ole with Excel.
XLSApp is object dynamic
XLSApp = Excel.application
and so on and so on...
We have several Excel generators that even create Excel workbooks with pivot-tables in them.
Works great as long as the data sets to transfer via ole are not too big (<100.000 rows).
Ciao,
Peter H. |
| |
| |
| | | |
|
| | | | |
| | |
|