Re: Win32::OLE and EXCEL

Replies are listed 'Best First'.
Re^2: Win32::OLE and EXCEL by dcutcher (Initiate) on Aug 08, 2005 at 16:41 UTC
Sorry, I mean column headings. I am trying to replicate the Excel feature under File, Page Setup, Sheet, Print Title, Rows to Repeat at Top. In Excel, if I enter $1:$2 in the Rows to Repeat at top, on each page I get row 1 and 2 as column headers.	[reply]
Re^3: Win32::OLE and EXCEL by marto (Cardinal) on Aug 08, 2005 at 17:42 UTC
Hi, Thanks for clearing that up. You can see from this example how to set up the column headings: `# Insert column titles my $Range = $Sheet->Range("A1:E1"); $Range->{Value} = [qw(Time Open High Low Close)]; $Range->Font->{Bold} = 1;` [download] Hope this helps. Martin	[reply] [d/l]