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: r...
Source: github.com