任务需求:将表格中每一行拼接在一起,输出。
直接见代码
import xlrd
filenames="C:/Users/Shineion/Desktop/QC/题目调度规程.xls"
#filenames=filenames.replace("/","//")
#filenames=filenames.replace("\\",r"\\")
xlsx = xlrd.open_workbook(filenames)
# 使用索引打开工作表
table = xlsx.sheet_by_index(0)
# 遍历全部数据
data = ","
row = table.nrows # 总行数
for i in range(row):
rowdate = table.row_values(i) # i行的list
for a, b in enumerate(rowdate):
# print(i,a,b)#第i行,a列,数据b
data = data + str(b) # 默认将非字符串的值转为字符串
data = data + "\n"
print(data)