Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re^4: ParseExcel Again

by Anonymous Monk
on Feb 13, 2013 at 11:36 UTC ( #1018525=note: print w/replies, xml ) Need Help??

in reply to Re^3: ParseExcel Again
in thread ParseExcel Again

CSV is not an option. The module has so many dependecies that speeding it up or identifying functions which i dont require is very difficult

Replies are listed 'Best First'.
Re^5: ParseExcel Again
by marto (Archbishop) on Feb 13, 2013 at 11:46 UTC

    "speeding it up or identifying functions which i dont require is very difficult"

    Consider profiling your code. Devel::NYTProf, this includes documentation/screen casts explaining how to use the module to locate problems and areas for optimization. See also Debugging and Optimization. Alternatively, invest in a system with more RAM, faster disks (SSD) and a better CPU.

Re^5: ParseExcel Again
by ww (Archbishop) on Feb 13, 2013 at 12:09 UTC

    I suspect that what tmharish was suggesting was that you save your problematic spreadsheet as CSV or TSV (doing so uses an excel function so no new dependancies there) and then use a CSV module -- such as Parse-CSV 2.00 -- to extract the data you're looking for.

    If you didn't program your executable by toggling in binary, it wasn't really programming!

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2018-10-17 05:05 GMT
Find Nodes?
    Voting Booth?
    When I need money for a bigger acquisition, I usually ...

    Results (90 votes). Check out past polls.