读取数据源test文件,并将内容格式化输出为下例样式:insert into mxl_student values('01','张三',18,185,'珠海')
import xlrd
wb = xlrd.open_workbook('test.xlsx')
sh = wb.sheet_by_name('s1')
for i in range(sh.nrows):
print('insert into mxl_student values{}'.format(sh.row_values(i)))