cibien has asked for the wisdom of the Perl Monks concerning the following question:
Hi Monks, sorry for my precedent wrong question....
Is possible delete parsed data (with spreadsheet::parseexcel) from ram memory?
Because my a script parses a series of Excel files, and write data I need with XML::LibXML in a xml file. The logic works fine but my problem is that I keep running out of ram memory (4gb). I'm processing the files sequentially and I'm losing a lot of memory with parsing each new file. Now I have over 30 big excel files and after parsed 5 excel file the ram memory is full and process very slow. I need delete the parsed data stored in ram memory just before start parsing the second excel file, and the same for each excel file. Or I need alternative cell handling techniques that store only one excel file at once to limit memory usage..Thankyou very much for your help
Andrea
Back to
Seekers of Perl Wisdom