import numpy as np
import pandas as pd
df=pd.read_excel("C:\Users\zls\AppData\Local\Programs\Python\Python37\TEST.xlsx")
pd.set_option('display.max_columns', 100)
pd.set_option('display.max_rows', 100)
pd.set_option('max_colwidth',100)
print(df)