Good to see your subscriber numbers going up, you were under 400 not so long ago, now almost at 1,000! And thanks for taking up my suggestion of zooming in a bit 👍🏻
Thanks Dale! That was a great suggestion so I really appreciate it! And yeah free code camp .org posted my best maker project to their channel and I think alot of folks found me through that which is exciting!
Thanks! Very well explained. Please think about a video on doing changes to many cells at once. For example, change all instances of correllation to correlation.
Interesting! It could be good to do a follow up video with some more advanced functionality built in! Plus I believe new excel supports some python scripting directly!
Hi! Do you mean using python to read data from an excel file and then write it to a word file? I think word already handles excel data pretty well natively!?
Thanks but how do I import the excel file to pycharm? For example the menu file needs to be first added to pycharm right? I'm using a community version of pycharm I'm not able to find an option to add any excel files to pycharm
Hi, so you can just copy/paste or drag/drop it into the same folder you’re working in in pycharm. Or you can import the os module and navigate to where in your computers folder structure it lives!
Thank you so much for the amazing tutorial, is their a way to acces the information while the file is opened or being modified while the code is being executed
This method will actually work while the file is open but it’s not really meant to constantly update while a file is also actively being worked on in excel! You’d need a pretty frequently updated while loop to achieve something like that!
Hi, from your video , i can see you have a lot of experience on VBA. Will there be a way of optimizing VBA functions to go more faster? I've been implementing macros that take a LOT of time while running. What can I do to optimize the code and will computing this on Python could accelerate procedures?
Hi - speed in modern programming languages is all based on how optimized your code is. Try to stop in for loops or while loops as soon as you find what you’re looking for using things like break or return, avoid if chains and nested loops if there are other things available, and most of all try to only grab as small a sized dataset to work with as you can initially
Hey that’s a good idea! Might be a little advanced for some of my viewers but I think it could be a useful concept on a future video! If you need any quick tips on it, this is a pretty good summary too! docs.python.org/3/howto/descriptor.html
Thanks a lot, awesome and very practical video could recommend more videos (yours or others) how to automate work in Excel and other MS office apps is Python effective to automate daily boring tasks on the computer? more recommends much appreciated Cheers 🙂
Hi, you can leave it open while it is running but you want to make sure to close the book before finishing your program! If you leave an excel book open but your python file finishes then changes will not be saved!
whenever I try to run the code it tells me that openpyxl isn't installed, I installed it using cmd but I'm running the code using IDLE, could that be why it isn't working? edit: nevermind, I uninstalled/reinstalled and it started working
I’m looking at a way that I can create a very interactive rota using python so maybe a tutorial on how to design a rota/scheduler in excel but coding in python rather than having to use VBA
That would be a cool idea! I don’t have much experience in rotas myself so I’ll have to do a bit of research, what type of features and functions would you want to see??
@@lemastertech maybe a skill based rota so people are selected depending on their skills. Add, modify and delete someone Dropdown selections depending on their skills, so they only appear in lists they have skills for. Date picker pop up to select dates for the schedule Print/export buttons to print out or export to pdf Email or WhatsApp buttons to send reminders. Also the option to have the reminder go as a calendar reminder on their mobile device.
Can you do a full course on how to make word chain game with use of sql database for dictionary and also how can we make bot that plays this game and also a bot that conducts this game? Also banned letter etc modes
That would be interesting! Thank you for the idea, I will have to read up a bit on word chain games since there are alot of different types! And sql as a database is a good idea that would be an awesome tutorial I will working on a project for that!
That usually means there is a character in the excel doc that python can’t recognize, the error code usually throws what row and cell the error occcurs in
Yes you can manually input the password but it’s honestly probably easier to save off a copy that is not protected, work with it that way, then copy it back into the master. Python also just added an actual excel plug in you can install via excel!
Hi! I am sorry I actually have not personally used this module on linux before, but you might also need the filestream module since linux handles all doc types differently! But I honestly am not sure what the specific fix for linux would be - they have decent online documentation for the openpyxl module though! Goodluck!
Hi I think the best thing to do if you want to use python to do the same style of calculation as the excel sum if would just be to use a for loop with an if statement in python that checks for your conditional and then add that number to your running total if it satisfies your condition and ignore it and move on otherwise!