I know how to make a new dataframe and transfer it to a demo excel file and call it sheet1. I also know how to append new data into a current existing excel file.
What I want to know is how to modify a cell based on input from user and update the information to the existing cell in the excel file. Using the if statements seems like it works but does not update the excel file. I also want to know if there is an easier way around this besides using a lot of else if's. I only want to change one name at a time.
I'd appreciate any help I can get!