Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re^3: spreadsheet::writeExcel Grouping/Outline

by runrig (Abbot)
on Sep 17, 2013 at 15:12 UTC ( #1054468=note: print w/replies, xml ) Need Help??

in reply to Re^2: spreadsheet::writeExcel Grouping/Outline
in thread spreadsheet::writeExcel Grouping/Outline

Any suggestions on any other perl lib which could run excel macros..
Win32::OLE perhaps...if you are running on Windows, and have Excel installed. But really, as you are creating a report, you should know which columns to group by, and which columns to subtotal. Even Excel asks you to confirm if it has guessed correctly when you hit the subtotal button. You could write a 'group by'/subtotal 'these' columns subroutine if you want to be generic about it. But then you would have to write the subtotal rows as you are writing the report, because the non-OLE library (AFAIK) cannot 'insert' rows between already written rows.
  • Comment on Re^3: spreadsheet::writeExcel Grouping/Outline

Replies are listed 'Best First'.
Re^4: spreadsheet::writeExcel Grouping/Outline
by omikirani (Initiate) on Sep 17, 2013 at 15:32 UTC
    I read about Win32::OLE, unfortunately I am on a UNIX box and that is when I had to ruled it out.. I was just trying save some of my coding time if there was something already built for a work-around. But I can absolutely do a similar thing while inserting rows to Excel..
    Thanks for looking.. :)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1054468]
[chacham]: i'm reading an article on and thee is a disturbing message on the bottom right that says, "Fork me on GitHub". Maybe i just have a dirty mind.
[choroba]: Check the ninja on
[chacham]: oh my...
[Corion]: choroba++ # fixed width
marto has a Dirty_Mind on vinyl
[Corion]: Heh. The upside of this phone call was at least commendations from my cow-orkers on how clam I stayed and how I always brought the topic back to my priorities and the established processes of $work (them only getting half of the conversation).

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (10)
As of 2017-08-17 13:04 GMT
Find Nodes?
    Voting Booth?
    Who is your favorite scientist and why?

    Results (287 votes). Check out past polls.