Class: AxlsxRad::Workbook

Inherits:
Object
  • Object
show all
Defined in:
lib/axlsx_rad/workbook.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(oAxlsx = nil) ⇒ Workbook

Returns a new instance of Workbook.



7
8
9
10
# File 'lib/axlsx_rad/workbook.rb', line 7

def initialize(oAxlsx=nil)
  @oAxlsx      = oAxlsx || Axlsx::Package.new
  @dWorksheets = {}
end

Instance Attribute Details

#oAxlsxObject

Returns the value of attribute oAxlsx.



5
6
7
# File 'lib/axlsx_rad/workbook.rb', line 5

def oAxlsx
  @oAxlsx
end

Instance Method Details

#addWorksheet(sWorksheetName = nil, oWsConfig = nil) ⇒ Object



12
13
14
15
16
17
18
19
# File 'lib/axlsx_rad/workbook.rb', line 12

def addWorksheet(sWorksheetName=nil,oWsConfig=nil)
  if @dWorksheets.has_key?(sWorksheetName)
    raise RuntimeError, "E_WORKSHEET_EXISTS [#{sWorksheetName}]"
  end
  oAwsWorksheet = AxlsxRad::Worksheet.new(@oAxlsx,sWorksheetName,oWsConfig)
  @dWorksheets[ sWorksheetName ] = oAwsWorksheet
  return oAwsWorksheet
end

#addWorksheetDocument(sWorksheetName = nil, oJsondoc = nil) ⇒ Object



21
22
23
24
25
26
27
28
# File 'lib/axlsx_rad/workbook.rb', line 21

def addWorksheetDocument(sWorksheetName=nil,oJsondoc=nil)
  if sWorksheetName.nil? || ! sWorksheetName.kind_of?(String)
    raise ArgumentError, 'E_BAD_WORKSHEET_NAME'
  elsif ! @dWorksheets.has_key?( sWorksheetName )
    raise ArgumentError, 'E_WORKSHEET_DOES_NOT_EXIST'
  end
  @dWorksheets[ sWorksheetName ].addDocument( oJsondoc )
end

#serialize(sPath = nil) ⇒ Object



30
31
32
# File 'lib/axlsx_rad/workbook.rb', line 30

def serialize(sPath=nil)
  @oAxlsx.serialize(sPath)
end