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

2 votes118 views1 answer
Read database pandas
Python
0 vote98 views1 answer
NotImplementedError: cannot instantiate 'PosixPath' on your system fast ai
Python
95 votes99 views6 answers
Get current working directory python
Python
1 vote101 views1 answer
Python swap two variables
Python
3 votes122 views2 answers
Pandas concat series into dataframe
Python
1 vote110 views2 answers
Sep and end in print python
Python
0 vote100 views1 answer
Pandas get only entries that match list
Python
0 vote109 views1 answer
Get list of all document in django-elasticsearch-dsl
Python
0 vote110 views1 answer
Update profile rasterio pyton
Python
0 vote110 views1 answer
Python min date from dictionary
Python