|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-and-excel-programming-using-openpyxl/
课程评论：没有评论
**课程名称：** Python与Excel编程 (使用OpenPyXL库) **课程概述：** 本课程将教授如何使用Python的OpenXLPy库，实现Python程序与Excel的互联互通。通过OpenXLPy，您可以使用Python在Excel中实现各种强大功能，包括： * **创建和更新Excel文件：** 从Python代码生成新的电子表格，或修改现有的电子表格。 * **数据读取与处理：** 将电子表格中的数据加载到Python程序中进行任意分析和处理，再将结果保存回电子表格。 * **Excel样式设计：** 使用Python控制Excel单元格的字体颜色、大小、粗细、斜体等样式，并添加边框。 * **图表生成：** 利用Python创建基本的Excel图表，如饼图、条形图和折线图。 **课程内容亮点：** * Python和Sublime Text的安装与配置。 * 虚拟环境的搭建。 * OpenXLPy库的安装与使用。 * Python与Excel的交互基础：加载、读取、修改和保存Excel文件。 * 程序化地获取和处理Excel数据的技巧，包括循环遍历。 * 在Python代码中使用Excel公式。 * 丰富Excel单元格的样式和外观。 * 生成不同类型的Excel图表。 **课程目标：** 完成本课程后，您将能够熟练运用Python和OpenXLPy库，从Python程序中实现对Excel文件的各种自动化操作，为数据处理和分析带来极大的便利。
In this course you'll learn how to use the OpenPyXL Library for Python to connect your Python programs to Excel and vice versa. Using OpenPyXL, you can use Python to do all sorts of cool things in Excel; from creating spreadsheets from your code, to updating existing spreadsheets. You'll be able to load data from a spreadsheet into your python program and do anything you want with it, and then save it back to the spreadsheet. We'll learn how to style spreadsheets using Python, and also how to make basic charts and graphs in a spreadsheet using Python.You'll learn...- Install Python- Install Sublime Text and Git Bash Terminal- Set up a Virtual Environment- Install OpenPyXL- Create a First Python Program- Load an Excel Spreadsheet Workbook into a Python Program- Grab a Spreadsheet Cell Programatically- Grab whole Columns and Rows from a Spreadsheet with Python- Change the Data in your Spreadsheet using Python- Save Changed Spreadsheets from your Python Program- How to Loop Though A Spreadsheet programatically with Python- Learn How To Create an Excel Spreadsheet from scratch with Python- Use Excel Formulas in your Python Code- Change The Font color, size, boldness, italics and more With Python- Add Borders to Cells in your Spreadsheet with Python- Create Pie Charts With Python- Create Bar Charts With Python- Create Line Charts With Python- and More!At the end of this course you'll be able to use Python to do all sorts of fun things with Spreadsheets, all from your python programs!See you inside!- John Elder
