in reply to Need help in reading csv files >1GB for converting into xlsx files in Solaris 10 - Perl v-5.8.4

See if adding $workbook->set_optimization(); helps.

With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority". I'm with torvalds on this
In the absence of evidence, opinion is indistinguishable from prejudice. Agile (and TDD) debunked
  • Comment on Re: Need help in reading csv files >1GB for converting into xlsx files in Solaris 10 - Perl v-5.8.4
  • Download Code

Replies are listed 'Best First'.
Re^2: Need help in reading csv files >1GB for converting into xlsx files in Solaris 10 - Perl v-5.8.4
by GT Learner (Initiate) on Feb 12, 2015 at 05:43 UTC

    it didnt work :( I've tried it !! but getting an error like

     "Undefined subroutine &main::set_optimization called at program line number".
[reply]
[d/l]

      Oh well....

      With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
      Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
      "Science is about questioning the status quo. Questioning authority". I'm with torvalds on this
      In the absence of evidence, opinion is indistinguishable from prejudice. Agile (and TDD) debunked
[reply]
      You need to upgrade Excel::Writer::XLSX to a version that supports set_optimization().
[reply]

In Section Seekers of Perl Wisdom