On Mon, Jul 2, 2012 at 1:45 PM, Kenneth S Mclane <[email protected]>wrote:
> It will just be a dump of the current query results, possibly a whole
> table, so It will need to create new tabs when they reach 65K since most of
> my users are still on office 2003. I guess I could use
> Spreadsheet::WriteExcel, I just need to figure out the mechanics of getting
> the data into the sheetand something to keep track of the number of rows
> and create new tabs as needed.
>
>
# psuedocode
$ss = open_spreadsheet()
$i = 0;
$tab = undef;
foreach $row (@rows) {
if ($i % 65000 == 0) {
$tab = $ss.new_tab()
}
add_to_spreadsheet($row, $tab)
$i += 1
}
close_spreadsheet()
L.
--
[email protected] 614-404-4214 www.volunteerable.net
Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage
Greenbar <http://www.greenbartraining.org/>: Grubmaster: 2012-2009, Grub
Asst: 2008, Trained: 2007.
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
