Find Jobs
Hire Freelancers

Python expert for OpenPyXl task

£10-20 GBP

Closed
Posted over 2 years ago

£10-20 GBP

Paid on delivery
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.
Project ID: 31841064

About the project

12 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average £29 GBP for this job
User Avatar
**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 in 1 day
4.9 (48 reviews)
5.3
5.3
User Avatar
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 in Python, Excel, Software Architecture and Data Processing. For your reference, you can check reviews\ portifolio for all the projects I handled so far. Hope to connect with you on personal chat. Regards, Peter
£14 GBP in 1 day
5.0 (7 reviews)
4.5
4.5
User Avatar
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 freelancer in this sector, I don't have much working experience. But I do have the qualities that make me good at this work. I'm also very good at maintaining excel sheets, google sheets, market research, data analysis, business research, lead generation, etc. So, if you hire me, I'll do my best to complete you work perfectly. And give you the best output you have ever seen. If you want, let's discuss details in chat. I'm eagerly waiting for your responnse. Yours sincerely. From Timurtem. Thanks!
£40 GBP in 1 day
5.0 (4 reviews)
2.2
2.2
User Avatar
**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 faster then Python and working directly with sheets So I recommended VBA for this job Good result is guaranteed. I have a 15+ year experience Excel VBA, Visual Basic and Quick Basic application. After clarifications from you, I can do this maybe in 1-2 day using VBA ( But I can do this in Py too ) Hope you will be satisfied with result Thanks
£20 GBP in 3 days
5.0 (3 reviews)
1.1
1.1
User Avatar
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 past. I can do it. I am an expert in this field. I will give you high quality and fast work. I will work with full dedication to give you the best design within the time. Have a Nice Day Go Ahead. Regards, mashi
£16 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 the project is my top priority! If you give me a chance to work with you, then I will do my best to reach your requirements. I'm waiting for your kind response. Please send msg over chat. Let's go. I will do my best for you. Best Regards.
£120 GBP in 2 days
0.0 (1 review)
0.0
0.0
User Avatar
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 filled formulas", say 10,000 rows or more. (to cover Column BF - CK part) 3) Read the merged/saved data in OpenPyXl and refresh to populate in formula. Do paste special. 4) Delete the unused rows and save it back with openpyxl. Why? Use pandas for minimal code You have control on the formulas (if you want to change the formula later, you edit template).
£10 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Southend on sea, United Kingdom
5.0
26
Payment method verified
Member since Mar 26, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.