Set cell value and read it back : Excel « Windows Platform « Ruby

1.	ActiveRecord
2.	Array
3.	CGI
4.	Class
5.	Collections
6.	Database
7.	Date
8.	Design Patterns
9.	Development
10.	File Directory
11.	GUI
12.	Hash
13.	Language Basics
14.	Method
15.	Network
16.	Number
17.	Rails
18.	Range
19.	Reflection
20.	Statement
21.	String
22.	Threads
23.	Time
24.	Tk
25.	Unit Test
26.	Windows Platform
27.	XML

Ruby » Windows Platform » Excel

Set cell value and read it back





require 'win32ole' 



excel = WIN32OLE.new("excel.application") 

excel.Workbooks.Add 





excel.Range("a1").Value = 10 

excel.Range("a2").Value = 20 

excel.Range("a3").Value = "=a1+a2" 

excel.Range("a1:a3").each do |cell| 

    p cell.Value 

end

Related examples in the same category

1.	Using WIN32OLE with Excel
2.	Create a chart in Excel
3.	Create a chart and rotate it
4.	Add some more sheets

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.