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

16 votes302 views2 answers
Implementing a bubble sort in python
Python
0 vote298 views1 answer
Can you use the astro a50 with a phone
Python
15 votes299 views3 answers
From csv to pandas dataframe
Python
0 vote302 views1 answer
Python random email generator
Python
0 vote321 views1 answer
Rename a variable using .format in python
Python
0 vote302 views1 answer
Which clause is used to place condition with GROUP BY clause in a table
Python
-1 vote293 views1 answer
Compute Count2(AACAAGCTGATAAACATTTAAAGAG, AAAAA). in python
Python
0 vote295 views1 answer
Swap 2 no in one line python
Python
4 votes306 views2 answers
List to json python
Python
5 votes301 views2 answers
Value count a list python
Python