Module: Writexlsx::Worksheet::CellDataManager

Included in:
Writexlsx::Worksheet
Defined in:
lib/write_xlsx/worksheet/cell_data_manager.rb

Instance Method Summary collapse

Instance Method Details

#get_range_data(row_start, col_start, row_end, col_end) ⇒ Object

Returns a range of data from the worksheet cell table to be used in chart cached data. Strings are returned as SST ids and decoded in the workbook. Return nils for data that doesn’t exist since Excel can chart series with data missing.



36
37
38
 
# File 'lib/write_xlsx/worksheet/cell_data_manager.rb', line 36

def get_range_data(row_start, col_start, row_end, col_end)
  @cell_data_store.get_range_data(row_start, col_start, row_end, col_end)
end

#shared_string_index(str) ⇒ Object

Add a string to the shared string table, if it isn’t already there, and return the string index.



26
27
28
 
# File 'lib/write_xlsx/worksheet/cell_data_manager.rb', line 26

def shared_string_index(str) # :nodoc:
  @workbook.shared_string_index(str)
end

#store_data_to_table(cell_data, row, col) ⇒ Object

Store a CellData object in the worksheet cell table.



10
11
12
 
# File 'lib/write_xlsx/worksheet/cell_data_manager.rb', line 10

def store_data_to_table(cell_data, row, col) # :nodoc:
  @cell_data_store.store(cell_data, row, col)
end

#store_row_col_max_min_values(row, col) ⇒ Object

Track row/col min/max used for range calculation.



17
18
19
20
 
# File 'lib/write_xlsx/worksheet/cell_data_manager.rb', line 17

def store_row_col_max_min_values(row, col)
  store_row_max_min_values(row)
  store_col_max_min_values(col)
end