Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^3: Spreadsheet:Parse Excel problem

by dragonchild (Archbishop)
on Apr 14, 2008 at 13:51 UTC ( #680282=note: print w/replies, xml ) Need Help??


in reply to Re^2: Spreadsheet:Parse Excel problem
in thread Spreadsheet:Parse Excel problem

In other words, you have an Oracle error (ORA-01401: inserted value too large for column) and you want Spreadsheet::ParseExcel to fix it?

My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

Replies are listed 'Best First'.
Re^4: Spreadsheet:Parse Excel problem
by bmann (Priest) on Apr 14, 2008 at 23:37 UTC
    I don't think the OP wants Spreadsheet::ParseExcel to fix an oracle error.

    I see >19K of the text of a stack trace stored in one cell in his spreadsheet, not a problem with Oracle. It could just as easily be 19280 digits of pi.

      bman is right. I do not want to fix an oracle error. As far as I am concerned, someone just stored a blob of characters in an entry of the spreadsheet and this makes it unparseable by the module. It might as well have been the first N digits of pi of the first chapter of a Shakespeare book.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (4)
As of 2021-12-02 14:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    R or B?



    Results (22 votes). Check out past polls.

    Notices?