.xls is the old binary proprietary Microsoft format.
Nowadays most are using the newer XML text format
… does your web application take these XML spreadsheets ?
Ruby has a standard library (
REXML) to read and write XML files:
Can it take CSV table files ?
SketchUp Pro’s Generate Report can export comma separate values files, which can also be imported to LayOut as tables.
Ruby has a standard library class (
CSV) that can read and write CSV files:
You have two options in Sketchup:
Attach custom attributes in dictionary collections to the various geometry groups and components in the model.
Use SketchUp’s classification system (which uses it’s special attribute dictionaries) and IFC attribute schema. These could be exported. Generate Report may or may not “see” these attributes. (Cannot remember offhand.)
I’ve answered the Ruby API above.
For the SketchUp SDK you might need to seek out third party C libraries to read and write CSV, XLS or XLSX (XML) files. The SDK has some examples of writing out to an XML file.
However, currently the SDK is standalone for reading and writing directly to SKP files. It is not easliy hooked into the “live” SketchUp application process.