[Catalyst] Data export question

Len Jaffe lenjaffe at jaffesystems.com
Mon Jul 2 18:54:28 GMT 2012

On Mon, Jul 2, 2012 at 1:45 PM, Kenneth S Mclane <ksmclane at us.ibm.com>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 =
> my users are still on office 2003. I guess I could use
> Spreadsheet::WriteExcel, I just need to figure out the mechanics of getti=
> the data into the sheetand something to keep track of the number of rows
> and create new tabs as needed.
# psuedocode

$ss =3D open_spreadsheet()
$i =3D 0;
$tab =3D undef;
foreach $row (@rows) {
  if ($i % 65000 =3D=3D 0) {
    $tab =3D $ss.new_tab()
  add_to_spreadsheet($row, $tab)
  $i +=3D 1

-- =

lenjaffe at jaffesystems.com   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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20120702/9f736=

More information about the Catalyst mailing list