3 messages in com.googlegroups.sketchuprubyabout excel and sketchup
FromSent OnAttachments
fufu16 May 2008 09:26 
fufu16 May 2008 09:36 
catamountain17 May 2008 20:07 
Subject:about excel and sketchup
From:fufu (ifev@gmail.com)
Date:05/16/2008 09:36:15 AM
List:com.googlegroups.sketchupruby

I saw plug-in sketchup. file name is excelchart.rb. In Below # -4100 is the value for the Excel constant xl3DColumn. ChartTypeVal = -4100; # Creates OLE object to Excel excel = WIN32OLE.new("excel.application") # Create and rotate the chart excel['Visible'] = TRUE; workbook = cost.Workbooks.Add(); excel.Range("a1")['Value'] = 200; excel.Range("a2")['Value'] = 300; excel.Range("a3")['Value'] = 100; excel.Range("a1:a3").Select(); excelchart = workbook.Charts.Add(); excelchart['Type'] = ChartTypeVal; 30.step(180, 10) do |rot| excelchart['Rotation'] = rot end excelchart2 = workbook.Charts.Add(); excelchart3 = workbook.Charts.Add(); charts = workbook.Charts charts.each { |i| puts i }

this file export value to open new excel workbook file.