in reply to Re: problem using perl module Spreadsheet::WriteExcel cannot get data into rows when using for loop on a list to populate rows
in thread problem using perl module Spreadsheet::WriteExcel cannot get data into rows when using for loop on a list to populate rows
1) rowCounter is a global variable that keep track of what row I'm upto in the spreadsheet because the function is called multiple times to populate all data.
2) rowcounter isn't being replaced. J is just being used as a local counter whilst rowcounter keeps track globally.
3) All arrays are the same size and the first index is just "". Don't know howe to initialize a blank array, so I use "@array = ""; ". This just makes the first value "" and hence I start at index 1 instead of 0.
4) No I haven't used "use strict". It seems to output lots of errors like "requires explicit package name at ./XXXXXXXX.pl line XX". These don't seem to me like legitimate errors. I could be wrong :-)