Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re^4: isn't numeric in substr error

by jmcnamara (Monsignor)
on Nov 19, 2010 at 13:12 UTC ( #872484=note: print w/replies, xml ) Need Help??

in reply to Re^3: isn't numeric in substr error
in thread isn't numeric in substr error

Can't call method "write" on an undefined value at /home/bsmart/excel_workbooks.ipl line 314.

This probably occurs because the worksheet object has already been garbage collected at that point in your program. Try adding an explicit Worksbook close() to synchronise the WriteExcel object destruction.

See the WriteExcel docs on Workbook::close() for more details.


Replies are listed 'Best First'.
Re^5: isn't numeric in substr error
by begood321 (Novice) on Nov 24, 2010 at 20:36 UTC

    Thanks John that could be the case. I have changed code from searching within spreadsheet to check for appriate value in variable, which appears to be easier. For now I'm good. Thanks guys for your help.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://872484]
[Corion]: Yay. Traditional finance situation averted. Bonds can be quoted in amounts (1_000_000 EUR) or per unit (1 unit). And a traditional error is to trade 2_000_000 piece when you meant to trade 2_000_000 EUR.
[Corion]: (one of my scripts simply catches high amounts and I phone people making that trade, ideally before the payment is due)

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (13)
As of 2017-03-29 11:29 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (347 votes). Check out past polls.