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