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

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?

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 examining the Monastery: (2)
As of 2015-10-04 04:03 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (98 votes), past polls