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.
Len Jaffe <[email protected]> wrote on 07/02/2012 12:23:32 PM: > From: > > Len Jaffe <[email protected]> > > To: > > The elegant MVC web framework <[email protected]> > > Date: > > 07/02/2012 12:29 PM > > Subject: > > Re: [Catalyst] Data export question > > > On Mon, Jul 2, 2012 at 1:11 PM, Kenneth S Mclane <[email protected]> wrote: > I need to export my data to an Excel file on demand. I have been > looking around and it looks like DBIx::Dumper should do it, but the > docs are a bit sparse. Has anyone done this with it or something > else? I need to have a link the user can click on which will dump > the current recordset in the stash into an Excel file and then > prompt for a save location. That's probably a separate function. > > > How complex will the spreadsheet be. > > You can do tricky things like dump a csv or tsv, but name it .xls > and excel will do the right thing in most cases. otherwise, I'd > look at Spreadsheet::WriteExcel. > > L > > -- > [email protected] 614-404-4214 www.volunteerable.net > Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage > Greenbar: 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/
_______________________________________________ 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/
