write a really simple program in Python for analyzing data in Microsoft Excel

  • Status: Closed
  • Prize: $51
  • Entries Received: 15
  • Winner: omarelnahas500

Contest Brief

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.
Thanks!

UPDATE:

Hello!

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!

Recommended Skills

Public Clarification Board

  • sohelq
    sohelq
    • 2 weeks ago

    #extend

    • 2 weeks ago
  • likith1337
    likith1337
    • 2 weeks ago

    Also tested on both Mac and Windows, it was working

    • 2 weeks ago
  • likith1337
    likith1337
    • 2 weeks ago

    Also password feature was added

    • 2 weeks ago
  • likith1337
    likith1337
    • 2 weeks ago

    I completed all the code :(

    • 2 weeks ago
  • likith1337
    likith1337
    • 2 weeks ago

    Why can't I participate?

    • 2 weeks ago
  • AVKor
    AVKor
    • 2 weeks ago

    Hello, the contest holder. Please #extended your contest. I was slightly late to upload my work, it is very close to be completed. My script has a few very good features, you will not be disappointed after looking on my work even if you decide to award another freelancer. Thank you.

    • 2 weeks ago
  • nahidhassan21
    nahidhassan21
    • 2 weeks ago

    Hello, the contest holder. Please check entry #19 . I have submitted three files that fully meet your requirements. If you need further features I can help you to develop that. I am using the "Pandas" package that is so faster for this kind of task, and it can also handle very big files.

    • 2 weeks ago
  • sashakuprii
    sashakuprii
    • 2 weeks ago

    Hello, Contest holder. I have just submitted entry #21 that fully meets your requirements. Hope you like it. I can continue working on this task after the contest if you have other features to be developed.

    • 2 weeks ago
  • GrafixImage
    GrafixImage
    • 2 weeks ago

    Dear Contest holder, Pls check Entry #20 . We have Updated our Python program as per your Requirements, Thankyou

    • 2 weeks ago
  • omarelnahas500
    omarelnahas500
    • 2 weeks ago

    Hi, please see entry #14 I have done all the requirements you specified

    • 2 weeks ago
  • Julianonn
    Julianonn
    • 3 weeks ago

    Hello contest holder, could you give us an example file? I know different python libraries that can solve your problem easily, but ir depends on the format inside your excel file. I know it is easy to solve it, but with more information i can make something unique for your problem.

    • 3 weeks ago
    1. Julianonn
      Julianonn
      • 2 weeks ago

      Running in MAC and Windows is possible because python can be installed on both.

      • 2 weeks ago
  • GrafixImage
    GrafixImage
    • 3 weeks ago

    Dear Contest holder, Pls check Entry #9 . Hope you will definitely like this! . Awaiting for your Review, Thankyou

    • 3 weeks ago
  • sohelq
    sohelq
    • 3 weeks ago

    I can do the same program which I have submitted, if you can provide your data it can be dummy data too

    • 3 weeks ago
  • sohelq
    sohelq
    • 3 weeks ago

    Hello, I will provide the code for the program and if you desire any other changes, please contact me.

    • 3 weeks ago
  • ashikmohann
    ashikmohann
    • 3 weeks ago

    hi
    i can work for you in pandas. please contact with a sample file

    • 3 weeks ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!