Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Revision history [back]

If you're intent on using Excel (and Windows), you can use the win32ole class (included in the standard Ruby installation) to read and write data from a workbook.

E.g.: http://davidsulc.com/blog/2011/03/27/using-ruby-and-win32ole-to-manipulate-excel/

If you're intent on using Excel (and Windows), you can use the win32ole class (included in the standard Ruby installation) to read and write data from a workbook.

E.g.: http://davidsulc.com/blog/2011/03/27/using-ruby-and-win32ole-to-manipulate-excel/

Edit: Turns out the CLI doesn't include win32ole either.