Suljettu

Python expert for OpenPyXl task

I need someone who is an expert with Python and OpenPyXl to help me to finish a task automation programme that I have been writing.

Let me explain.

I have 3 excel sheets,

Write off levels - New World from 1st July 2021 [login to view URL]

Write off levels - New World from 1st Apr [login to view URL]

New World Template [login to view URL]

I need to perform several tasks on the Write off levels sheets including removal of a number of columns and rows, unmerge cells etc and then copy a cell range (A - BE) into the New World Template sheet.

So far this is fine and I have my programme doing this successfully.

But the problem I have is when I copy the values from the 2nd Write off levels sheet and paste into New World Template sheet it overwrites the values from the first Write off levels sheet!

So in summary, I need to perform a number of actions on both Write off levels sheets (this is already in the programme script) and then copy cell range A - BE from BOTH Write off levels sheets and merge these values into the New World Template sheet without overwriting each other!

Once this is done I then need to copy the cell formulas from Column BF - CK and "drag" these formulas down to the last row.

I know this can all be done in OpenPyXl but I need some help to achieve this.

I have attached my script below so that you can see what I have written so far.

Please do NOT bid on this unless you are 100% confident that you can complete the task.

I will NOT pay for someone that does not complete this task successfully as I have already had many Freelancers attempt this task and fail and then demand payment from me!

I will send the Excel files to you once we have agreed on the task.

Please start your bid with **OPENPYXL** so that I know you have actually read and understood the description.

Taidot: Python, Tietojärjestelmäarkkitehtuuri, Excel, Tietojenkäsittely

Näytä lisää: wait task finish, finish longterm writing project, israel python expert research job, python expert system, expert programmer required finish incomplete, expert programmer required finish incomplete project, python expert chat, python expert - urgent, python expert, ielts task 1 academic writing, an essay on the role of the egyptian youth do for society with a thesis statement the first task in academic writing, content automation writing, expert in the technical content writing cdr, how to hire python expert, python expert hire, I need a python expert for my multiple projects. If you have knowledge please bid. , python expert required to, python expert programming, python expert programming pdf, python expert help

Tietoa työnantajasta:
( 26 arvostelua ) Southend on sea, United Kingdom

Projektin tunnus: #31841064

12 freelanceria on tarjonnut keskimäärin £29 tähän työhön

MashoodurRehman1

**OPENPYXL** Python Developer I have read your job description and I am pretty sure that I can complete every bit of your requirements. Further details and cost can be discussed in chat

£30 GBP 1 päivässä
(48 arvostelua)
5.3
(34 arvostelua)
5.4
varimaxanalytic

Hello, I am professional freelancer with a Master's degree in Data analytics making me a suitable person for your project. I have more than 8 years of professional experience in Data analysis. Besides, I have skills i Lisää

£14 GBP 1 päivässä
(7 arvostelua)
4.5
opensysknw

Hello, I have gone through the requirements mentioned by you for your project - Python expert for OpenPyXl task. Let us chat on - [login to view URL] in details about your project. We are emerging grou Lisää

£15 GBP 7 päivässä
(23 arvostelua)
4.7
(15 arvostelua)
4.4
yehorshut

[login to view URL] B I'm Yehor and I am happy to bid on your project. The description of your project was catched to my eyes. I have +6 years of experience in ML ,AI, Website design and development. I am expert in languages Lisää

£20 GBP 1 päivässä
(1 arvostelu)
2.8
Timurtem

Hello, danbentonsmith! ⭐⭐⭐⭐⭐⭐⭐ I would like to let you know that I'm a very hardworking and dedicated person. I only take payment when my clients smiles on my output. I'll do my work with full honesty. As I am a new f Lisää

£40 GBP 1 päivässä
(4 arvostelua)
2.2
MamukaB

**OPENPYXL** I think I can do this job ( change/update Py code to make it work correctly) But I think more better will be If I will do all this in VBA Best solution for working with excel is excel VBA. That is 14 time Lisää

£20 GBP 3 päivässä
(3 arvostelua)
1.1
mashri640

Hey, I'm interested your project.I will design this Project in a beautifully, professional way. Thanks for sharing your Presentation work detail. Yes I can do it because I have already work on a similar project in the Lisää

£16 GBP 4 päivässä
(0 arvostelua)
0.0
dmycheshko

Hello, How are you today? Thank you for posting this project, and I'm very happy to bid on your project. I've read carefully your project details. I have rich experiences related to your project. Your satisfaction with Lisää

£120 GBP 2 päivässä
(1 arvostelu)
0.0
foysalhossin

i will seen your project i think i done this work very nicely,,, you can visit my website,,[login to view URL] thank you so much

£13 GBP 2 päivässä
(0 arvostelua)
0.0
HarishVarad

I have done similar task. Rough Idea on how to do it: 1) Read the data in Pandas library (not openpyxl) and merge the data. Save to local system for OpenPyXl to pick up in next step. 2) Create a template with "Pre fill Lisää

£10 GBP 1 päivässä
(0 arvostelua)
0.0