Generate PDF for each sheet of excel worksheet with command line

Hi all,

I try to generate PDF for each sheet of excel worksheet with command line of PDFCreator, but only one sheet is converted !
I've succeed to do this with Word document and the parameter OptionsFile but with the same parameter, I retrieve only one sheet of the Excel worksheet ?
Thank you for your help !

Norman

Hi,

i havn´t tried yet, but it is probably the excel printing settings causing this. By default, only the active worksheet is printed and i didn´t find a possibility anywhere to change the default setting for this.

regards,

Robin

Hi Robin,

 

yes, I have disabled the parameter AllowSpecialGSCharsInFilenames (=0) in my ini file.

I had the problem for Word documents so I changed the value to zero.

Do you succeed printing the entire excel workbook in different pdf files with PDFCreator command line ?

Could you send me your ini file and the command line you use ?

Regards

Norman.

Hi,

 

do you have "Allow special Ghostscript chars in filenames" enabled (under options->save)?

If yes please try disabling it.

 

regards,

 

Robin