Module: SysMODB::SpreadsheetExtractor
- Defined in:
- lib/sysmodb/simple-spreadsheet-extractor.rb
Overview
The mixin to allow you to extract from a spreadsheet file using
simple_spreadsheet_to_xml to extract to an xml format (see README and schema in doc/schema-v1.xsd)
simple_spreadhseet_to_csv to extract to CSV format for a single sheet
Instance Method Summary collapse
-
#spreadsheet_to_csv(spreadsheet_data, sheet = 1, trim = false, memory_allocation = DEFAULT_MEMORY_ALLOCATION) ⇒ Object
:call-seq: spreadsheet_to_csv(spreadsheet_data) -> String spreadsheet_to_csv(spreadsheet_data, sheet) -> String spreadsheet_to_csv(spreadsheet_data, sheet, trim) -> String spreadsheet_to_csv(spreadsheet_data, sheet, trim, memory_allocation) -> String.
-
#spreadsheet_to_xml(spreadsheet_data, memory_allocation = DEFAULT_MEMORY_ALLOCATION) ⇒ Object
:call-seq: spreadsheet_to_xml(spreadsheet_data) -> String spreadsheet_to_xml(spreadsheet_data, memory_allocation) -> String.
Instance Method Details
#spreadsheet_to_csv(spreadsheet_data, sheet = 1, trim = false, memory_allocation = DEFAULT_MEMORY_ALLOCATION) ⇒ Object
:call-seq:
spreadsheet_to_csv(spreadsheet_data) -> String
spreadsheet_to_csv(spreadsheet_data, sheet) -> String
spreadsheet_to_csv(spreadsheet_data, sheet, trim) -> String
spreadsheet_to_csv(spreadsheet_data, sheet, trim, memory_allocation) -> String
reads the incoming data from an IO object or path to a file and returns the generated CSV. only 1 sheet is processed, which by default it the first sheet. if trim is set to true, proceeding or trailing cells will be removed whilst keeping the csv uniform. it is extracted using java, and the default memory allocation is 512M (passed to -Xmx) this can be changed by passing an option final parameter memory_allocation
32 33 34 |
# File 'lib/sysmodb/simple-spreadsheet-extractor.rb', line 32 def spreadsheet_to_csv(spreadsheet_data, sheet = 1, trim = false, memory_allocation = DEFAULT_MEMORY_ALLOCATION) SysMODB::Extractor.new(memory_allocation).spreadsheet_to_csv(spreadsheet_data, sheet, trim) end |
#spreadsheet_to_xml(spreadsheet_data, memory_allocation = DEFAULT_MEMORY_ALLOCATION) ⇒ Object
:call-seq:
spreadsheet_to_xml(spreadsheet_data) -> String
spreadsheet_to_xml(spreadsheet_data, memory_allocation) -> String
reads the incoming data from an IO object or path to a file and returns the generated XML. it is extracted using java, and the default memory allocation is 512M (passed to -Xmx) this can be changed by passing an option final parameter memory_allocation
17 18 19 |
# File 'lib/sysmodb/simple-spreadsheet-extractor.rb', line 17 def spreadsheet_to_xml(spreadsheet_data, memory_allocation = DEFAULT_MEMORY_ALLOCATION) SysMODB::Extractor.new(memory_allocation).spreadsheet_to_xml(spreadsheet_data) end |