PyQt5 QTableWidget tutorial: Load Excel data into Table Widget [Python, openpyxl, PyQT5]

Описание

Load data from Excel table into PyQt5 QTableWidget. Use Excel and openpyxl with Python and PyQt5. Learn how to load Excel data using openpyxl and load the data into a Table Widget, or QTableWidget with Python PyQt5. Display data in your Table Widget.

In this video, you will:
- Work with PyQt5
- Use QTableWidget or PyQt5 Table Widget
- Install openpyxl
- Use openpyxl with Python
- Load Excel data in Python
- Display data in the table widget
- Create QTableItem
- Add QTableItem

Source code: https://github.com/codefirstio/excel-data-with-pyqt5-qtablewidget

Source of Excel file download: https://www.downloadexcelfiles.com/wo_en/download-excel-file-list-countries-world

For more info:
Install and Setup PyQt5 and Qt Designer: https://youtu.be/kxSuHyQfStA
PyQt5 tutorials playlist: https://www.youtube.com/playlist?list=PLs3IFJPw3G9KhF7BeGOItwoKKLD8e3Dwu

Timestamps:
00:00 Introduction
00:49 Project setup
02:30 Starter code
05:44 Creating a QTableWidget
07:05 Loading data from Excel using openpyxl
08:43 Setting the rows, columns, and header for the QTableWidget
12:58 Populating the QTableWidget

Socials:
My email: code.first.io@gmail.com
Tiktok: https://www.tiktok.com/@hala.codes

*************
**Tags**
PyQt5
Python Excel
Openpyxl Tutorial
PyQt5 tutorial
PyQt5 module
PyQt5 openpyxl
GUI tutorial Python
GUI Project Python
Graphical User Interface Python
Python tutorial
openpyxl
openpyxl tutorial
learn openpyxl