lua操作excel-尊龙凯时

require 'luacom'
local excel = luacom.createobject('excel.application')
excel.visible = true
local book = excel.workbooks:add()
local sheet = book.worksheets(1)
sheet.name = 'gty'
local range = sheet:range('a1:a10')
local cell = sheet.cells(1,1)
sheet:range('d3:d6'):merge()--合并单元格
range.value2 = 1
range.font.size = 20
sheet.cells(1,2).formular1c1 = '=r3c1 r4c1'	--公式
cell.value2 = 'gty'
cell.font.name = 'arial'
--cell.font.fontstyle = 'bold'
cell.font.bold = true
sheet.cells(4,5).entirerow.interior.color = 0x334455	--整行操作
sheet.cells(4,5).entirecolumn.interior.color = 0x998877	--整列操作
cell.font.size = 20
cell.font.color = 0x0000ff
cell.font.underline = true
cell.font.strikethrough = true	--删除线
cell.font.outlinefont = true	--下划线
range.interior.color = 0x778899	--区域上色
range.borders.linestyle = 1		--边框样式 --每个小的内边框
sheet:range('c2:g7').borderaround(1)--外边框
--range.borders.weight = 4		--边框宽度
--range.interior.pattern = 8	--区域花纹
--cell.font.shadow = true
--cell.font.superscript = true
--cell.font.subscript = true
print(range.cells.count)	--统计单元格数
print(range.rows.count)
print(range.columns.count)
range.numberformat = '$#,##0.00'	--格式化数字
sheet:range('a2'):cut()		--剪切
sheet:range('a3'):copy()	--复制
sheet:paste(sheet:range('b3')) --粘贴
book.worksheets('sheet3'):delete()
book:saveas(filepath,51)--51xlsx -4143xls
excel:quit()