No project description provided
Project description
pandasxl
pandasxl provides convenience functions for reading data from Excel files into a pandas DataFrame.
Installation
...
Usage
For example, to read a table from an Excel file into a DataFrame:
import openpyxl
import pandasxl as pdxl
wb = openpyxl.load_workbook('file.xlsx')
df = pdxl.read.from_name(wb, 'table_name')
API
Public API of the pandasxl
package.
Read
The read
module contains the core functions for reading data from Excel files.
read.from_name(wb: openpyxl.Workbook, name: str, header: bool) -> pd.DataFrame
Read an Excel named range or table into a DataFrame.
read.from_reference(wb: openpyxl.Workbook, ref: str) -> pd.DataFrame
Read an Excel range reference into a DataFrame.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pandasxl-0.1.0.tar.gz
(3.7 kB
view hashes)