read multiple columns from excel to pd and print

[zhuby1973@HansVM ~]$ cat my_excel.py

import pandas as pd

# setup pd option to print all rows and columns

pd.set_option('display.max_rows', None)

pd.set_option('display.max_columns', None)

pd.set_option('display.width', None)

pd.set_option('display.max_colwidth', None)

df = pd.read_excel('Book1.xlsx', sheet_name='Sheet1')

# setup print df without index

blankIndex=[''] * len(df)

df.index=blankIndex

print("bbbb.saveShare('" + df['link']+"', '" + df['code'] + "', path='/')")

[zhuby1973@HansVM ~]$ act

(py36-venv) [zhuby1973@HansVM ~]$ python my_excel.py

bbbb.saveShare('https://pan.baidu.com/s/1Mozs9rLxerrs7e5itBtSTQ', 'p6kk', path='/')

bbbb.saveShare('https://pan.baidu.com/s/1vx0q_iECxMFkQH7u6qOgfA', 'lyyl', path='/')

bbbb.saveShare('https://pan.baidu.com/s/1T5MsVIglP-_oiIy2Umawvg', '12sq', path='/')

bbbb.saveShare('https://pan.baidu.com/s/17i4GgJLL2C3NK1HpRvGBvQ', 'ts5m', path='/')

bbbb.saveShare('https://pan.baidu.com/s/1XHl-JdgMffUmccMR5SzzCw', 'hkfj', path='/')

bbbb.saveShare('https://pan.baidu.com/s/12MdQtqcohqMqeBbYgYYLNw', 'pqrp', path='/')

bbbb.saveShare('https://pan.baidu.com/s/1pwk3PFF1-3_phX7RWM7iww', '876t', path='/')

bbbb.saveShare('https://pan.baidu.com/s/1EPcnz2BlGjg8JDI2i3OTMA', 'bswx', path='/')