Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: Excel Const - No type library matching error message

by merrymonk (Hermit)
on Dec 06, 2017 at 21:07 UTC ( [id://1205052]=note: print w/replies, xml ) Need Help??


in reply to Re: Excel Const - No type library matching error message
in thread Excel Const - No type library matching error message

I got this on my PC
Microsoft Excel 14.0 Object Library C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
Microsoft Excel 14.0 Object Library C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE

Is that the sort of output you are expecting?
I will get the Perl run on the 2 other systems tomorrow and post here what is obtained.

Replies are listed 'Best First'.
Re^3: Excel Const - No type library matching error message
by merrymonk (Hermit) on Dec 08, 2017 at 10:41 UTC
    I now have the results of running the test on two different systems with the same version of Perl.
    On the system where the Const variants failed, nothing was printed out.

    On the system where the Const was successful, the following was written out.

    Microsoft Excel 15.0 Object Library C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE
    AdHocReportingExcelClientLib C:\Program Files (x86)\Microsoft Office\Office15\ADDINS\Power View Excel Add-in\AdHocReportingExcelClient.dll
    Microsoft Excel 15.0 Object Library C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE
    AdHocReportingExcelClientLib C:\Program Files (x86)\Microsoft Office\Office15\ADDINS\Power View Excel Add-in\AdHocReportingExcelClient.dll

    From this I gather that there is something missing from the failing system and that this may be something like the dll shown.
    What is the simplest way to correct this? Is it as simple as copying the dll?

      Does the failing system have Excel installed ?

      poj
        Yes - it is on a user's system. My Perl applications reads from and writes to various spreadsheets. I also save copies of spreadsheets to pdf files. Also I know Excel is used to modify the spreadsheets that I read from.
        Some of the Excel 'lines' I use successfully are below

        eval { $excel = Win32::OLE->GetActiveObject( 'Excel.Application' ) }; eval { $workbook = $excel->Workbooks->Open($hist_full)}; $worksheet = $workbook->Worksheets($wksh_no); $$ref_cell_array = $worksheet->range($excel_data_range)->{'value'}; $close_res = $workbook->Close();

        The odd thing is that 'Const' was not causing a problem and then it was reported as not working.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1205052]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2024-03-28 13:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found