Python Introduction to openpyxl Using LibreOffice Calc

In this python tutorial, we will introduce the openpyxl package. openpyxl is a python library to read/write Excel files. openpyxl can help automate Excel with python (python excel tutorial with openpyxl). The worksheets can be opened with LibreOffice Calc, Numbers, or Google Sheets, etc., as well as with Excel. Topics include: create a blank Excel file (spreadsheet), activate a specific worksheet, give a worksheet tab a new name, assign values to Excel file (spreadsheet) cells, add worksheets to Excel file, change active worksheet, change worksheet tab color, copy worksheets, view/print worksheet names, and save the worksheet. Jupyter Notebook on GitHub: https://github.com/groundhogday321/python-openpyxl This is part 00 of the openpyxl series. The topics covered in this series include: 00-openpyxl introduction 01-openpyxl append, access 02-openpyxl loading from file 03-openpyxl functions 04-openpyxl insert images 05-openpyxl insert, delete, move 06-openpyxl numpy, pandas 07-openpyxl charts 08-openpyxl styles 09-openpyxl conditional formatting 10-openpyxl filter and sort 11-openpyxl data validation

Видео Python Introduction to openpyxl Using LibreOffice Calc автора Python техники