Class: XlsxWriter::Sheet

Inherits:
Xml
  • Object
show all
Defined in:
lib/xlsx_writer/generators/sheet.rb

Constant Summary collapse

AUTO = 
false

Instance Attribute Summary collapse

Attributes inherited from Xml

#document

Class Method Summary collapse

Instance Method Summary collapse

Methods inherited from Xml

#generate, #generated?, #render, #template_path

Constructor Details

#initialize(document, name) ⇒ Sheet

Returns a new instance of Sheet.



21
22
23
24
25
26
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 21

def initialize(document, name)
  @name = Sheet.excel_name name
  @rows = []
  @autofilters = []
  super document
end

Instance Attribute Details

#autofilters ⇒ Object (readonly)

Returns the value of attribute autofilters.



19
20
21
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 19

def autofilters
  @autofilters
end

#name ⇒ Object (readonly)

Returns the value of attribute name.



17
18
19
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 17

def name
  @name
end

#rows ⇒ Object (readonly)

Returns the value of attribute rows.



18
19
20
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 18

def rows
  @rows
end

Class Method Details

.excel_name(value) ⇒ Object 



6
7
8
9
10
11
12
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 6

def excel_name(value)
  str = value.to_s.dup
  str.gsub! '/', ''   # remove forward slashes
  str.gsub! /\s+/, '' # compress "inner" whitespace
  str.strip!          # trim whitespace from ends
  str.fast_xs
end

Instance Method Details

#absolute_path ⇒ Object 



45
46
47
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 45

def absolute_path
  "/#{relative_path}"
end

#add_autofilter(range) ⇒ Object

specify range like “A1:C1”

Raises:

  • (::RuntimeError) 


50
51
52
53
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 50

def add_autofilter(range)
  raise ::RuntimeError, "Can't add autofilter, already generated!" if generated?
  autofilters << Autofilter.new(self, range)
end

#add_row(data) ⇒ Object

Raises:

  • (::RuntimeError) 


55
56
57
58
59
60
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 55

def add_row(data)
  raise ::RuntimeError, "Can't add row, already generated!" if generated?
  row = Row.new self, data
  rows << row
  row
end

#local_id ⇒ Object 



32
33
34
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 32

def local_id
  ndx - 1
end

#ndx ⇒ Object 



28
29
30
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 28

def ndx
  document.sheets.index(self) + 1
end

#path ⇒ Object

override Xml method to save memory



63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 63

def path
  @path || @mutex.synchronize do
    @path ||= begin
      memo = ::File.join document.staging_dir, relative_path
      ::FileUtils.mkdir_p ::File.dirname(memo)
      ::File.open(memo, 'wb') do |f|
        to_file f
      end
      converted = UnixUtils.unix2dos memo
      ::FileUtils.mv converted, memo
      SheetRels.new(document, self).path
      @generated = true
      memo
    end
  end
end

#relative_path ⇒ Object 



41
42
43
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 41

def relative_path
  "xl/worksheets/sheet#{ndx}.xml"
end

#rid ⇒ Object

+1 because styles.xml occupies the first spot



37
38
39
 
# File 'lib/xlsx_writer/generators/sheet.rb', line 37

def rid
  "rId#{ndx + 1}"
end