Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

WOOHOO! It might not be elegant, but I got everything working! Next I'm going to delve into the win32api and win32com.client libraries and see if I can make the Excel workbooks open for review, and ...
Netopia General Coding Help 44 16,997 Jan-18-2019, 08:15 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

I ended up just deleting the 'Sheet' and creating a new one. Perhaps I'll go back and just change the title. Knowing lots of ways to do something is always good! :)
Netopia General Coding Help 44 16,997 Jan-18-2019, 02:15 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

buran, I hope it's ok that I keep posting my progress. I guess at this point I feel like a little kid with his mentor (even though I'm 56 year old!). Taking it apart piece by piece worked wonders! ...
Netopia General Coding Help 44 16,997 Jan-18-2019, 03:31 AM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

So, as I realized that I really didn't understand what collections, group, groups, subgroup, subgroups... etc were doing. I took your advice earlier about printing things. IT HELPED A LOT! :) Outp...
Netopia General Coding Help 44 16,997 Jan-17-2019, 10:19 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

I took the general thought from this in your debugging link: Quote:Once your program compiles cleanly and the duck doesn’t raise any major objections, if there’s still a bug then see if you can break...
Netopia General Coding Help 44 16,997 Jan-17-2019, 05:33 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

buran, Per your suggestions and the debug link, I moved all the way back to just making changes to the full data set and just saving it as a different file. Here's what I have so far, and it's worki...
Netopia General Coding Help 44 16,997 Jan-17-2019, 04:59 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

Well buran, thanking you is getting to be a daily activity! Sure enough, I looked at the last sheet of the last workbook and there was the font change... but I would not have thought to look through ...
Netopia General Coding Help 44 16,997 Jan-16-2019, 03:29 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

A little further each day... but always needing a bit of hand holding. I decided that it would be a good thing to be able to have the columns be the width of the data. So, I to google around and s...
Netopia General Coding Help 44 16,997 Jan-16-2019, 04:36 AM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

BURAN! Still trying to get my head around it, but that worked! Excecpt for the print(data.items()), the program complained that data had no attribute 'items'. I just removed the '.items()' and it pr...
Netopia General Coding Help 44 16,997 Jan-15-2019, 02:14 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

Kept trying, but thus far to no avail. I think the real problem is that I'm not conceptualizing what's happening at each stage and being able to then convert that to proper code. What I wrote below ...
Netopia General Coding Help 44 16,997 Jan-15-2019, 02:56 AM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

Thank you for that explanation... I ended up needing to know that! :) I've gotten stuck again. I'm managed to create spreadsheets named as a concatenation of the original file and the group. I've m...
Netopia General Coding Help 44 16,997 Jan-15-2019, 12:22 AM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

Your last thought answered my question. I thought that: x[-1][:-1]Was sorting by the last character of the last element of the row... except that the output was actually sorted by the complete eleme...
Netopia General Coding Help 44 16,997 Jan-14-2019, 08:24 PM
    Thread: How to think....
Post: How to think....

Greetings! As a Newb to programming, I'm finding that one obstacle is actually 'thinking' like a programmer. To those of you who feel like you've passed that hurdle, what advice, reading, projects w...
Netopia News and Discussions 1 1,843 Jan-14-2019, 08:20 PM
    Thread: pip install syntax errror again and again
Post: RE: pip install syntax errror again and again

Just in case anyone has the problem I just had, I thought I'd share. I had a command prompt open on my computer and installed Python 3.72 with pip. I then went to the command prompt and attempted to...
Netopia News and Discussions 5 24,425 Jan-14-2019, 07:29 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

OK, so I did some reading and I think I understand the block below, but need some clarification: #print each group in desired order for group, rows in sorted(groups.items()): print('\n\nGroup {}\...
Netopia General Coding Help 44 16,997 Jan-14-2019, 07:20 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

buran, "If you can't explain it to a six year old, you don't understand it yourself.", Albert Einstein I can see by your excellent explanations that you take this quote to heart! :) Ok, so groups i...
Netopia General Coding Help 44 16,997 Jan-11-2019, 02:54 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

(Jan-11-2019, 01:54 PM)buran Wrote: pay attention to comments in the code (and ignore the typing errors :-)) Quote:# read header and all data in two variables -> header and data # Note the asteri...
Netopia General Coding Help 44 16,997 Jan-11-2019, 01:57 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

Thank you for that explanation buran. Already I'm learning! I puzzled over the line: header, *data = ws.valuesHow did it know to pull the header out just by having a variable named "header"? So, I...
Netopia General Coding Help 44 16,997 Jan-11-2019, 01:48 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

Gribouillis, I had some success implementing the sample code you gave. I can now get a list of the data, with the len equaling the number of rows! Thank you! buran I'm going to go through your exa...
Netopia General Coding Help 44 16,997 Jan-11-2019, 01:19 PM
    Thread: Complete NEWB and openpyxl project
Post: RE: Complete NEWB and openpyxl project

Ok, I've modified it so that there are four of every Reorder value. Thank goodness for online random name generators! :) Not something I'd ever thought of googling before today.
Netopia General Coding Help 44 16,997 Jan-10-2019, 08:39 PM

User Panel Messages

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