RE: Excel stuff.

2003-11-20 Thread work
> Hi Nathaniel, > > Thanks for that, it's very helpful. I'm now trying to switch from > Spreadsheet::WriteExcel, to Win32::OLE. > > The biggest problem I seem to have now is translating this command: > > my $temp = [EMAIL PROTECTED]; > $page}->write_row($row, 5, $temp); > > Can you help? I don't k

RE: Excel stuff.

2003-11-20 Thread work
> Nathaniel, > > I also use the OLE and I think you showed me how to freeze panes long > ago. Anyways, the problem that I ran into using that command was: If the > pane has already been frozen when you execute the same command, you get > fatal error. So, do you know of a way to wrap a test around t

RE: Excel stuff.

2003-11-20 Thread Ross Matt-QMR000
: Re: Excel stuff. > Currently I'm using Spreadsheet::WriteExcel. > > I am trying to work out how to do the following... > > 1. Merge cells. > 2. Make all columns AutoFit, after the data has been entered. > 3. Freeze panes. I don't use Spreadsheet::WriteExcel but if y

Re: Excel stuff.

2003-11-20 Thread work
> Currently I'm using Spreadsheet::WriteExcel. > > I am trying to work out how to do the following... > > 1. Merge cells. > 2. Make all columns AutoFit, after the data has been entered. > 3. Freeze panes. I don't use Spreadsheet::WriteExcel but if you can use Win32::OLE then this should help. use