Class: Axlsx::Workbook

Inherits:

Object

• Object
• Axlsx::Workbook

show all

Defined in:

lib/axlsx/workbook/workbook.rb

Overview

  bookViews
  calcPr
  customWorkbookViews
  definedNames
  externalReferences
  extLst
  fileRecoveryPr
  fileSharing
  fileVersion
  functionGroups
  oleSize
  pivotCaches
  smartTagPr
  smartTagTypes
  webPublishing
  webPublishObjects
  workbookProtection
  workbookPr*

  *workbookPr is only supported to the extend of date1904

Constant Summary

@@date1904 =

Indicates if the epoc date for serialization should be 1904. If false, 1900 is used.

false

Instance Attribute Summary (collapse)

• - (SimpleTypedList) charts readonly

  A colllection of charts associated with this workbook.

• - (SimpleTypedList) drawings readonly

  A colllection of drawings associated with this workbook.

• - (SimpleTypedList) images readonly

  A colllection of images associated with this workbook.

• - (Styles) styles readonly

  The styles associated with this workbook.

• - (SimpleTypedList) worksheets readonly

  A collection of worksheets associated with this workbook.

Class Method Summary (collapse)

• + (Boolean) date1904

  retrieves the date1904 attribute.

• + (Boolean) date1904=(v)

  Sets the date1904 attribute to the provided boolean.

Instance Method Summary (collapse)

• - (Worksheet) add_worksheet(options = {}) {|worksheet| ... }

  Adds a worksheet to this workbook.

• - (Boolean) date1904

  Instance level access to the class variable 1904.

• - (Object) date1904=(v)

  see @date1904.

• - (Workbook) initialize(options = {}) {|_self| ... } constructor

  Creates a new Workbook.

• - (Relationships) relationships

  The workbook relationships.

• - (String) to_xml

  Serializes the workbook document.

75
76
77
78
79
80
81
82
83

# File 'lib/axlsx/workbook/workbook.rb', line 75

def initialize(options={})
  @styles = Styles.new
  @worksheets = SimpleTypedList.new Worksheet
  @drawings = SimpleTypedList.new Drawing
  @charts = SimpleTypedList.new Chart
  @images = SimpleTypedList.new Pic
  self.date1904= options[:date1904] unless options[:date1904].nil?
  yield self if block_given?      
end

45
46
47

# File 'lib/axlsx/workbook/workbook.rb', line 45

def charts
  @charts
end

59
60
61

# File 'lib/axlsx/workbook/workbook.rb', line 59

def drawings
  @drawings
end

52
53
54

# File 'lib/axlsx/workbook/workbook.rb', line 52

def images
  @images
end

66
67
68

# File 'lib/axlsx/workbook/workbook.rb', line 66

def styles
  @styles
end

38
39
40

# File 'lib/axlsx/workbook/workbook.rb', line 38

def worksheets
  @worksheets
end

98

# File 'lib/axlsx/workbook/workbook.rb', line 98

def self.date1904() @@date1904; end

94

# File 'lib/axlsx/workbook/workbook.rb', line 94

def self.date1904=(v) Axlsx::validate_boolean v; @@date1904 = v end

104
105
106
107
108

# File 'lib/axlsx/workbook/workbook.rb', line 104

def add_worksheet(options={})
  worksheet = Worksheet.new(self, options)
  yield worksheet if block_given?
  worksheet
end

87

# File 'lib/axlsx/workbook/workbook.rb', line 87

def date1904() @@date1904; end

90

# File 'lib/axlsx/workbook/workbook.rb', line 90

def date1904=(v) Axlsx::validate_boolean v; @@date1904 = v end

112
113
114
115
116
117
118
119

# File 'lib/axlsx/workbook/workbook.rb', line 112

def relationships
  r = Relationships.new
  @worksheets.each do |sheet|
    r << Relationship.new(WORKSHEET_R, WORKSHEET_PN % (r.size+1))
  end 
  r << Relationship.new(STYLES_R,  STYLES_PN)
  r
end

123
124
125
126
127
128
129
130
131
132
133
134
135
136

# File 'lib/axlsx/workbook/workbook.rb', line 123

def to_xml()
  add_worksheet unless worksheets.size > 0
  builder = Nokogiri::XML::Builder.new(:encoding => ENCODING) do |xml|
    xml.workbook(:xmlns => XML_NS, :'xmlns:r' => XML_NS_R) {
      xml.workbookPr(:date1904=>@@date1904)
      xml.sheets {
        @worksheets.each_with_index do |sheet, index|              
          xml.sheet(:name=>sheet.name, :sheetId=>index+1, :"r:id"=>sheet.rId)
        end
      }
    }
  end      
  builder.to_xml(:indent=>0)
end