Python Forum
Using OpenPyXL How To Read Entire Column Into Dictionary
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Using OpenPyXL How To Read Entire Column Into Dictionary
#1
Using openpyxl how can I read every row in the last column (excluding the first row for the header) into a dictionary?
Reply
#2
what have you tried? what is the input file (is it xlsx or actually csv file)?
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Make entire script run again every 45 mo NDillard 0 293 Jan-23-2024, 09:40 PM
Last Post: NDillard
  can openpyxl read font colors mperemsky 3 1,656 May-09-2023, 11:18 AM
Last Post: MindKeeper
  How to read csv file update matplotlib column chart regularly SamLiu 2 1,016 Jan-21-2023, 11:33 PM
Last Post: SamLiu
  Calculated DF column from dictionary value plantagenet 2 837 Sep-16-2022, 12:46 AM
Last Post: plantagenet
  Read xml column inside csv file with Python estertabita 2 1,327 Jul-26-2022, 06:09 PM
Last Post: Larz60+
  Openpyxl-change value of cells in column based on value that currently occupies cells phillipaj1391 5 9,576 Mar-30-2022, 11:05 PM
Last Post: Pedroski55
Question How do I skipkeys on json file read to python dictionary? BrandonKastning 3 1,831 Mar-08-2022, 09:34 PM
Last Post: BrandonKastning
  Find last filled column in openpyxl Irv1n 2 12,557 Jan-16-2022, 11:05 AM
Last Post: Pedroski55
  Reiszing figure to occupy entire frame fishbackp 0 1,350 Jan-06-2022, 10:33 PM
Last Post: fishbackp
  How to get OpenCV to display entire camera frame? George713 1 3,207 Aug-12-2021, 02:45 AM
Last Post: Pedroski55

Forum Jump:

User Panel Messages

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