python pandas read_excel

35

df = pd.read_excel('reading_excel_file.xlsx', 
                   sheet_name='Purchase Orders 1',
                  usecols='A:B, H:I')
df = pd.read_excel("sales_excel.xlsx", 
                   sheet_name='Sheet1',
                  header=5)
import pandas as pd

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

Comments

Submit
0 Comments