GitHub - Pytlicek/sheet2dict: Simple XLSX and CSV to dictionary converter
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...
Source: github.com