Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

Re: Global Variable for Worksheet?

by jmcnamara (Monsignor)
on Mar 21, 2012 at 15:55 UTC ( #960803=note: print w/replies, xml ) Need Help??

in reply to Global Variable for Worksheet?

moritz is correct about the object scope and destruction. You can force a manual destruction by calling the undocumented Spreadsheet::Write::close() method at the end of your program:

... $h->close();


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://960803]
[Corion]: ovedpo15: You could split on comma, and then join everything together, except the last part. Or you could match and make sure that the last part has no comma, like qr!,[^,]+$!, or you could use rindex.
[ovedpo15]: But I don't know the length of the string. will it still work?
[ovedpo15]: The only thing I know is that there is a comma at the end and a value after that
[hippo]: Try it and see. Your computer won't explode.
[Corion]: length will tell you the length of a string.
[Corion]: But if you are parsing CSV, again, let me point to Text::CSV_XS, which you should use instead
[hippo]: +1 for Text::CSV_XS
[ovedpo15]: Im not allowed to use additional modules, so I can't use it. looking for a simple regex to do this task though..

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (10)
As of 2018-05-27 10:39 GMT
Find Nodes?
    Voting Booth?