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