in reply to Re: Does Spreadsheet::WriteExcel support grouping?
in thread Does Spreadsheet::WriteExcel support grouping?
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