Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Using OpenPyXL How To Read Entire Column Into Dictionary
Post: Using OpenPyXL How To Read Entire Column Into Dict...
Using openpyxl how can I read every row in the last column (excluding the first row for the header) into a dictionary?
 jo15765 General Coding Help 1 2,727 Jun-07-2020, 09:23 PM
    Thread: Assigning Value To Period Seperated List
Post: RE: Assigning Value To Period Seperated List
That looks like exactly what I'm after. I guess my last hurdle is how do I read in an entire column using openpyxl? I have mc2 = ws2.max_columnI'd then want to read all data from mc2 into the dictio...
 jo15765 General Coding Help 6 2,439 Jun-07-2020, 09:02 PM
    Thread: Assigning Value To Period Seperated List
Post: RE: Assigning Value To Period Seperated List
@Yoriz -- i have an excel workbook that will have period separated values. As an example like the below 1.1.1.1 1.2.1.1 1.1.2.1 2.1.1.1 2.1.2.1 2.2.2.1 1.1.1.1 1.1.1.1 2.1.1.1In the above list we h...
 jo15765 General Coding Help 6 2,439 Jun-07-2020, 08:40 PM
    Thread: Assigning Value To Period Seperated List
Post: Assigning Value To Period Seperated List
I have period separated list of values, like this 1.1.1.1 1.2.1.1 1.1.2.1etc and these can be duplicated. I need a way to assign a alpha value to them so for example 1.1.1.1 = A 1.2.1.1 = B 1.1.2....
 jo15765 General Coding Help 6 2,439 Jun-07-2020, 08:22 PM
    Thread: Help With Error Handling
Post: RE: Help With Error Handling
@grantfutuk -> that was exactly the issue! I installed spyder on Ubuntu but I did not realize that it was Spyder2 (running on Python 2.3) - I have upgraded to Spyder3 (running on Python 3.6.6+) an...
 jo15765 General Coding Help 6 4,178 Sep-14-2018, 06:27 PM
    Thread: Help With Error Handling
Post: RE: Help With Error Handling
(Sep-14-2018, 04:53 PM)gruntfutuk Wrote: jo15765 I am curious as to why you are using Python 2.7 - this is legacy python and should not normally be used by beginners of Python. Official support for ...
 jo15765 General Coding Help 6 4,178 Sep-14-2018, 06:04 PM
    Thread: Help With Error Handling
Post: Help With Error Handling
Hello - I am new to python and am attempting to validate that the user input is a number with my script. I have the below syntax, but instead of actually presenting my expected message, I get the be...
 jo15765 General Coding Help 6 4,178 Sep-14-2018, 02:44 PM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020