Since I'm still rather new, I was wondering if anyone with more experience
than I could answer a question before i test it and possibly ruin data.
On an existing workbook with two or more sheets, is it possible to select
a specific sheet by name or create a new one:
IE: i need to collect information daily and dump it into file.xls, would
this code work to use the existing page for the day if it is there or make
it and use it if not?
my $ws = $report->Worksheets("$date - General");
if not, how would i go about testing for a particular sheet and create it
if not? i assume creation would look something like
my $ws = $workbook -> Worksheets(1);
$ws -> { 'Name' } = "$date - General";
but have no idea how to test aside form checking for an error returned on
the first.
If you would like to see the full code, since there is a freeware program
it uses, I have zipped them and placed them on the web at:
http://s58.yousendit.com/d.aspx?id=3HAALXPD1QNS005WV01HL9JULR
while most lines in the code are 80 characters or less, some are not, and
there's the psinfo.exe, between the two i felt this would be the best way
to "attach" the code for those who want to review it. in entirety before
giving advice.
thank you in advance for your time and consideration.
-Josh
-----------------------------------------
PLEASE NOTE:
SeaChange International headquarters in Maynard, MA is moving!
Effective March 1, 2006, our new headquarters address will be:
SeaChange International
50 Nagog Park
Acton, MA 01720 USA
All telephone numbers remain the same:
Main Corporate Telephone: 978-897-0100
Customer Service Telephone: 978-897-7300
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
