python - adding rows to an existing worksheet table

Question

I'm working with the .xlsx file and it has a tab with a workhsheet table where lots of conditional formatting are used. From time to time I need to append this table with new rows. My plan is to use python openpyxl (or other package) to append this table. so far I could identify this table as

from openpyxl import load_workbook
wb=load_workbood(myfile)
ws=wb['mytab']
tab = wb.ws._tables[0]

Can I use something like .append() method or change data of this table to add more rows to it? My goal is to keep the formatting.

I've already tried this approach - Manipulate existing excel table using openpyxl and it doesn't' work for me

I'm using openpyxl 2.6.1

Regards, Pavel

I tried it. How to deal with style then? I need to keep the formatting. — Pavel, Mar 20 '19 at 16:54

score 0 · Answer 1 · answered Mar 14 '23 at 04:50

0

update "table.ref" to max row

# ws - work sheet
row_num = ws.max_row + 1
table.ref[:-1] + str(row_num)  # A1:W98

add new row data

row_data = [1,2,3,4,5,]
for col, value in enumerate(row_data):
    ws.cell(row=row, column=col+1).value = value

answered Mar 14 '23 at 04:50

anjaneyulubatta505

10,713
1
52
62

score -1 · Answer 2 · answered Apr 23 '21 at 07:17

-1

from openpyxl import load_workbook
wb=load_workbood(myfile)
ws=wb['mytab']
tab = ws.tables["Table1"]
tab.ref = f"A1:{ws.max_column}{ws.max_row}"

answered Apr 23 '21 at 07:17

cauchy

1

Please provide some context to your answer so that others can easily understand you approach to solve the problem. – Pawara Siriwardhane Apr 23 '21 at 07:48
Please explain what the code does and how it does it. – M-Chen-3 Apr 23 '21 at 15:28

score -2 · Answer 3 · edited Nov 09 '20 at 00:15

-2

from openpyxl import load_workbook

filename= r'C:\Users\PC/test.xlsx'

wb = load_workbook(filename)
ws = wb['Hoja1']
ws["A1"] = "AAA"
ws["A2"] = "BBB"

wb.save(filename)

edited Nov 09 '20 at 00:15

David Buck

3,752
35
31
35

answered Nov 08 '20 at 23:47

user3175453

57
5

python - adding rows to an existing worksheet table

3 Answers3

update "table.ref" to max row

add new row data