Python Forum

Full Version: How to append a value to specific excel cell using openpyxl
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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