Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Error in excel reader

by thanos1983 (Parson)
on Jan 02, 2019 at 14:25 UTC ( [id://1227920]=note: print w/replies, xml ) Need Help??


in reply to Error in excel reader

Hello sainky

I do not have a WindowsOS so I can not replicate your error. Although based on a previous similar thread Problem opening WriteExcel generated spreadsheets with OLE, it looks the error is coming from opening the file due to the path.

Can you add this part on your code and let us know if it works?

#!/usr/bin/perl use Cwd; use strict; use warnings; use Cwd 'abs_path'; my $file = $ARGV[0]; my $dir = getcwd; my $abs_path = abs_path($file); print $abs_path . "\n";

Update: My assumption regarding the path of the file was wrong. I did not read clearly your question so my answer is not valid. Fellow Monks have provided you with proposed solutions.

Looking forward to your update. Hope this helps.

BR / Thanos

Seeking for Perl wisdom...on the process of learning...not there...yet!

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others taking refuge in the Monastery: (3)
As of 2024-04-19 22:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found