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

excel and win32 ole

by sumit07 (Novice)
on Sep 08, 2012 at 08:49 UTC ( #992449=perlquestion: print w/ replies, xml ) Need Help??
sumit07 has asked for the wisdom of the Perl Monks concerning the following question:

hello perl monks when i try to save a excel file after adding its custom documents it shows a promt dialig asking if i want to save it or not. but i want to save the file silently in the background. can you help me i try this
my $Book = $Excel->Workbooks->Open('Book1.xls') $Book->{Saved}=0; $Book->Close(); $Excel->Quit();

Comment on excel and win32 ole
Download Code
Re: excel and win32 ole
by Corion (Pope) on Sep 08, 2012 at 09:06 UTC
Re: excel and win32 ole
by philiprbrenan (Monk) on Sep 08, 2012 at 14:35 UTC

    Is it possible to do "save as"?

Re: excel and win32 ole
by rpnoble419 (Pilgrim) on Sep 08, 2012 at 18:21 UTC
    You should look at Excel::Writer::XLSX. I use it for all of my Excel writing needs. Unless you need Excel to process information in a formula as part of your work, this is a much better method...

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://992449]
Approved by marto
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (8)
As of 2015-05-06 05:51 GMT
Find Nodes?
    Voting Booth?

    In my home, the TV remote control is ...

    Results (130 votes), past polls