Beefy Boxes and Bandwidth Generously Provided by pair Networks Cowboy Neal with Hat
Clear questions and runnable code
get the best and fastest answer
 
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();

[download]

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

    Is it possible to do "save as"?

[reply]
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...
[reply]

Back to Seekers of Perl Wisdom

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 perusing the Monastery: (12)
As of 2013-06-19 21:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How many continents have you visited?









    Results (675 votes), past polls