I have an Excel file with 40,000 rows of data. I would like to create a program in which reads the first column of the 40,000 lines and allows me to choose which row to edit.
After selecting the row to edit, I'd like a form to come up in which I enter my data, and then the .xls file is amended in the proper columns (for the given row) based on the data I put in.
Is this even possible? And what functions should I use to read the .xls file in Python??
Also, would this be easier using another programming language?