import_excel_1.py

import pandas as pd

"""Option One""""

# Load file as an ExcelFile object
excel = pd.ExcelFile('financial_sample.xlsx')
# Print out the sheet names
print(excel.sheet_names) # Prints out 'Sheet1' and 'Sheet2'

# Load the two sheets as individual DataFrames
df1 = excel.parse('Sheet1')
df2 = excel.parse(1)


"""Option Two"""
excel = pd.read_excel('financial_sample.xlsx', sheet_name='Sheet1')  # Or sheet_name=0