Xlsxir v1.6.4 Xlsxir.ParseWorksheet View Source

Holds the SAX event instructions for parsing worksheet data via Xlsxir.SaxParser.parse/2

Link to this section Summary

Functions

Sax event utilized by Xlsxir.SaxParser.parse/2. Takes a pattern and the current state of a struct and recursivly parses the worksheet XML file, ultimately saving a list of cell references and their assocated values to the ETS process

Link to this section Functions

Link to this function

sax_event_handler(arg1, state, excel, xml_name) View Source

Sax event utilized by Xlsxir.SaxParser.parse/2. Takes a pattern and the current state of a struct and recursivly parses the worksheet XML file, ultimately saving a list of cell references and their assocated values to the ETS process.

Parameters

  • arg1 - the XML pattern of the event to match upon
  • state - the state of the %Xlsxir.ParseWorksheet{} struct which temporarily holds applicable data of the current row being parsed

Example

Each entry in the list created consists of a list containing a cell reference string and the associated value (i.e. [["A1", "string one"], ...]).