http://www.perlmonks.org?node_id=1018525


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 (Cardinal) 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!