I found the correct module to install (OLE::Storage). All others would not compile due to a "cl.exe" error. Serge ------------------------------------------------------------------------ -------------- Serge Belich Phone: 201.536.4376 Fax: 201.435.3123 Cell: 203.623.6252 OptiMark Technologies, Inc., Integration Services, 10 Exchange Place Centre, 24th Floor, Jersey City, NJ 07302 -----Original Message----- From: Belich, Serge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 16, 2000 4:21 PM To: Perl-Win32-Users Mailing List Subject: RE: How do I create a new Excel file Is is possible to test this script by just installing the Win32-OLE-0.12 tar file? I have tried only to get the following error: --------------------------------------------------------------------------- C:\perl\Win32-OLE\Win32-OLE-0.12>nmake Microsoft (R) Program Maintenance Utility Version 1.50 Copyright (c) Microsoft Corp 1988-94. All rights reserved. cl.exe -c -Od -MD -DNDEBUG -TP -GX -DWIN32 -D_CONSOLE -DNO_STRICT -DHAV E_DES_FCRYPT -DPERL_OBJECT -Od -MD -DNDEBUG -TP -GX -DVERSION=\"0.12\" -DXS _VERSION=\"0.12\" -IC:\Perl\lib\CORE OLE.cpp The name specified is not recognized as an internal or external command, operable program or batch file. NMAKE : fatal error U1077: 'C:\WINNT\system32\cmd.exe' : return code '0x1' Stop. ---------------------------------------------------------------------------- Thanks in advance, Serge ------------------------------------------------------------------------ -------------- Serge Belich Phone: 201.536.4376 Fax: 201.435.3123 Cell: 203.623.6252 OptiMark Technologies, Inc., Integration Services, 10 Exchange Place Centre, 24th Floor, Jersey City, NJ 07302 -----Original Message----- From: Ewen, Ed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 10, 2000 4:04 PM To: Perl-Win32-Users Mailing List Subject: FW: How do I create a new Excel file David, Works like a charm - Thanks. Ed Ewen (404) 575-3531 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: David Lewis [SMTP:[EMAIL PROTECTED]] <mailto:[SMTP:[EMAIL PROTECTED]]> Sent: Wednesday, May 10, 2000 3:28 PM To: Ewen, Ed Subject: Re: How do I create a new Excel file To create a new Excel workbook, use the following command: $book = $ex->Workbooks->Add(); then, to save it, use: $book ->SaveAs('path\test.xls'); ----- Original Message ----- From: Ewen, Ed <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > To: Perl-Win32-Users Mailing List <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Sent: Wednesday, May 10, 2000 1:25 PM Subject: How do I create a new Excel file > Hi all, > > The following code works with an existing .xls file, but I can't seem to > create a new one. I've tried prefixing the filename >testfile.xls and using > New(Excel.Workbook) - all to no avail. > Any ideas? TIA > > use Win32::OLE; > $ex = Win32::OLE->GetActiveObject('Excel.Application'); > if (!$ex) { > $ex = Win32::OLE->new('Excel.Application', sub {$_[0]->Quit;}) > or die "Cannot create excel session - $!"; > } > > $book = $ex->Workbooks->Open('test.xls'); > > $book->Worksheets(1)->Cells(1,1)->{Value} = 'Hello'; > $book->Worksheets(1)->Cells(1,2)->{Value} = 'World'; > $book->save; > > > > Ed Ewen > (404) 575-3531 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > --- > You are currently subscribed to perl-win32-users as: [EMAIL PROTECTED] > To unsubscribe, forward this message to > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > For non-automated Mailing List support, send email to > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > --- You are currently subscribed to perl-win32-users as: [EMAIL PROTECTED] To unsubscribe, forward this message to [EMAIL PROTECTED] For non-automated Mailing List support, send email to [EMAIL PROTECTED] --- You are currently subscribed to perl-win32-users as: [EMAIL PROTECTED] To unsubscribe, forward this message to [EMAIL PROTECTED] For non-automated Mailing List support, send email to [EMAIL PROTECTED] --- You are currently subscribed to perl-win32-users as: [archive@jab.org] To unsubscribe, forward this message to [EMAIL PROTECTED] For non-automated Mailing List support, send email to [EMAIL PROTECTED]
