study
Win32ole转载
上一篇 /
下一篇 2010-11-03 10:00:50
/ 个人分类:自动化测试
Win32ole为标准
Ruby发行版的一部分。Win32ole是访问
Windows自动化的接口,可以让Ruby和Windows应用进行交互。具体说来Win32ole可以操作Word,Excel,IE,Outlook等。
以下均为代码片段
Word
创建一个Word文件
- require 'win32ole'
- word = WIN32OLE.new('Word.Application')
- word.visible=true
- word.Documents.Add()
- for i in(0..100)
- word.Selection.Font.Size=12
- word.Selection.Font.ColorIndex = 2
- word.Selection.TypeText("Word with Ruby \n")
- end
- word.DefaultSaveFormat
- word.Documents.close()
Outlook
调用Outlook发送邮件
- require 'win32ole'
- outlook = WIN32OLE('Outlook.Application')
- message = outlook.CreateItem(0)
- message.Subject = 'Subject line here'
- message.Body = 'This is the body of your message.'
- message.To = 'xiaofan2350@yahoo.com.cn'
- message.Attachments.Add('c:\really\one.txt', 1)
- message.Send
Excel
创建一个Excel文件
- require 'win32ole'
- excel = WIN32OLE.new('Excel.Application')
- book = excel.workbooks.add
- sheets = book.worksheets(1)
- cells = sheets.cells("A1:A5")
- cells.each do |cell|
- cell.value = 10
- end
- require 'win32ole'
- excel = WIN32OLE.new("Excel.Application")
- excel.Visible = true
- excel.WorkBooks.Open("d:\\really.xls")
- worksheet = excel.ActiveWorkbook.WorkSheets(1)
-
- rows = worksheet.UsedRange.Rows
- worksheet.Range('A1:D1').value = ['North','South','East','West']
- worksheet.Range('A2')['value'] = "really"
- worksheet.Range('B2')['value'] = "notreally"
- worksheet.Range('C2')['value'] = "javaeye"
- worksheet.Range('D2')['value'] = "notreally.javaeye.com"
- excel.ActiveWorkbook.WorkSheets.add({'count'=>1, 'after'=>worksheet})
-
- excel.ActiveWorkbook.Close
- excel.Quit()
IE
创建一个ie浏览器的实例
- require "win32ole"
- ie = WIN32OLE.new('InternetExplorer.Application')
- ie.visible = true
- ie.navigate('http://www.ask123.net')
收藏
举报
TAG: