Тёмный

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

Code First with Hala
Подписаться 36 тыс.
Просмотров 18 тыс.
50% 1

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: code.first.io@gmail.com
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

Наука

Опубликовано:

 

13 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 33   
@lucianocarneiro5962
@lucianocarneiro5962 Год назад
What an amazing video! Congrats for the superb content! I'm learning a lot... Cheers from Brazil!
@codefirstwithhala
@codefirstwithhala Год назад
Glad you enjoyed it! 😊
@user-go4kv4ez7f
@user-go4kv4ez7f Год назад
Мне очень нравятся твои уроки. Очень доступно и интуитивно понятно, даже с таким плохим знанием английского языка как у меня.👍
@user-be9cs2fo1e
@user-be9cs2fo1e 11 месяцев назад
Very simple and clear. Thank you so much
@maradonam26
@maradonam26 4 месяца назад
Thank you for this! Perfect! I have a issue. How can i filter in this app. I wanna filtering in excel table.
@mihai-mirceamoise4861
@mihai-mirceamoise4861 Год назад
Very cool and useful video! Thank you!
@henrikyoservo
@henrikyoservo 7 месяцев назад
I really like your explain! Please don't let of post your videos. TKS.
@arturjurkowski8424
@arturjurkowski8424 Год назад
Thank you soo much, I was looking for somethink like this for last 2 weeks. You are the BEST!
@codefirstwithhala
@codefirstwithhala Год назад
Glad I could help! Thanks for watching :)
@luizcarlos7057
@luizcarlos7057 8 месяцев назад
Parabéns, pela explicação, consegui terminar meu projeto com suas explicações🤩
@rverm1000
@rverm1000 9 месяцев назад
Excellent ive never worked with qtwidget before. nice to have a free alternative to excel
@33jetset
@33jetset Год назад
you are the best, tks for this!
@Error000Max
@Error000Max Год назад
it's a very simple and smart way, thx! ❤😊
@ahmedelshamy9558
@ahmedelshamy9558 Год назад
many thank hala
@ahmedelghazali2587
@ahmedelghazali2587 Год назад
thanks a lot شكرا جزيلا
@andr101
@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?
@HellakatsPlayhouse
@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
@codefirstwithhala Год назад
Thanks for a suggestion! I'll make sure to include such a video soon with a more interactive interface
@HellakatsPlayhouse
@HellakatsPlayhouse Год назад
@@codefirstwithhala yaaay, thanks)
@muhammadprawirayuda3510
@muhammadprawirayuda3510 Год назад
Hi Hala, how about avoiding freezing gui apps when i want to load a ton of data from sqlite db, thanks
@Vijaykeerthy
@Vijaykeerthy Год назад
this video helps so much thanks for uploading this video 🎉🎉🎉 Still, How to load the CSV file in the pyqt5😢
@jhxu8071
@jhxu8071 Год назад
nice vedio!how to insert pictures to a column?
@annasanasaryan
@annasanasaryan 10 месяцев назад
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
@enadagilda6577 10 месяцев назад
Please Madam! i want to send my QTableWidget in a particular widget in my ui interface. how can i do please?
@annasanasaryan
@annasanasaryan 10 месяцев назад
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 RU-vid.
@alkareetesh8193
@alkareetesh8193 Год назад
How to do the reverse process database to excel
@annasanasaryan
@annasanasaryan 10 месяцев назад
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
@SHONNER Год назад
The '% of world pop.' is divided by 100 for some reason?
@user-ct1vg9ps5j
@user-ct1vg9ps5j 10 месяцев назад
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
@SHONNER 10 месяцев назад
@@user-ct1vg9ps5j Sounds good.
@perlasaadeh3322
@perlasaadeh3322 Год назад
Thank you for this! Amazing content as always.
@codefirstwithhala
@codefirstwithhala Год назад
Thanks for watching!
@zakihasan8042
@zakihasan8042 Год назад
@@codefirstwithhala شكرا الك لمجهودك وابداعك
Далее
Automate Your Excel Tasks Using Python
11:05
Просмотров 10 тыс.
15 Python Libraries You Should Know About
14:54
Просмотров 373 тыс.