Linux OpenOffice automation

Is there simple way to automate Open Office from Ruby or Java Script on Linux? I need to open a开发者_开发知识库n xls file, edit some sheets/rows, and save it as new file.

---

You don't need openoffice. Use the ruby gem spreadsheet:

To install:

gem install spreadsheet

To use:

require 'spreadsheet'