#Xlsxplorer

Xlsxplorer. Load data from your .xlsx file into an Explorer.DataFrame.

Uses Xlsxir to parse data from an .xlsx file, which is loaded into an Explorer.DataFrame

#Installation

The package can be installed by adding xlsxplorer to your list of dependencies in mix.exs:

def deps do
  [
    {:xlsxplorer, "~> 0.1.0"}
  ]
end

Documentation generated with ExDoc. The docs can be found at https://hexdocs.pm/xlsxplorer.

#Usage

Provides a single function from_xlsx/2 wich loads data from a .xlsx file into an Explorer.DataFrame

• path is a string with the path to the .xlsx file
• index is the sheet number to be read from the .xlsx file into the Explorer.DataFrame.

#Example

iex(1)> Xlsxplorer.from_xlsx("./test/data/example.xlsx", 0)
#Explorer.DataFrame<
Polars[2 x 2]
number integer [1, 2]
string string ["hello", "world"]
>