how to add data one by one in google sheets using python

Question

Here is the Image of Google sheet it still keep updating the same row but i want to append the data one by one enter image description here

def AddEventReasonRecord(self, EventReasonList):
    try:
        GlobalObj = Global()
        records = []
        rows = len(EventReasonList)
        sheet_tile = self.GoogleSheetTitle()
        ItemRow = int(GlobalObj.LasItemRow)
        if rows > 0:
            for index in range(rows):
                ItemRow = ItemRow + 1
                sheet_row = ItemRow + 1
                Obj: EventReason = EventReasonList[index]
                records.append(Cell(sheet_row, 1, Obj.EventID))
                records.append(Cell(sheet_row, 2, Obj.EventName))
                records.append(Cell(sheet_row, 3, Obj.Description))
                records.append(Cell(sheet_row, 4, Obj.Status))
                records.append(Cell(sheet_row, 5, Obj.Event))
                records.append(Cell(sheet_row, 6, Obj.EmpStatus))
                records.append(Cell(sheet_row, 7, Obj.Position))
                records.append(Cell(sheet_row, 8, Obj.PayrollEvent))
                records.append(Cell(sheet_row, 9, Obj.JobPortlet))


            sheet_tile.update_cells(records)

[![enter code here][1]][1]

Tanaike · Accepted Answer · 2020-02-01 01:45:25Z

You want to append the values of records to the sheet of sheet_tile.
You want to achieve this using gspread with python.
You have already been able to get and put values using Sheets API.

If my understanding is correct, how about this answer? Please think of this as just one of several possible answers.

Modification point:

In order to append values to the sheet, the method of append_row is used.

When your script is modified, how about the following modification?

Pattern 1:

Modified script:

From:

sheet_tile.update_cells(records)

To:

sheet_tile.append_row([e.value for e in records], value_input_option="USER_ENTERED")

Pattern 2:

As another modification pattern, how about the following pattern?

Modified script:

From:

for index in range(rows):
     ItemRow = ItemRow + 1
     sheet_row = ItemRow + 1
     Obj: EventReason = EventReasonList[index]
     records.append(Cell(sheet_row, 1, Obj.EventID))
     records.append(Cell(sheet_row, 2, Obj.EventName))
     records.append(Cell(sheet_row, 3, Obj.Description))
     records.append(Cell(sheet_row, 4, Obj.Status))
     records.append(Cell(sheet_row, 5, Obj.Event))
     records.append(Cell(sheet_row, 6, Obj.EmpStatus))
     records.append(Cell(sheet_row, 7, Obj.Position))
     records.append(Cell(sheet_row, 8, Obj.PayrollEvent))
     records.append(Cell(sheet_row, 9, Obj.JobPortlet))

sheet_tile.update_cells(records)

To:

for index in range(rows):
     # ItemRow = ItemRow + 1
     # sheet_row = ItemRow + 1
     Obj: EventReason = EventReasonList[index]
     records.append(Obj.EventID)
     records.append(Obj.EventName)
     records.append(Obj.Description)
     records.append(Obj.Status)
     records.append(Obj.Event)
     records.append(Obj.EmpStatus)
     records.append(Obj.Position)
     records.append(Obj.PayrollEvent)
     records.append(Obj.JobPortlet)

sheet_tile.append_row(records, value_input_option="USER_ENTERED")

References:

If I misunderstood your question and this was not the direction you want, I apologize.

Collectives™ on Stack Overflow

how to add data one by one in google sheets using python

1 Answer 1

Modification point:

Pattern 1:

Modified script:

Pattern 2:

Modified script:

References:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Modification point:

Pattern 1:

Modified script:

Pattern 2:

Modified script:

References:

Comments

Your Answer

Sign up or log in

Post as a guest

Related