引用
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
workbook13.worksheets.each{|sheet13|
# do sth
}