|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/control-excel-with-python-openpyxl/
课程评论：没有评论
课程名称：使用 Python 和 OpenPyXL 控制 Excel 课程概述： 本课程旨在帮助学员成为 Excel 的高级用户，学习如何使用 Python 和 OpenPyXL 控制和自动化 Excel。课程适合任何对用 Python 控制和自动化 Excel 感兴趣的人群，不论是否具备编程经验。只需基础的 Python 知识，教材中会逐步讲解每个代码片段。 课程要求： - 需要安装 Python 3 的计算机 - 要安装 OpenPyXL - 任何电子表格程序（推荐 Excel 或 OpenOffice 等类似应用） 课程内容： 如果你有很多 Excel 文件需要格式化，或者需要在每个工作表中填入数据；如果你需要在电子表格中创建图表或插入公式，或者只是想在办公室炫耀，那么本课程将为你提供全面的指南，涉及 Excel 自动化的细节。课程将迅速深入 OpenPyXL，帮助你迅速上手创建和操作电子表格。 通过学习 OpenPyXL，你可以进行高级排序和过滤，插入和删除行，复制单元格，设置自定义格式等等。学好此课程，不仅能提升工作效率，甚至还能为你的职业发展打开新的机会。 学习完成后，你将能够： - 创建和操作工作簿及工作表 - 使用绝对和相对引用读取单元格数据 - 遍历单元格并对每个单元格执行操作 - 删除行和列，插入公式和表格 - 使用字体、颜色和单元格类型格式化电子表格 - 将所学知识应用到自己的工作中 - 创建文件和文件夹，交互调用打开和保存文件对话框 不论你对游戏、商业、工程还是数据感兴趣，本课程都将为你在 Python 中处理电子表格提供所需的全部知识。今天就来参加本课程，开始成为 Excel 高级用户的旅程吧！
RequirementsBasic Python knowledge - Don't worry, we will cover each code snippetYou will need a computer with Python 3 installed, then we will cover how to install OpenPyXLSome form of spreadsheet program. I use Excel, but you can also use OpenOffice or similar applicationsDescriptionBecome an Excel Power User - Learn how to control & automate Excel with Python and OpenPyXLDo you have a bunch of Excel files that you need to format or put some value in a cell on each page? Do you need to create Charts on your spreadsheets or insert formulas? Maybe you just want to show off at the office! Whatever your needs, you can expect a comprehensive guide going through the nuts and bolts of how automating Excel works. The course dives straight into OpenPyXL, so you will be up and running creating and manipulating spreadsheets in no-time.I have had so much use of OpenPyXL when dealing with spreadsheets. You can create advanced sorts and filters, insert and delete rows, copy cells, set custom formatting and much more. I even got a job based on my OpenPyXL knowledge. I am sure you will benefit from learning OpenPyXL if you have even the slightest interest in making your everyday life easier.After taking this course you will:Know how to create and manipulate Workbooks and SheetsRead cell data with absolute and relative referencesIterate over cells and perform actions on each cellKnow how to delete rows and columnsInsert formulas and tablesFormat your spreadsheets with fonts, colors and cell typesUnderstand how you could apply this knowledge to your own workCreate files and foldersInteract with open and save file dialogsWhether it's gaming, business, engineering, or data you're passionate about, this course will give you everything you need for working on spreadsheets with Python. Take this course today, and begin your journey to having a full-fledged career as an Excel Power User!Who this course is for:Anyone interested in controlling and automating Excel with Python - with or without coding experience. People who want to get rid of manually editing hundreds of spreadsheets by handEspecially suitable for those who would like to extract or add data on multiple spreadsheets or automate the creation of spreadsheets from input dataPeople who would like to know more about solving Excel problems with PythonPeople who would like to start consulting services by automating Excel tasks
