猫史档案馆

【作品展示】

 

【作品介绍】

提取Excel文件中的特定列，并导出为文本文件

 

【作品源代码】

import xlrd
import xlwt

data = xlrd.open_workbook("dindan.xls")
col1 = data.sheet_by_index(0)

cols1 = col1.col_values(1)
cols2 = col1.col_values(5)
cols3 = col1.col_values(10)

workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('sheet')

for i in range(len(cols1)):
    worksheet.write(i, 0, label=cols1[i])
    worksheet.write(i, 1, label=cols2[i])
    worksheet.write(i, 2, label=cols3[i])

workbook.save('daocu.xls')


def row2str(row1):
    str1 = ""
    for i in range(len(row1)):
        if i == len(row1) - 1:
            if type(row1[i]) == float:
                str1 = str1 + str(int(row1[i]))
            else:
                str1 = str1 + str(row1[i])
        else:
            if type(row1[i]) == float:
                str1 = str1 + str(int(row1[i])) + ","
            else:
                str1 = str1 + str(row1[i]) + ","
    return str1

data = xlrd.open_workbook("daocu.xls")
table = data.sheets()[0]
row_cnt = table.nrows

file = open("dindan.txt", "a")
for j in range(0, row_cnt):
    row = table.row_values(j)
    row1 = row2str(row)
    print(row1)
    file.writelines(row1 + "\r")
file.close()

 

【提示】

部分含有Python第三方库相关内容的作品，在海龟编辑器网页端无法运行哦！如遇到这种情况，可以打开下面的链接，下载海龟编辑器客户端：

https://python.codemao.cn