Revision history [back]

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,

Using roo gem to extract info for OpenStudio measure

require 'roo'   

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

Thank you,