Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Win32::OLE Open xls from http location

by radiantmatrix (Parson)
on Dec 04, 2008 at 19:18 UTC ( #728070=note: print w/replies, xml ) Need Help??


in reply to Win32::OLE Open xls from http location

There are a couple of things to consider. Firstly, Sharepoint could be blocking the request for some reason. Have you tried poking it with something other than a browser (say, LWP)? It could be authentication issues, SharePoint configuration issues, you name it.

Second, it's possible something else does have that file open and lock: perhaps another copy of Excel, or a previewer of some kind.

Third, depending on your aims, you may want to consider pulling a copy of the data to your local machine before operating on it.

Ultimately, I don't think this is a Perl question so much as a general problem you're having.

<radiant.matrix>
Ramblings and references
“A positive attitude may not solve all your problems, but it will annoy enough people to make it worth the effort.” Herm Albright
I haven't found a problem yet that can't be solved by a well-placed trebuchet
  • Comment on Re: Win32::OLE Open xls from http location

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://728070]
help
Chatterbox?
[1nickt]: I will not convince anyone who disagrees with me, with a sticker. And I don;t need to advertise my thoughts, really.
[Discipulus]: ++1nickt but what about: "out immigrants! just redskins!"
[1nickt]: I know what I believe and whether I have integrity. My actions will speak more.
[karlgoethebier]: choroba Nothing unclever in my sig. And remember: Beeing too clever is a bad mistake ;-)
[1nickt]: This is not to suggest that Karl should remove his slogan. Just thoughts of mine... Trust me I believe I am very much more radical than most, and if I had a slogan for every gross injustice in my sig, there would be no more bytes!
Discipulus redskins .. well native american..
[1nickt]: So if I was to offer any editorial advice it would be to (1) make it endure time passing (2) make it positive (3) make it about you and your beliefs
[1nickt]: (Disicpulus The new best choice is maybe "First People"
[karlgoethebier]: Discipulus: This is called "Volksverhetzung" in German which means
[karlgoethebier]: incitement of the people and it is prohibited by law

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (12)
As of 2017-06-22 12:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (519 votes). Check out past polls.