Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

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 a log crumbles through the grate...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2018-07-20 18:46 GMT
Find Nodes?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?

    Results (439 votes). Check out past polls.