I sometimes read large spreadsheets with 100,000 lines, which can take 5-10 minutes or more, especially when our system slows down. I'd like to have an option, like SHOWROWSREAD, to show which row is being read while the code is executing inside the module's parse() routine. In this line:
my $wkbkin=$ssin->parse($xlsfnin);
the spreadsheet can take 5 minutes to read, so in that routine I'd like an option to see which line is being processed. The option can be a number, and when (CURROW mod SHOWROWSREAD) ==0 then display a message "Spreadsheet::ParseXLSX parse(): Row CURROW is being read".
I just need to know the parse() routine has not hung up as the customer can give us all kinds of funky data with hidden characters and stuff.
So if the SHOWROWSREAD option is 0, then do not show any message. If the SHOWROWSREAD option is 100, show a message after every 100 rows are read.
I sometimes read large spreadsheets with 100,000 lines, which can take 5-10 minutes or more, especially when our system slows down. I'd like to have an option, like SHOWROWSREAD, to show which row is being read while the code is executing inside the module's parse() routine. In this line:
my $wkbkin=$ssin->parse($xlsfnin);the spreadsheet can take 5 minutes to read, so in that routine I'd like an option to see which line is being processed. The option can be a number, and when (CURROW mod SHOWROWSREAD) ==0 then display a message "Spreadsheet::ParseXLSX parse(): Row CURROW is being read".
I just need to know the parse() routine has not hung up as the customer can give us all kinds of funky data with hidden characters and stuff.
So if the SHOWROWSREAD option is 0, then do not show any message. If the SHOWROWSREAD option is 100, show a message after every 100 rows are read.
Thanks!