Excel
Excel reader for Spark
Note
Ensure the 'excel' extra is installed before using this reader. Default implementation uses openpyxl as the engine for reading Excel files. Other implementations can be used by passing the correct keyword arguments to the reader.
See Also
- https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html
- koheesio.pandas.readers.excel.ExcelReader
koheesio.pandas.readers.excel.ExcelReader #
Read data from an Excel file
Attributes:
Name | Type | Description |
---|---|---|
path |
Union[str, Path]
|
The path to the Excel file |
sheet_name |
str
|
The name of the sheet to read |
header |
Optional[Union[int, List[int]]]
|
Row(s) to use as the column names |
Any other keyword arguments will be passed to pd.read_excel. |
|
header
class-attribute
instance-attribute
#
header: Optional[Union[int, List[int]]] = Field(
default=0,
description="Row(s) to use as the column names",
)