class ExcelWps::WorkBook
Constants
- DisplayAlerts
- HorizontalAlignment
Public Class Methods
bold_style(sty)
click to toggle source
# File lib/excel_wps.rb, line 61 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/excel_wps.rb, line 5 def initialize(encoding = "utf-8") if OS.windows? require "win32ole" else print "只有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/excel_wps.rb, line 52 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/excel_wps.rb, line 71 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/excel_wps.rb, line 27 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/excel_wps.rb, line 90 def close @workbook.close @excel.quit end
create_style()
click to toggle source
# File lib/excel_wps.rb, line 41 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/excel_wps.rb, line 23 def display_alerts=(bool) @excel.DisplayAlerts = bool end
save(path)
click to toggle source
# File lib/excel_wps.rb, line 85 def save(path) path = Toolkit::String.safe_path(path) @workbook.saveas(path) end
show()
click to toggle source
# File lib/excel_wps.rb, line 81 def show @excel.visible = true end