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: github.com/codefirstio/excel-...
Source of Excel file download: www.downloadexcelfiles.com/wo...
For more info:
Install and Setup PyQt5 and Qt Designer: • Install and Setup PyQt...
PyQt5 tutorials playlist: • PyQt5 tutorials
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: [e-mail]
Tiktok: / 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

[@user-go4kv4ez7f]

Мне очень нравятся твои уроки. Очень доступно и интуитивно понятно, даже с таким плохим знанием английского языка как у меня.👍

[@maradonam26]

Thank you for this! Perfect! I have a issue. How can i filter in this app. I wanna filtering in excel table.

[@user-be9cs2fo1e]

Very simple and clear. Thank you so much

[@lucianocarneiro5962]

What an amazing video! Congrats for the superb content! I'm learning a lot... Cheers from Brazil!

[@codefirstwithhala]

Glad you enjoyed it! 😊

[@henrikyoservo]

I really like your explain! Please don't let of post your videos. TKS.

[@mihai-mirceamoise4861]

Very cool and useful video! Thank you!

[@rverm1000]

Excellent ive never worked with qtwidget before. nice to have a free alternative to excel

[@luizcarlos7057]

Parabéns, pela explicação, consegui terminar meu projeto com suas explicações🤩

[@arturjurkowski8424]

Thank you soo much, I was looking for somethink like this for last 2 weeks. You are the BEST!

[@codefirstwithhala]

Glad I could help! Thanks for watching :)

[@Error000Max]

it's a very simple and smart way, thx! ❤😊

[@andr101]

very easy to follow and well explained! What would be a good strategy performance-wise to populate a table with millions of rows and many columns?

[@33jetset]

you are the best, tks for this!

[@ahmedelghazali2587]

thanks a lot شكرا جزيلا

[@ahmedelshamy9558]

many thank hala

[@muhammadprawirayuda3510]

Hi Hala, how about avoiding freezing gui apps when i want to load a ton of data from sqlite db, thanks

[@HellakatsPlayhouse]

oooh, niice. Finally find how to start up a window on fullscreen. A big thanks! And what about editable tables in our window, saying, an our own lil Excel with some functions of above?

[@codefirstwithhala]

Thanks for a suggestion! I'll make sure to include such a video soon with a more interactive interface

[@HellakatsPlayhouse]

@@codefirstwithhala yaaay, thanks)

[@Vijaykeerthy]

this video helps so much thanks for uploading this video 🎉🎉🎉 Still, How to load the CSV file in the pyqt5😢

[@jhxu8071]

nice vedio！how to insert pictures to a column?

[@annasanasaryan]

not sure why, but I keep on getting an error because of the openpyxl... I have tried ALL the solutions for how to make to work, however couldn't make it work....

[@enadagilda6577]

Please Madam! i want to send my QTableWidget in a particular widget in my ui interface. how can i do please?

[@annasanasaryan]

One option would be to use Qt Creator or Qt Designer. However, if you are looking for creation of the UI from scratch via python code, there should be videos dedicated to that matter on KZbin.

[@alkareetesh8193]

How to do the reverse process database to excel

[@annasanasaryan]

I would create a button, connect the button to a method and complete the task via xlwt. I have seen some examples in StackOverflow by searching "How to export data from QTableWidget to Excel".

[@SHONNER]

The '% of world pop.' is divided by 100 for some reason?

[@user-ct1vg9ps5j]

That's the original value stored in the spreadsheet. You see, a value of 0.5 is displayed in Excel as 50% (formatted as percentage) and a value of 1 is displayed as 100%. That's how percentages should be properly stored in an Excel file: a value between 0 and 1.

[@SHONNER]

@@user-ct1vg9ps5j Sounds good.

[@perlasaadeh3322]

Thank you for this! Amazing content as always.

[@codefirstwithhala]

Thanks for watching!

[@zakihasan8042]

@@codefirstwithhala شكرا الك لمجهودك وابداعك