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 vote201 views1 answer
Helper for FastAPI Users to create a super user
Python
1 vote187 views1 answer
Python tk fullscreen
Python
1 vote200 views1 answer
How to check for duplicates in a column in python
Python
0 vote184 views1 answer
How to check if a list is a subset of another list
Python
97 votes179 views6 answers
How to read a csv file in python
Python
2 votes186 views1 answer
Pandas reset row indices
Python
7 votes190 views3 answers
Decode base64 password python
Python
106 votes205 views6 answers
Generate random int python
Python
10 votes222 views3 answers
Python tostring
Python
57 votes201 views4 answers
Get date and time in python
Python