<font size=2 face="sans-serif">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. </font>
<br>
<br><tt><font size=2>Len Jaffe <lenjaffe@jaffesystems.com> wrote
on 07/02/2012 12:23:32 PM:<br>
<br>
> From:</font></tt>
<br><tt><font size=2>> <br>
> Len Jaffe <lenjaffe@jaffesystems.com></font></tt>
<br><tt><font size=2>> <br>
> To:</font></tt>
<br><tt><font size=2>> <br>
> The elegant MVC web framework <catalyst@lists.scsys.co.uk></font></tt>
<br><tt><font size=2>> <br>
> Date:</font></tt>
<br><tt><font size=2>> <br>
> 07/02/2012 12:29 PM</font></tt>
<br><tt><font size=2>> <br>
> Subject:</font></tt>
<br><tt><font size=2>> <br>
> Re: [Catalyst] Data export question</font></tt>
<br><tt><font size=2>> <br>
> <br>
</font></tt>
<br><tt><font size=2>> On Mon, Jul 2, 2012 at 1:11 PM, Kenneth S Mclane
<ksmclane@us.ibm.com> wrote:</font></tt>
<br><tt><font size=2>> I need to export my data to an Excel file on
demand. I have been <br>
> looking around and it looks like DBIx::Dumper should do it, but the
<br>
> docs are a bit sparse. Has anyone done this with it or something <br>
> else? I need to have a link the user can click on which will dump
<br>
> the current recordset in the stash into an Excel file and then <br>
> prompt for a save location. That's probably a separate function. <br>
> </font></tt>
<br><tt><font size=2>> <br>
> How complex will the spreadsheet be. </font></tt>
<br><tt><font size=2>> <br>
> You can do tricky things like dump a csv or tsv, but name it .xls
<br>
> and excel will do the right thing in most cases. otherwise,
I'd <br>
> look at Spreadsheet::WriteExcel.</font></tt>
<br><tt><font size=2>> <br>
> L</font></tt>
<br><tt><font size=2>> <br>
> -- <br>
> lenjaffe@jaffesystems.com 614-404-4214
</font></tt><a href=www.volunteerable.net><tt><font size=2>www.volunteerable.net</font></tt></a>
<br><tt><font size=2>> Proprietor: </font></tt><a href=http://www.theycomewithcheese.com/><tt><font size=2>http://www.theycomewithcheese.com/</font></tt></a><tt><font size=2>
- An Homage to Fromage</font></tt>
<br><tt><font size=2>> Greenbar: Grubmaster: 2012-2009, Grub
Asst: 2008, Trained: 2007.</font></tt>
<br><tt><font size=2>> <br>
> _______________________________________________<br>
> List: Catalyst@lists.scsys.co.uk<br>
> Listinfo: </font></tt><a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst"><tt><font size=2>http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</font></tt></a><tt><font size=2><br>
> Searchable archive: </font></tt><a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/"><tt><font size=2>http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</font></tt></a><tt><font size=2><br>
> Dev site: </font></tt><a href=http://dev.catalyst.perl.org/><tt><font size=2>http://dev.catalyst.perl.org/</font></tt></a><tt><font size=2><br>
</font></tt>