Using roo gem to extract info for OpenStudio measure
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,
roo
is not part of the list of pre-installed (well, embedded) gems that ships with the Openstudio CLI.thank you Julien, is there a way to include it ?