ravi45722 has asked for the wisdom of the Perl Monks concerning the following question:

I have an excel sheet created by 'R' script. In that some cells contains formulas. In this site some monk told that it is not possible to read that cell value through Perl parser until it(sheet generated by R) opens & saved manually. Is there any way to read that excel sheet in Perl. Or like in R can we create Data Frames in Perl by using any module ???

  • Comment on Problem with Reading the excel report generated by 'R' using Perl modules

Replies are listed 'Best First'.
Re: Problem with Reading the excel report generated by 'R' using Perl modules
by GotToBTru (Prior) on Mar 09, 2016 at 04:28 UTC

    Is the saved Excel spreadsheet in xls or xlsx format? That will determine which Perl module may be useful to you.

    See also Data::Frame and this thread. Super Search may also reveal other discussions on the subject of data frames or PDL.

    But God demonstrates His own love toward us, in that while we were yet sinners, Christ died for us. Romans 5:8 (NASB)
[reply]

      Its in xlsx.

[reply]

Back to Seekers of Perl Wisdom