완료

I need several modifications done to an existing Python script which works with excel.

I have four files ([login to view URL], [login to view URL], [login to view URL], [login to view URL]). I need a Python script which does the following:

Step 1: The Python script copies cells A4:A29 from data.xlsx.

Step 2: The Python script pastes them into A1:A26 of excel2.xlsx. [[login to view URL] has a few formulas already there, which instantly parse the data within the sheet, resulting in new values that appear in cells X1:AK2].

Step 3: The Python script then needs to take the data from cells X1:AK2 (from [login to view URL]) and create a .csv file with it (named [login to view URL]). The (X1:AK2) range will be pasted into the range (A1:N2) in the [login to view URL] file.

Now, I have a script [login to view URL] which works with these files but it needs debugging. Here are some of the problems which shouldn't be occurring:

- For Step 1, the Python script currently is copying A1:A29 from data.xlsx. [It should instead be A4:A29].

- For Step 2, the Python script currently is creating a brand new [login to view URL] sheet each time. [It should not be doing this, and only needs to paste data into the existing [login to view URL] sheet each time into A1:A26, leaving the rest of the sheet untouched so the excel sheet formulas can parse column A on their own].

- For Step 3, the Python script currently appears to be copying [login to view URL] cells AL and AM, it should not be including these.

- Note: When you first download the files required for the project, you will notice that when [login to view URL] is ran, it recreates the [login to view URL] file. You will have to redownload a new copy of [login to view URL] to work with if you first run [login to view URL] to test it out.

기술: Python

확대 보기: need help write python script operate telit module, need write python script telit gc864quad module, python script shapefile excel, need modifications open source script, python script convert excel json, python script update excel, project need python script, i have an existing php/mysql script that i need customized with additional functions, i have an existing phpmysql script that i need customized with additional functions, i will provide names address phone email etc etc on a pdf file i need the information put in an excel spread sheet under company, i need someone to set up some excel sheets for me johanesburg, i need python script, I need modifications to current Logo, I need work in data entry in excel, I need help with a python script, I need a script written that i can run on a windows PC to rename 30,000 images from its existing name to another. -- 2, I need an existing template redesigned with a specific target market in mind, I need an existing template redesigned, I need an existing website rebuilt

고용주 소개:
( 10건의 리뷰 ) South Ozone Park, United States

프로젝트 ID: #23922038

수상자:

AmalMohammed1

Hi I can do your work in(1-2 days).i am python programmer with great knowledge of( os, string, xlsxwriter, pandas )[login to view URL] my profile to see my previous [login to view URL] me for more details.i can start your work now. ha 더 보기

$20 USD (2일 이내)
(0건의 리뷰)
0.0

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 18명, 평균 입찰가: $36

gangabass

I can fix all issues you have with your Python / Excel scripts. I can start right now and complete it in less than 24 hours. Thanks. Roman

$60 USD (1일 이내)
(211 리뷰)
6.8
aki003iitr

I have more than 4 years of programming experience in Python and have successfully completed more than 30 projects in Python on this platform. I can work on this task ASAP and get back to you in the next few hours. Ple 더 보기

$30 USD (7일 이내)
(33 리뷰)
6.1
kozachenkodr

Dear client. I am very well experienced in excel processing with python. No problem, Please contact me to discuss. I will give you the best result soon. Regards.

$20 USD (7일 이내)
(11 리뷰)
4.4
IshaqKN

Hi there, Yes! I get what you need. I'll do it for you. I'll rewrite the code from scratch with no errors. Remember I have done some major excel related projects. Best regards, Ishaq

$30 USD (1일 이내)
(18 리뷰)
4.2
Neltori

How are you? I have gone through your requirements and I can do this task. Because I am python expert. I can assure you of a complete professional work in a given timeline. Please share the complete detail of your req 더 보기

$90 USD (7일 이내)
(2 리뷰)
3.3
mochih321

Hello. As you can see my profile, I have developed many python programs. I have full experiences with both of small and big projects. I love python and like to solve many problems in python. If you are finding python e 더 보기

$35 USD (1일 이내)
(8 리뷰)
2.9
freelancermaddi9

Hello,I am Mashud,expert in python. I have read the project description fully. I can complete your task within 1 day perfectly. I can assure you that you will get your job done exceptionally well as you may have expe 더 보기

$30 USD (1일 이내)
(3 리뷰)
2.4
b0b90

Hi I am an expert python developer with over 4 years of development experience. I can build you this simple script today Let's discuss it over chat Regards

$40 USD (1일 이내)
(3 리뷰)
2.5
AStream1210

Hello how are u?⭐⭐⭐⭐⭐ I've just gone through your project requirement carefully. And I'm confident to do this project. I've developed python apps for over 5 years. I'm looking forward to work with you. Regards⭐⭐⭐⭐⭐

$20 USD (7일 이내)
(2 리뷰)
1.1
artemzlobin900

Hello. Fast work, High quality, The Best result is promised. I'm glad to see your project, As a python developer. I've abundant experience in python projects. I think your project is very familiar to me. Looking forwar 더 보기

$15 USD (2일 이내)
(1 리뷰)
0.4
OussamaOux

hello several modifications I am a computer science student in the last year, I use python in my thesis ,I have experience in python and the project is so easy, it is so easy I will fix it maximum in 1 day, so choose m 더 보기

$40 USD (1일 이내)
(0 리뷰)
0.0
jabiroffs

Hey , It's python and i am sure that i can do it easily. I have done many task like this before successfully .

$20 USD (7일 이내)
(0 리뷰)
0.0
olegprokopiv39

Hi, sir. Nice to meet you. I read your project description carefully and I have understood fully your requirements. I am professional in Python and have many experiences for 5+ years. So I'm very interested in your pro 더 보기

$30 USD (1일 이내)
(0 리뷰)
0.0
khp31

Hi, How are you doing ? I can finish above task. Lets discuss about it. Thanks. Ketan........................

$100 USD (7일 이내)
(0 리뷰)
0.0
nikavella2022

I am interested in doing this project. I have been working with Python for more than 2 years. Fast High quality Clean code

$10 USD (1일 이내)
(0 리뷰)
0.0
MiniDeveloper21

Hi There ! hope you are feeling well. I am doing Software Engineering ,Having 2 years experience especially in programming (i.e. Java,C#,C++,C,Python),Code Debugging, Database connections, App development and much mo 더 보기

$15 USD (2일 이내)
(1 리뷰)
0.2
fcbarnard

This should be a simple project. I am allowing for two days to ensure you can test it to make sure you are good

$35 USD (2일 이내)
(0 리뷰)
0.0