Using WIN32OLE with Excel : 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

Using WIN32OLE with Excel





require 'win32ole'



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



excelobj['Visible']=TRUE

excelobj.workbooks.add()





excelobj.Range("a6")['Value'] = 100





excelobj.Range("a1")['Value'] = 100

excelobj.Range("a2")['Value'] = 200

excelobj.Range("a3")['Value'] = 300

excelobj.Range("a4")['Value'] = 400

excelobj.Range("a1:a4").select()

Related examples in the same category

1.	Create a chart in Excel
2.	Create a chart and rotate it
3.	Set cell value and read it back
4.	Add some more sheets

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.