My research team is building a website that requires the user to input an Excel file (.xlsx) with 6 different sheets. Each sheet has a different quantity of data. I understand that to create a file input button, you use the following format:
However, I’m not sure how to process the data inside of the Excel file the user inputs. We are using Python’s flask module as the web framework, so ideally, the contents of each sheet would be loaded into dictionaries on the flask file. I am not sure how to extract the data from each sheet of the file they input. Any help is appreciated. Thanks!
