Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re: Re: writing with WriteExcel in OO style

by jmcnamara (Monsignor)
on Apr 09, 2002 at 07:45 UTC ( [id://157676]=note: print w/replies, xml ) Need Help??

in reply to Re: writing with WriteExcel in OO style
in thread writing with WriteExcel in OO style

The problem seems to be that you are using set_col() to set the format of cells that you have writing seperately.

Unfortunately, in the current implementation of the set_col() method doesn't work like this.

This is documented in the set_col() section of the documentation with the promise that it "will be fixed in a future release".

It will be fixed but in the meantime the best way to work around this is to store the column formats in a hash where the key is the column number. Then in your write_many() method use the appropriate column format if an explicit cell format isn't specified.


Update: This behaviour was fixed in version 0.37 of Spreadsheet::WriteExcel.

  • Comment on Re: Re: writing with WriteExcel in OO style

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://157676]
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2024-04-13 00:08 GMT
Find Nodes?
    Voting Booth?

    No recent polls found