excel_utils
is a Python package designed to extract or edit data from a specific column in an Excel file.
To install the package using pip
:
pip install git+https://github.com/nando2003/excel_utils.git
from column_utils.get_column_data import get_column_data_from_excel
# Extract data from column 'A' starting from row 1 without row indices
data = get_column_data_from_excel('path/to/your/file.xlsx', row=1, column='A', index=False)
print(data)
# Extract data from column 'A' starting from row 1 with row indices
data_with_index = get_column_data_from_excel('path/to/your/file.xlsx', row=1, column='A', index=True)
print(data_with_index)