Does Spreadsheet::WriteExcel support grouping?

thor has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Does Spreadsheet::WriteExcel support grouping? by jmcnamara (Monsignor) on Apr 12, 2002 at 07:54 UTC
I could own this place if I could do that If it is worth owning I'm willing to write the code for a percentage of your stake. `;-)` Grouping isn't supported. -- John.	[reply]
Re: Re: Does Spreadsheet::WriteExcel support grouping? by thor (Priest) on May 21, 2002 at 15:23 UTC
Sorry it's taken so long to get back to this. Pressing projects and all. ;) Anyway, it turns out what I need for this to work is an interface to the fancy things that you can do with Subtotals from the Data menu. The SUBTOTAL function doesn't quite do what I want (the ability to subtotal at a change in a given column, subtotaling multiple columns at once, and the grovy ability to colapse a like group (which I think is Excel doing an automatic grouping ala the drive for the original post)). I'd like to be able to do this without `Win32:OLE`, as I am trying to do this on Solaris. Thanks	[reply] [d/l]
Re: Does Spreadsheet::WriteExcel support grouping? by jmcnamara (Monsignor) on Apr 25, 2003 at 09:23 UTC
(One year later) I hope you weren't holding your breath. `:-)` Grouping is now supported as of version 0.41 of Spreadsheet::WriteExcel. -- John.	[reply]
Re: Re: Does Spreadsheet::WriteExcel support grouping? by thor (Priest) on Apr 25, 2003 at 12:29 UTC
This is too freaky. Only yesterday did I start trying to bang out what I was trying to do (took our admins a long time to install the module). Of course, they installed v 0.40, so I appreciate the heads up. thanks, thor Update: Everything worked beautifully. The only snag that I've hit is that formulae have a limit of not being able to reference rows over 16384. I wonder what would happen if I changed that in Formula.pm...;)	[reply]
Re: Does Spreadsheet::WriteExcel support grouping? by strat (Canon) on Apr 12, 2002 at 14:26 UTC
I don't think so... I always do it with Win32::OLE. e.g. with `$sheets[$id]->Columns("E:G")->Columns->Group;` [download] Best regards, perl -le "s==F=e=>y~\martinF~stronat~=>s~[^\w]~~g=>chop,print"	[reply] [d/l]