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 |