Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

Re:(5) Reading from Excel

by cacharbe (Curate)
on Aug 09, 2002 at 19:23 UTC ( #189010=note: print w/replies, xml ) Need Help??

in reply to Re: Re: Re: Re: Reading from Excel
in thread Reading from Excel

I tried to break linking for about 1/2 hour and failed to repeat your error, without recalculating the sheet and without $Book->UpdateLink({Name=> $Book->{LinkSources}}); So, allow me to suggest a course of action, if you please.

Debug a little using Win32::OLE->LastError(). After you try to open your files, print Win32::OLE->LastError()."\n";, after you try to get the values, print Win32::OLE->LastError()."\n"; You get the idea.

Something is happening that you are making assumptions about, and I think somewhere your assumptions are wrong, or as Inigo would say "I do not think it means what you think it means."

Perhaps if you built an example that breaks but doesn't use proprietary files such that you could post the code. As I say, I tried to replicate your error using the code given without any luck, and I can post my code if you like to double check my understanding vs. your meaning.


Flex the Geek

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (12)
As of 2016-10-26 17:26 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (344 votes). Check out past polls.