Python Forum
Python script for excel sheet
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python script for excel sheet
#1
Hi all,
i'd like to make a script to read esch value in the first column and copy it to the empty cell of the corresponding line as follow:
A1 A2 A3 A4
2 . 6 .
3 5 . 11
6 7 . .
12 . 9 48
20 8 2 .

to be:

A1 A2 A3 A4
2 2 6 2
3 5 3 11
6 7 6 6
12 12 9 48
20 8 2 20
Reply


Messages In This Thread
Python script for excel sheet - by Nabil - May-30-2021, 01:30 PM
RE: Python script for excel sheet - by jefsummers - May-30-2021, 04:39 PM
RE: Python script for excel sheet - by Nabil - May-31-2021, 10:41 AM
RE: Python script for excel sheet - by jefsummers - May-31-2021, 12:41 PM
RE: Python script for excel sheet - by Pedroski55 - Jun-01-2021, 05:09 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  New on python. Needs help with Google sheet jeromep 1 134 Yesterday, 06:47 PM
Last Post: deanhystad
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 1,900 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  Is there a *.bat DOS batch script to *.py Python Script converter? pstein 3 3,274 Jun-29-2023, 11:57 AM
Last Post: gologica
  how to read txt file, and write into excel with multiply sheet jacklee26 14 10,048 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  Trying to use 2 values from excel in my script but getting error.. cubangt 3 1,684 May-11-2022, 07:12 AM
Last Post: normanwolf
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 7,139 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 2,241 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  Python script to summarize excel tables, then output a composite table? i'm a total n surfer349 1 2,362 Feb-05-2021, 04:37 PM
Last Post: nilamo
  Append excel sheet using openpyxl TammyP 1 2,397 Feb-02-2021, 06:32 PM
Last Post: nilamo
  How to Copy Single Value From One Excel Sheet to Another SunWers 4 4,365 Dec-29-2020, 05:39 PM
Last Post: SunWers

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020