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.

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

[HarryMcKenzieTV]

is it possible for libreoffice python to send messages to another application that listens to these messages, like for example if i change a value in a certain cell, i would like python to broadcast this message to another application?

[kychemclass]

Dear Ryan. Thank you so much for this series of videos!! I noticed you manually have to refresh LO Calc after python has 'poked' a value into the sheet. How to get the sheet to update itself once python does this?