Example

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

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

Example

iex> {:ok, pid} = Exoffice.Parser.Excel2003.parse_sheet(“./test/test_data/test.xls”, 1) iex> Exoffice.Parser.Excel2003.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.Excel2003.parse_sheet(“./test/test_data/test.xls”, 1) iex> Exoffice.Parser.Excel2003.get_rows(pid) |> Enum.to_list [[23.0, 3.0, 12.0, 1.0, nil], [2.0, 12.0, 41.0, 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

Parse file test.xls in ./test/test_data:

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

Example

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