Python Forum
How to append a value to specific excel cell using openpyxl - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: How to append a value to specific excel cell using openpyxl (/thread-32784.html)



How to append a value to specific excel cell using openpyxl - hobbyist - Mar-05-2021

So, I have a code that inserts values to cells on excel sheet. But it does not work. I have a for-loop for 100 values and stores only the 100th, in the 100th cell (columns = 1, 2, 3). I want to test to see if appends does the difference. So I need to append values to specific cell using openpyxl. Any idea how to do this? This is the command for the row = what the counter is at that specific time and column = 2:

sheet.cell(row = counter, column = 2).value = 45