RE: Win32::OLE 7 Excel

2004-03-11 Thread Charles K. Clarkson
Saadat Saeed [EMAIL PROTECTED] wrote: : : Now it gives me an error :-( : : syntax error at mailrep.pl line 52, near ); : Execution of mailrep.pl aborted due to compilation : errors. Please stop top-posting! If you post a little more code, we can show you how to properly use a while

RE: Win32::OLE 7 Excel

2004-03-11 Thread Saadat Saeed
Hello, At the bottom is my is my entire code. Ofcourse all it does is get data out of a Lotus Notes server and dump it into excel. If you see the last lines I want to change the column width of a column in Excel. and that doesn't happen! Regards Saadat Saeed use strict; use Win32::OLE

Win32::OLE 7 Excel

2004-03-10 Thread Saadat Saeed
Now Using Win32::OLE I could input Data into an Excel sheet using the perl docs by ActiveState. However now I also want to format Here is my code snippet $Range = $Sheet-Range(E1); with (my $r = $Sheet-Columns($Range), ColumnWidth = 1); Very simple eh? Any reason why it would not work

Re: Win32::OLE 7 Excel

2004-03-10 Thread Hari Fajri
change 'with' - 'while' while (my $r = $Sheet-Columns($Range), ColumnWidth = 1); Saadat Saeed [EMAIL PROTECTED] 03/11/2004 11:55 AM To [EMAIL PROTECTED] cc Subject Win32::OLE 7 Excel Now Using Win32::OLE I could input Data into an Excel sheet using the perl docs by ActiveState

Re: Win32::OLE 7 Excel

2004-03-10 Thread Saadat Saeed
PROTECTED] 03/11/2004 11:55 AM To [EMAIL PROTECTED] cc Subject Win32::OLE 7 Excel Now Using Win32::OLE I could input Data into an Excel sheet using the perl docs by ActiveState. However now I also want to format Here is my code snippet $Range = $Sheet-Range(E1