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

Revision history [back]

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.