class Aio::Base::Toolkit::ExcelWps::WorkBook
Constants
- DisplayAlerts
- HorizontalAlignment
Public Class Methods
bold_style(sty)
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 64 def self.bold_style(sty) sty.font.size = 9 sty.font.bold = true sty.borders(7).linestyle = 1 sty.borders(8).linestyle = 1 sty.borders(9).linestyle = 1 sty.borders(10).linestyle = 1 sty.HorizontalAlignment = -4108 end
new(encoding = "utf-8")
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 8 def initialize(encoding = "utf-8") if Aio::Base::Toolkit::OS.windows? require "win32ole" else print_error "只有Windows系统才能使用Excel模块" exit 0 end @excel = WIN32OLE.new("excel.Application") @excel.visible = false @workbook = @excel.workbooks.add @encoding = encoding create_style end
normal_style(sty)
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 55 def self.normal_style(sty) sty.font.size = 9 sty.borders(7).linestyle = 1 sty.borders(8).linestyle = 1 sty.borders(9).linestyle = 1 sty.borders(10).linestyle = 1 sty.HorizontalAlignment = -4108 end
title_style(sty)
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 74 def self.title_style(sty) sty.font.size = 20 sty.font.bold = true sty.borders(7).linestyle = 1 sty.borders(8).linestyle = 1 sty.borders(9).linestyle = 1 sty.borders(10).linestyle = 1 sty.HorizontalAlignment = -4108 end
Public Instance Methods
add_worksheet(name)
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 30 def add_worksheet(name) while @@worksheets_name.include?(name) name += "1" end @@worksheets_name << name worksheet = @workbook.worksheets.add worksheet.activate # 在同一进程中多次打开会出现name的问题, 所以干脆全部使用sheet # worksheet.name = name worksheet.name = "sheet" return WorkSheet.new(worksheet) end
close()
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 92 def close @workbook.close @excel.quit end
create_style()
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 44 def create_style sty = @workbook.styles.add("NormalStyle") self.class.normal_style(sty) sty = @workbook.styles.add("BoldStyle") self.class.bold_style(sty) sty = @workbook.styles.add("TitleStyle") self.class.title_style(sty) end
display_alerts=(bool)
click to toggle source
警告提示开关
# File lib/aio/base/toolkit/excel_wps.rb, line 26 def display_alerts=(bool) @excel.DisplayAlerts = bool end
save(path)
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 88 def save(path) @workbook.saveas(path) end
show()
click to toggle source
# File lib/aio/base/toolkit/excel_wps.rb, line 84 def show @excel.visible = true end