Exoffice v0.3.2 Exoffice.Parser.Excel2007
Link to this section Summary
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
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]]
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
Example
iex> {:ok, pid} = Exoffice.Parser.Excel2007.parse_sheet(“./test/test_data/test.xlsx”, 1) iex> Enum.member?(:ets.all, pid) true