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.
이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 18명, 평균 입찰가: $36
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.
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
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⭐⭐⭐⭐⭐