"Become an Excel Wizard Using Python Scripting" by Al Sweigart
Вставка
- Опубліковано 22 гру 2024
- "Become an Excel Wizard Using Python Scripting"
By: Al Sweigart, Invent with Python
September 2016 IndyPy
Join the conversation:
Meetup: indypy.com/
Slack: indypy-invite.... ;
Twitter: @indypy
Thanks to our awesome sponsor:
Six Feet Up is your local Python web application and cloud orchestration partner
sixfeetup.com/
Submit a talk: goo.gl/forms/7...
Sponsor IndyPy: www.meetup.com...
I love this video, I have a physics background, and I have been doing a lot of programming in python lately, however, I have always found excel to be really useful for quickly displaying trends in data, and this video has just made my life a lot easier for doing so.
13:30 - change code to:
from openpyxl.utils import get_column_letter
openpyxl.utils.get_column_letter(1)
THANK YOU! I literally, JUST hit this spot in the video and stumbled until reading this response...
Hi can we perform any data analysis, such as regression, histogram with openpyxl and have the charts populated in the output file?
I do this for a job and I love it!!
My background is in Finance and accounting would learning web scraping with python and R programming help me find a job?
No, you will be begging on the streets wishing why you chose to learn some of the most valued skills in the market.
Could it hurt?
I don’t know if it would “get” you a job. But it can help. I too am in finance and being able to automate and run algorithms on your data is increasingly essential.
I’m looking at Python these days because of its popularity but VBA has been essential for me. But start somewhere.
Well if you get a job in accounting and you're mostly working in excel workbooks, you'll be able to automate a good 99% of your job.
That is what I'm talking about.
His Excel is not activated. Thug Life ;)
Hi , Can you print the date from the excel to the console , like extracting date column as it is from excel ?
You seem to think that the errors you encounter by doing this on the "fly" take away from the learning, however, they add to our experience and serve a purpose.
great stuff. i am going to attempt to change the way i work with excel. hopefully get to save some of my admin task in the long run.
I don't understand the worksheet.worksheet.worksheet and also the workbook.workbook.workbook.
Does openpyxl need a installed version of microsoft excel? Or it could work independently?
pyautogui 只是简单的控制鼠标，键盘等操作；
好像没有一个包能完整的控制软件里的各种控件的吧；
openpyxl version 2.5.3 code changed: openpyxl.cell.cell.get_column_letter(1)
print(inputFile.get_sheet_names()) !
Yet Good Lesson
Doing these changes in python takes longer than just changing these settings right in excel
Python > Excel
I am an VBA expert, why would I learn python, its not very usefull in my opinion. If you are a officeworker who's main tool is working with MS office products better learn VBA then you can manipulate excel, word, access, powerpoint, outlook and swap data between all those very specialised programs. Dont fuck around with python to reaching to try to make it usefull.
VBA has limited use outside of excel (I think)? Where as python is used in Machine learning, some statistical analysis (in place of R) and all sorts of other things... Python's usefulness goes beyond microsoft office - so if you want to be a cool office worker and that's all your scope is VBA is your huckleyberry.
If you're reach is a little higher and you're goal to be a more versatile and your scope a little wider...why wouldn't you learn Python?
I agree, knowledge of VBA is much more useful in this instance. Mass scripting to generate tens of thousands of different workbooks programmtically to deliver to a client would be a different story, python is probably a more reliable workflow. Unfortunately this video doesn't delve into that well