Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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


Comment on Re^4: ParseExcel Again
Re^5: ParseExcel Again
by marto (Chancellor) 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 (Bishop) 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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (14)
As of 2014-08-22 16:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (160 votes), past polls