B4J Question B4J Pie Printing can't get it working

[JackSparrow]

I am running Erel's sample program from Here

The program creates the excel file but fails to print a PDF file, if I go into the file I can print it

I have Bullzip printer installed and PDF Viewer Plus. I saw another post that mentioned Java and Office not getting along unless they are both 32 or 64 bit. I have checked and both are 64 bit

The error message in B4J logs is as follows


Waiting for debugger to connect...
Program started.
Call B4XPages.GetManager.LogEvents = True to enable logging B4XPages events.
Unable to index into an object of type System.__ComObject.
At line:1 char:149
+ ; & {$objExcel = New-Object -ComObject excel.application;$workbook = $objE
xcel.workbooks.open('C:\Users\xxxxxxx\Desktop\test.xlsx', 3);$workbook.Sheets[ <<<<
1].ExportAsFixedFormat($xlFixedFormat::xlTypePDF, 'C:\Users\xxxxxx\Desktop\test.p
df');$objExcel.Workbooks.close();$objExcel.Quit()}
+ CategoryInfo : InvalidOperation: (1:Int32) [], RuntimeException
+ FullyQualifiedErrorId : CannotIndex

I haven't seen any other posts with this thread so it may be my system config. Can anyone advise of a possible solution

Cheers

 

[Erel]

Please post the relevant code.

 

[JackSparrow]

Thanks for the reply Erel
It's the untouched sample program https://www.b4x.com/android/forum/threads/xlutils-generate-pdf-reports.131119/



Here's a screenshot

 

[Erel]

Which version of Office is installed?

What happens if you change line 70 to:

Wait For (xl.PowerShellConvertToPdf(f, f.Replace(".xlsx", ".pdf"), -1, True)) Complete (Success As Boolean)

SheetIndex is set to -1 instead of 0.

 

[JackSparrow]

Many Thanks Erel

That line changed made it work
Incidentally, It's office

Thanks again