Python open excel application

from win32com.client import Dispatch

xl = Dispatch("Excel.Application")
xl.Visible = True # otherwise excel is hidden

# newest excel does not accept forward slash in path
wb = xl.Workbooks.Open(r'C:\Users\300231823\Desktop\GUI\simplenew4.xls')
wb.Close()
xl.Quit()

Python excel file

#Creating the ExcelFile object
xls = pd.ExcelFile(r'Path.xlsx')
#In the next step, you can pass the ExcelFile object to read_excel to import
#its content, instead of the path to the file.
data = pd.read_excel(xls,  sheet_name='Name_of_sheet', index_col='Index_Column')

Similar codes

0 vote127 views2 answers
Avoid bad request django
Python Django
12 votes99 views5 answers
Plot size
Python
0 vote105 views1 answer
111
Python
12 votes99 views1 answer
Python range for float
Python
0 vote97 views1 answer
Python sort list by rule
Python
8 votes91 views3 answers
Linear search python
Python
0 vote102 views1 answer
Python import only one function
Python
0 vote97 views1 answer
Count wit for loop pthoon
Python
18 votes106 views3 answers
Tkinter make window not resizable
Python
0 vote105 views2 answers
Negation of boolean in pyhton
Python