require 'win32ole'
require 'watir'
module WriteExcel
def write_data_excel
excel = WIN32OLE::new('excel.Application')
path = File.dirname(__FILE__)
data_source = File.join(path,'548183_add.xls')
workbook = excel.Workbooks.Open(data_source)
worksheet = workbook.Worksheets("excel的sheet頁面名字")
worksheet.Select #選擇操作excel的某個sheet頁面
character=worksheet.Range("a2")['Value']
character=character.split("-")
f=character[0]
b=character[1]
character=f.to_i+"-"+b.to_s
worksheet.Range("a2")['Value'] = character
#關閉文件
workbook.save
#結(jié)束對excel的操作
excel.Quit
end
end
本站僅提供存儲服務,所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權內(nèi)容,請
點擊舉報。