Import Excel file and use pandas

[PyQt] Import Excel file and use pandas

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

[PyQt] Import Excel file and use pandas

WBPYTHON
Programmer named Tim

Posts: 15

Threads: 6

Joined: Mar 2020

Reputation: 0

Mar-22-2020, 11:28 AM

Hello,

You are right, thank you. The code below solved it.

fileNameTuple = QFileDialog.getOpenFileName(self, 'OpenFile',"", "Excel (*.xls *.xlsx)")
        fileName = fileNameTuple[0]
        df = pandas.read_excel(fileName)

Find

Messages In This Thread

Import Excel file and use pandas - by WBPYTHON - Mar-21-2020, 05:16 PM

RE: Import Excel file and use pandas - by deanhystad - Mar-22-2020, 02:56 AM

RE: Import Excel file and use pandas - by WBPYTHON - Mar-22-2020, 11:28 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	[PyGUI] Python Application Not Finding Excel File	dseals26	2	2,869	Feb-17-2021, 01:45 AM Last Post: thewolf
	Import a file and show file name on qcombobox	GMCobraz	1	1,977	Jul-02-2020, 01:38 PM Last Post: GMCobraz
	[Tkinter] Tkinter - I need to read file excel from GUI app to script file	johnjh	0	10,736	Apr-17-2020, 08:14 PM Last Post: johnjh
	PyQt5 - import rext from other file - despearte for help	D_frucht	1	2,486	May-26-2018, 06:37 AM Last Post: Barrowman
	[PyQt] cant import progress bar from another py file	swipis	7	8,638	Dec-18-2016, 10:41 AM Last Post: swipis

Users browsing this thread: 2 Guest(s)

View a Printable Version

[PyQt] Import Excel file and use pandas

User Panel Messages

Announcements