in reply to Does Spreadsheet::WriteExcel support grouping?


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.

  • Comment on Re: Does Spreadsheet::WriteExcel support grouping?

Replies are listed 'Best First'.
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]

In Section Seekers of Perl Wisdom