Supported file formats for spreadsheets are: .xlsx,.xlsm,.xltx,.xltm
# Import the library
from sheet2dict import Worksheet
# Create an object
ws = Worksheet()
# Convert
ws.xlsx to dict(path= inventory.xlsx )
# object.header returns first row with the data in a spreadsheet
print(ws.header)
# object.sheet items returns converted rows as dictionaries in the array
print(ws.sheet items)
You can parse data when worksheet is an object
# Import the library
from sheet2dict import Worksheet
# Example: read spreadsheet as object
path = inventory.xlsx
xlsx file = open(path, rb )
xlsx file = BytesIO(xlsx file.read())
# Parse spreadsheet from object