Ken, I am using Win32::OLE. Add_worksheet uses the Spreadsheet:WriteExcel module.
Thanks, David -----Original Message----- From: Ken Barker [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 12:07 PM To: Hsu, David; Perl-Win32-Users@listserv.ActiveState.com Subject: RE: Win32:OLE Excel Try $ws1 = $workbook->add_worksheet('worksheetname'); Ken Barker IT Lead Americall Group, Inc 314-213-7927 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hsu, David Sent: Thursday, August 04, 2005 10:23 AM To: Perl-Win32-Users@listserv.ActiveState.com Subject: Win32:OLE Excel Hi, Does someone know of another method of naming the Excel sheets? Currently I am using: ... $Worksheet = $Workbook->Worksheets()->Add(); $Worksheet->{Name} = "test $i"; ... The sheet names are still "Sheet1", "Sheet2", etc... Thanks, David _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs ______________________________________________________________________ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. ______________________________________________________________________ _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
