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.

• - (Boolean) date1904

  Instance level access to the class variable 1904.

• - (SimpleTypedList) drawings readonly

  A colllection of drawings associated with this workbook.

• - (Relationships) relationships readonly

  The workbook relationships.

• - (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.

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

  Creates a new Workbook.

• - (String) to_xml

  Serializes the workbook document.

75
76
77
78
79
80
81
82

# 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
  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

67

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

def date1904() @@date1904; end

52
53
54

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

def drawings
  @drawings
end

63
64
65
66
67
68
69
70

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

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

59
60
61

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

def styles
  @styles
end

38
39
40

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

def worksheets
  @worksheets
end

93

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

def self.date1904() @@date1904; end

89

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

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

99
100
101
102
103

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

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

116
117
118
119
120
121
122
123
124
125
126
127
128
129

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

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