Excel export options?

[Aldus@Monitor]

Hi,

We have been using the PDF Converter since 2.5 and we are now looking on some old code for Excel Export/Print that we no longer can find documentation about. We are currently using 4.0.x.x and are planning to move to 5.x.

We use the following options before Excel Export/Print:

Code: Select all

	SetPrinterParamInt(PDFPrinter, "OptimizeLevel", 3)

Code: Select all

	/*
	'///////////////////////////////////////////////////////////////
	'EXCEL MultiSheets Integer Excel output option
	'0 - No Excel output
	'16 - All document pages on a single sheet
	'17 - One excel sheet per document page
	'18 - Single Excel sheet with comma separator
	'19 - MultiSheets Excel sheet with comma separator

	'Example: SetPrinterParamInt PDF, "Excel MultiSheets", 17
	*/
	
	SetPrinterParamInt(PDFPrinter, "Excel MultiSheets", 18) 

1. OptimizeLevel: Does this option still work? I can only find a documentation of "OptimizeDocument". If it still exists: is it the same numeric values? Should I use 3 for Excel?
http://www.amyuni.com/WebHelp/Amyuni_PD ... Method.htm
2. Excel MultiSheets: In the documentation the numeric values 18 and 19 are no longer covered? Do they still exist? If not: what should I use instead of 18?
http://www.amyuni.com/WebHelp/Amyuni_Do ... ramInt.htm

Regards
Aldus

[Jose]

Hello,

The parameter values for the Export to Excel option has not changed since version v2.5 and you can continue to use the same values.

However for Optimization I suggest that you use the syntax below.

////////////////////////////////////////////////////////////////
//' Optimization Level OptimizeLevel value
//' No optimization 0
//' Line optimization (Recommended) 1
//' Paragraph optimization 2
PDF.SetPrinterParamInt("EXCEL Optimization",1);

Thanks

[Aldus@Monitor]

Hello,

Interesting information, thx.

I cannot find any documentation about "EXCEL Optimization" option here:
http://www.amyuni.com/WebHelp/Amyuni_Do ... ramInt.htm

Only following options:

Code: Select all

Custom parameters for the Excel Converter
EXCEL MultiSheets  Integer
 Excel output option
 0: No Excel output.
16: All document pages on a single sheet.
17: One excel sheet per document page.
 

TIFF Options  Integer
TIFF compression level
0: No TIFF Output.
16: TIFF output with no compression.
26: TIFF output with CCITT Fax Compression.

All other values reserved for future use.

Can it be that the documentation for TIFF options should be replaced with information about "EXCEL Optimization"?

Regards
Aldus