write a really simple program in Python for analyzing data in Microsoft Excel
- Status: Closed
- Prize: $51
- Entries Received: 15
- Winner: omarelnahas500
Hi, I believe it is supposed to be a simple task. I would like to have a program in Python that can survey an excel spreadsheet tab, and find if a row meets certain criteria (e.g., in row 35, there're a non-zero value in column I and a non-zero value in column J), then the program outputs a phrase in a given column in that row (e.g., "to do" in column O row 35).
It should run fine on both Mac OS and Windows 10.
Thank you for your work! Please find the dummy excel file attached. As you may see, I preserved the workbook structure but deleted/changed the actual data. The program needs to edit the worksheet named “form 2”. The “original file.xlsx” is the file to start with, and the “result file.xlsx” is the file I would like to get.
In addition, here are some features of the file that I noticed, which may complicate the task. May I kindly request some modification of the program please?
1. The file is password protected. I set the password “1234”. May I have the python program to request me to input the password to enable the modification of the excel file when necessary?
2. Column J, which is the column needs to be output, is a date, and it equals to the entries at column I + 21 days.
3. The corresponding cell at column O needs to fill with “to do” if there is an date at column I.
Thank you so much for your work!