ruby对excel的一些操作

引用

require 'win32ole'

打开excel

excel13 = WIN32OLE.new("excel.application")
workbook13 = excel13.Workbooks.Open("F:/xls/2013.xls")

关闭

workbook13.close
excel13.quit

新建

excel = WIN32OLE.new("excel.application")
workbook_new = excel.workbooks.add()

新建sheet

sheet = workbook_new.Worksheets.Add()
sheet.Activate

设置sheet名称

sheet.name = sheetname

取sheet

sheet = workbook_new.Worksheets(1)
sheet = workbook_new.Worksheets("Sheet1")

取单元格A1的值

sheet13.range("A1").value

遍历sheet

workbook13.worksheets.each{|sheet13|

 # do sth

}