Due to the influence of refraining from going out, I buy and read books of various genres. I take the events that happened as a good opportunity and enjoy studying (laughs)
That aside Automation? Efficiency? I have a longing for that, so I decided to start with something simple, I investigated "only how" to streamline the work flow of Excel with Excel and Python. Practice is also in the next article. ..
It is also a skill that can be used universally regardless of the type of industry. It was one of the reasons I decided to study. After that, I only make VBA when I'm reluctant and need it, Can you escape to Python? I like it (laughs)
Abbreviation for Visual Basic for Applications Roughly speaking, it is a program that can extend Microsoft's office products (Excel, Word, etc.). A macro is a program created with VBA. (I didn't understand much .. Is it a program? (゜-゜)) ⇒The scope of skill application is limited.
It is a programming language that can be executed on various operating systems such as windows, mac, and linux. It is said that even beginners can easily understand it. Also, the library is abundant and you can do various things ('ω') vague. ..
▼ From here https://www.python.org/downloads/
Visual Studio Code ・ ・ ・ Free tool for Microsoft source creation support https://code.visualstudio.com/ ▼ Extensions you want to include ・ Japanese Langbuage Pack for Visial Studio Code -Python code input support extension (Python Extension for Visual Studio Code)
openpyxl Can read and write Excel files (.xlsx) In the terminal of Visula Studio, "pip install open pyxl" https://pypi.org/project/openpyxl/ ▼ Reference https://openpyxl.readthedocs.io/en/stable/api/openpyxl.reader.excel.html#openpyxl.reader.excel.load_workbook https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.workbook.html pandas Excel pivot table can be created In the Visula Studio terminal, "pip install pandas" https://pypi.org/project/pandas/ pathlib Files and folders can be treated as objects In the Visula Studio terminal, "pip install path lib" https://pypi.org/project/pathlib/
https://qiita.com/seradaihyo/items/91c78b05401c9c328bb8 https://qiita.com/RIKIgigasu/items/9614ad4c1887157fe6c2 https://qiita.com/KAWAII/items/a7ec5b4fc3c9365cf9fc https://qiita.com/Takuya_Fujitani/items/93b534ad94ceaa06b89c
Now you're ready to streamline your Excel workflow. Next time, I'll do something like this! I would like to make an article about the result of deciding and executing. I want something useful. think.
that's all.
Recommended Posts