Python Forum
How to append a value to specific excel cell using openpyxl
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to append a value to specific excel cell using openpyxl
#1
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Using Excel Cell As A Variable In A Loop knight2000 7 564 Jul-18-2021, 10:52 AM
Last Post: knight2000
Smile Set 'Time' format cell when writing data to excel and not 'custom' limors 3 800 Mar-29-2021, 09:36 PM
Last Post: Larz60+
  Append excel sheet using openpyxl TammyP 1 495 Feb-02-2021, 06:32 PM
Last Post: nilamo
  Openpyxl tkinter search a value in Excel column Heathcliff_1 0 770 Dec-02-2020, 04:35 PM
Last Post: Heathcliff_1
  P3, openpyxl, csv to xlsx, cell is not number, problem with colorize genderbee 1 535 Sep-29-2020, 03:20 PM
Last Post: Larz60+
  Openpyxl: Excel formula & condition formatting removed JaneTan 0 759 Sep-25-2020, 07:02 AM
Last Post: JaneTan
  data frame excel cell calulation buunaanaa 1 782 Jul-04-2020, 06:00 PM
Last Post: buunaanaa
  openpyxl - How can I copy some row from an excel file and paste them in another one? aquerci 2 4,518 Jun-07-2020, 04:26 AM
Last Post: buran
  How can I speed up my openpyxl program reading Excel .xlsx files? deac33 0 1,178 May-04-2020, 08:02 PM
Last Post: deac33
  Cant Append a word in a line to a list err "str obj has no attribute append Sutsro 2 790 Apr-22-2020, 01:01 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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