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

Re: (OT) Excel reading problem

by Anonymous Monk
on Sep 16, 2014 at 22:58 UTC ( [id://1100856]=note: print w/replies, xml ) Need Help??


in reply to (OT) Excel reading problem

[excel button], [excel format], [ddg://site:perlmonks.org excel button], [ddg://site:perlmonks.org exc +el format]
excel button, excel format, site:perlmonks.org excel button, site:perlmonks.org excel format, site:perlmonks.org excel save-as prompt alert button, site:perlmonks.org excel save-as format prompt alert ... $Excel->{DisplayAlerts}=0;

saveas ... and see the relevant documentation on msdn )

Replies are listed 'Best First'.
Re^2: (OT) Excel reading problem
by merrymonk (Hermit) on Sep 17, 2014 at 15:12 UTC
    The display alerts worked so that setting it to 0 before opening the file and then to 1 after all had been done, I no longer got the error message.

    The actual line that caused the message seems to be

    $workbook->Close;
    which makes sense to me.

    Thank you.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (6)
As of 2024-04-18 22:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found