Exoffice v0.3.2 Exoffice.Parser.Excel2007

Link to this section Summary

Functions

Example

Example

Returns a list of supported extensions by parser

Example

Link to this section Functions

Example

iex> [{:ok, pid1}, {:ok, pid2}] = Exoffice.Parser.Excel2007.parse(“./test/test_data/test.xlsx”) iex> Enum.member?(:ets.all, pid1) && Enum.member?(:ets.all, pid2) true

iex> [{:ok, pid1}, {:ok, pid2}] = Exoffice.Parser.Excel2007.parse(“./test/test_data/test.xlsx”) iex> Exoffice.Parser.Excel2007.close(pid1) iex> Exoffice.Parser.Excel2007.close(pid2) iex> Enum.member?(:ets.all, pid1) || Enum.member?(:ets.all, pid2) false

Link to this function count_rows(pid)

Example

iex> {:ok, pid} = Exoffice.Parser.Excel2007.parse_sheet(“./test/test_data/test.xlsx”, 1) iex> Exoffice.Parser.Excel2007.count_rows(pid) 10

Returns a list of supported extensions by parser

Callback implementation for Exoffice.Parser.extensions/0.

Example

iex> {:ok, pid} = Exoffice.Parser.Excel2007.parse_sheet(“./test/test_data/test.xlsx”, 1) iex> Exoffice.Parser.Excel2007.get_rows(pid) |> Enum.to_list [[23, 3, 12, 1, nil], [2, 12, 41, nil, nil], [nil, nil, nil, nil, nil], [nil, nil, nil, nil, nil], [nil, nil, nil, nil, nil], [nil, nil, nil, nil, nil], [nil, nil, nil, nil, nil], [nil, nil, nil, nil, nil], [nil, nil, nil, nil, nil], [nil, nil, nil, nil, nil]]

Link to this function parse(path, options \\ [])

Example

iex> [{:ok, pid1}, {:ok, pid2}] = Exoffice.Parser.Excel2007.parse(“./test/test_data/test.xlsx”) iex> Enum.member?(:ets.all, pid1) && Enum.member?(:ets.all, pid2) true

Link to this function parse_sheet(path, index, options \\ [])

Example

iex> {:ok, pid} = Exoffice.Parser.Excel2007.parse_sheet(“./test/test_data/test.xlsx”, 1) iex> Enum.member?(:ets.all, pid) true