Python Automation Project
Budget: $30 – $250 USD
Looking for a Python Developer to develop the following
1- Develop an automation script to open a WORD DOCUMENT (check attached word document template) and modify the word document based and create spelling/grammatical mistakes based on excel file.
2- After the mistakes are created in the word document file, the script should create a folder with Excel Column 1 name and save the modified file as a PDF inside it accordingly.
3- After the file is saved, then the files should be email seperately to the email found in Column 1.
Example: After completion of Step #2 (Save modified files in a folder name with the email address found in Column 1, the script should send an email with PDF attachment to the email address found in Column 1 and attach the related file.
4- After completion, the excel file should track "COMPLETED" in Column 8.
Notes:
- Excel file will display 5 columns (5 mistakes) under each column theres a number of where the mistake should be located. The script have to take into consideration (spaces and punctations and numbers).
- Incase there is a space, punctation or number then the script should take the letter before or after.
(Example: "Hi, this is me.") -> In this case, if Mistake 1 == 3, then 3 is a COMMA, and 4 is a SPACE, then the script can take letter NUMBER 5 or NUMBER 2.
- Mistakes should take place in the body of the Word Document file after the seperator line (highlighted in red)
- To take into consideration, if the template consist of the pages, then the header and the side bar will be repeated.
1- Develop an automation script to open a WORD DOCUMENT (check attached word document template) and modify the word document based and create spelling/grammatical mistakes based on excel file.
2- After the mistakes are created in the word document file, the script should create a folder with Excel Column 1 name and save the modified file as a PDF inside it accordingly.
3- After the file is saved, then the files should be email seperately to the email found in Column 1.
Example: After completion of Step #2 (Save modified files in a folder name with the email address found in Column 1, the script should send an email with PDF attachment to the email address found in Column 1 and attach the related file.
4- After completion, the excel file should track "COMPLETED" in Column 8.
Notes:
- Excel file will display 5 columns (5 mistakes) under each column theres a number of where the mistake should be located. The script have to take into consideration (spaces and punctations and numbers).
- Incase there is a space, punctation or number then the script should take the letter before or after.
(Example: "Hi, this is me.") -> In this case, if Mistake 1 == 3, then 3 is a COMMA, and 4 is a SPACE, then the script can take letter NUMBER 5 or NUMBER 2.
- Mistakes should take place in the body of the Word Document file after the seperator line (highlighted in red)
- To take into consideration, if the template consist of the pages, then the header and the side bar will be repeated.