PYTHON

pandas read excel

import pandas as pd
pd.read_excel('tmp.xlsx', index_col=0)

pandas read_excel

df = pd.read_excel('reading_excel_file.xlsx', 
                   sheet_name='Purchase Orders 1',
                  usecols='A:B, H:I')

pandas read_excel

df = pd.read_excel("sales_excel.xlsx", 
                   sheet_name='Sheet1',
                  header=5)

pandas read_excel

df = pd.read_excel('reading_excel_file.xlsx', 
                   sheet_name='Purchase Orders 1',
                  skiprows=2)

pandas read_excel

df = pd.read_excel('reading_excel_file.xlsx', 
                   sheet_name='Purchase Orders 1',
                  skipfooter=3)

Pandas read excel

import pandas as pd

data = pd.read_excel (r'C:UsersRonDesktopProduct List.xlsx') 
df = pd.DataFrame(data, columns= ['Product'])
print (df)

python pandas read_excel

import pandas as pd
inFile = "Table.xlsx"  #  Excel name file
inSheetName = "Sheet1"  #  Excel name sheet
rows2skip = 1
pd.read_excel(inFile, sheet_name = inSheetName, rows2skip = 1)

pandas read_excel

df = pd.read_excel('reading_excel_file.xlsx', 
                   sheet_name='Purchase Orders 1',
                  usecols='C:F')

pandas excelfile

>>> with ExcelWriter('path_to_file.xlsx') as writer:
...     df1.to_excel(writer, sheet_name='Sheet1')
...     df2.to_excel(writer, sheet_name='Sheet2')