Re^5: Using variable files to add data into excel spreadsheet

Oh dear Lord, this is incredible!

Thanks so much poj, for taking the time to write this. This is exactly what I'm looking for!

With the risk of extracting the Michael...

...Any way of making the output to the spread sheet start at column 2 as the first columns in the spread sheet will already be accounted for? i.e

column 0 column 1   column 2  column 3  column 4

shop     area       apple     banana    orange
Aldi     Glasgow    1         2         5
Tesco    Edinburgh  5         6         3
Asda     London     3         1         7
[download]

Comment on Re^5: Using variable files to add data into excel spreadsheet Download Code

Replies are listed 'Best First'.
Re^6: Using variable files to add data into excel spreadsheet by poj (Abbot) on May 23, 2014 at 13:53 UTC
`# write column for each fruit for my $i (0..$#fruits){ my $col = $i+2; my $fruit = $fruits[$i]; .. etc` [download] poj	[reply] [d/l]