Output text to Excel


#1

I can’t find anything specific in the forums on this one.

I have built a model with about 30 different parts which are all labelled via “Text”. I can’t find anyway just to output the contexts of these text boxes into one simple list into say Excel?

Is it possible?

(The existing thread question “Copying Layer list to Excel” is not answered/resolved)


#3

You can extract the data using a simple Ruby snippet.
Select everything - the Text is filtered for.
The model needs to have a path set [i.e. it’s saved] as this is used to make the file.
Copy/paste this into the Ruby Console and press <enter>

m=Sketchup.active_model
s=m.selection.grep(Sketchup::Text)
a=[]
s.each{|e|a<<e.text}
a.sort!
p=m.path.gsub(/.skp$/,'_Text.csv')
f=File.open(p,'w')
a.each{|e|f.puts(e)}
f.close

A sorted list of the strings in all Text entities selected is written to a file with the model-name with “_Text.csv” appended to set its name.
A CSV file can be opened in Excel, and similar spreadsheet apps.
Alternatively set the file-type to be “.txt” and you can open that with any text-editor…