Using roo gem to extract info for OpenStudio measure

asked 2020-09-22 08:20:59 -0600

Saif
626 ●1 ●7

updated 2020-09-22 11:02:14 -0600

I am trying to extract some information from excel file to use it in OpenStudio measure using roo gem. I tested the code as a standalone ruby file and it was working fine, but when I put it in OpenStudio measure I got this error message “cannot load such file -- roo”.I am not that savvy in programing so I am not sure if I am doing something wrong, also is there another way to extract information form excel file? Below a snip from the code I am trying to use

require 'roo'   

# open system input file
def Bldg.extract_bldg_hvac
    hvac_xlsx = Roo::Spreadsheet.open('./input_systems.xlsx')

Thank you,

edit retag flag offensive close merge delete

Comments

roo is not part of the list of pre-installed (well, embedded) gems that ships with the Openstudio CLI.

Julien Marrec ( 2020-09-22 09:07:44 -0600 )edit

thank you Julien, is there a way to include it ?

Saif ( 2020-09-22 09:27:19 -0600 )edit

add a comment

2 Answers

Sort by » oldest newest most voted

answered 2020-09-22 10:12:03 -0600

shorowit

11891 ●201 ●9 https://www.nrel.gov/b...

I would suggest saving the Excel file as a comma separated value file (CSV) or tab separated value file (TSV). You can then use the CSV class that ships with ruby to extract the information.

This will work perfectly with OpenStudio and does not require a new gem (roo, which requires nokogiri, a complex gem that must be compiled for anyone to use and is incompatible with OpenStudio), thus allowing your measure to more easily be used by others.

edit flag offensive delete link

add a comment

answered 2020-09-22 17:30:22 -0600

ericringold

10637 ●32 ●8 https://www.nrel.gov/b...

updated 2020-09-22 17:44:59 -0600

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/...

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