in reply to Re^8: Delete entire row without using Win32::OLE
in thread Delete entire row without using Win32::OLE

Note: At any instance I cannot open that excel manually. I want it as automated script.

Consider using a different exchange format between R and Perl, and write an Excel file as the final step from Perl.

I've no idea how powerful R is regarding writing output files, but writing CSV, JSON, or XML is easily done in most languages. Perl has modules on CPAN for reading all three formats, and can write old (*.xls) and new (*.xlsx) Excel formats, with using one of the spreadsheet writer modules.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
  • Comment on Re^9: Delete entire row without using Win32::OLE

Replies are listed 'Best First'.
Re^10: Delete entire row without using Win32::OLE
by ravi45722 (Pilgrim) on Sep 04, 2015 at 07:13 UTC

    Thanks for suggesting me this. But its a heavy script taking data from several servers and a lot of permissions needed. It's not possible now. If you want to go that way it will take my month away.

    Please suggest me some other ways that possible to read that R script created sheet in perl. Once again thanks for suggestion

[reply]

In Section Seekers of Perl Wisdom