Re^9: Delete entire row without using Win32::OLE

I'm surprised you get any values at all, on my R generated test xlsx I get Can't call method "contents" on an undefined value. In theory I guess you could calculate the expression =SUMIF($C$14:$AH$14,"SubScore",C15:AH15) yourself in your perl script. In practice that depends on how fixed your columns and the formulas in them are likely to be.

poj

Comment on Re^9: Delete entire row without using Win32::OLE Select or Download Code

Replies are listed 'Best First'.
Re^10: Delete entire row without using Win32::OLE by ravi45722 (Pilgrim) on Sep 04, 2015 at 07:08 UTC
I am getting the values which cell does not contains formulae. As you said I am trying to open my excel and save it through perl. Through `libreoffice --calc test.xlsx` we can open the file. But I dont know how to save. After saving we can kill the process through pid. I dont know that it is correct way or not. Tell me if you know how to save .xlsx through command line	[reply]