View Source 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 fileindex
is the sheet number to be read from the .xlsx file into theExplorer.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"]
>