Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

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
Replies are listed 'Best First'.
Re: excel and win32 ole
by Corion (Pope) on Sep 08, 2012 at 09:06 UTC
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...
Re: excel and win32 ole
by philiprbrenan (Monk) on Sep 08, 2012 at 14:35 UTC

    Is it possible to do "save as"?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (10)
As of 2015-07-08 05:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (94 votes), past polls