B4J Question (Solved) Error Generate PDF reports [XLUtils]

[aeric]

Referring to the example

[XLUtils] Generate PDF reports

XLUtils v1.13 adds support for converting workbooks to PDF. This is a Windows only feature and it relies on Excel being installed on the computer. Exporting to PDF is a matter of calling: Wait For (xl.PowerShellConvertToPdf(WorkbookFile, OutputPDF, SheetIndex, True)) Complete (Success As...

www.b4x.com

I can successfully save the excel file but am getting error when exporting the PDF.

You cannot call a method on a null-valued expression.
At line:1 char:58
+ ... application;$workbook = $objExcel.workbooks.open('C:\Users\aeric\Desk ...

Waiting for debugger to connect...
Program started.
Call B4XPages.GetManager.LogEvents = True to enable logging B4XPages events.
You cannot call a method on a null-valued expression.
At line:1 char:58
+ ... application;$workbook = $objExcel.workbooks.open('C:\Users\aeric\Desk ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull
 
Cannot index into a null array.
At line:1 char:150
+ ... t.xlsx', 3);$workbook.Sheets[1].ExportAsFixedFormat($xlFixedFormat::x ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : NullArray
 
You cannot call a method on a null-valued expression.
At line:1 char:268
+ ... esktop\Pie\B4J\Objects\test.pdf');$objExcel.Workbooks.close();$objExc ...
+                                       ~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull
 
Exception calling "Quit" with "0" argument(s): "Unable to cast COM object of type
'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'.
This operation failed because the QueryInterface call on the COM component for the interface with IID
'{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception
from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))."
At line:1 char:296
+ ... \B4J\Objects\test.pdf');$objExcel.Workbooks.close();$objExcel.Quit()}
+                                                         ~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : InvalidCastException

 

[Erel]

Works fine here...

Are you sure that Excel is installed properly?

 

[aeric]

I just run Office update.
Still the same.
I will check again later after restart.

 

[teddybear]

Do you comment the xl.OpenExcel(f)?

 

[aeric]

Do you comment the xl.OpenExcel(f)?

This code is not inside the example.

 

[Erel]

The way to debug it is to run the powershell script from powershell. You can find it inside XLUtils.b4xlib.

 

[teddybear]

Try exporting to or save as pdf with excel?

 

[aeric]

Try exporting to or save as pdf with excel?

It works with the application.

 

[aeric]

I have solved it by doing a Repair.

I think current System updates corrupted the installation.

 

[aeric]

Maybe I am not alone.

Microsoft.Office.Interop.Word issues after the recent Office updates | Microsoft Community Hub

I use Interop.Word from a Winforms application for interaction with Word documents. Everything was okay until the latest Office 365 updates on 10/31. Word...

techcommunity.microsoft.com

 

[aeric]

My guess is this update, (MS said they "fixed" some issues):

Version 2409: September 23​

Version 2409 (Build 18025.20096)

Resolved issues​

Excel​

• We fixed issues users could encounter applying conditional formatting via the Top10 Interop object in Add-in, which included requiring a restart and potential data loss.

Release notes for Current Channel releases - Office release notes

Provides IT Pros with release notes for Monthly Channel releases for Microsoft 365 Apps.

learn.microsoft.com