ExcelOptions object specifies additional Microsoft Excel
ExcelOptions object specifies additional MS Excel processing options used when converting
Excel documents. These options are used
only if special document processing for
Microsoft Excel is turned on with UseAutomation property
of BatchProcessingOptions object.
You may retrieve an ExcelOptions object instance using ExcelOptions property
of BatchProcessingOptions object:
Here P2F refers to Server object instance.
Then you can access its properties and methods using a reference to the
||This property specifies whether
to use printing resolution stored in Excel document sheets properties and
shown in the Page Setup window (false) or to use the printing resolution
specified with the Resolution property of
(true), i.e. if printing resolution of Excel sheets should be overridden
with Print2Flash Printer resolution or not.
MS Excel is known to launch multiple print jobs when sheets of different
resolutions are encountered. It may result in Print2Flash capturing only the
first sheet range printed with the same resolution and skipping the other
sheets. You may guarantee that such situation cannot happen if you set this
property to true. However, in this case keep in mind that the sheet
resolution stored in the Excel document is ignored. Also note that you
cannot convert a workbook with sheets with different resolution if
single file or external viewer output format
||This property specifies which
workbook sheets should be converted to Print2Flash format. Sheets that do not fit the
specified range are skipped at printing. The string should be in the
[Range1Start[-][Range1End]] [,Range2Start[-][Range2End]] [, ... ]
This string is composed of a sequence of sheet ranges separated by commas.
Each range can be either a plain sheet number such as "3", a
such as "2-7" or an open sheet range such as "20-".
For example, string "1,3-5,8-" instructs to print sheet 1, sheets from
3 to 5,
and sheets from sheet 8 till the last sheet. Sheet 2, 6 and 7 are skipped and not included in the output
Empty string value makes Print2Flash print all document sheets.
You cannot change the order of sheets contrary to the order of sheets in the
Excel workbook. For example, if you specify "2,3,1", the document will still
be printed in the natural order "1,2,3".
Similarly, you cannot print any sheet twice. For example, "1,1" will print
the first sheet only once.
If you changed properties of this object and want to save the changes, use
ApplyChanges method of the
BatchProcessingOptions object which contains this ExcelOptions object instance.
The following example obtains an ExcelOptions object instance, changes its
SheetRange property to allow printing only of the first three sheets and saves the changes:
Here P2F refers to a Server object instance.