from openpyxl import load_workbook
#打开相应文档
inwb = load_workbook("06.xlsx")
#选择相应的表名
sheet = inwb.get_sheet_by_name('sheet1')
list_sheet_column_C = []
# 将数据存储
for i in sheet["B"]:
list_sheet_column_C.append(i.value)
print(i.value)
print(i)
print(len(list_sheet_column_C))
a = 1
#将数据进行写入txt文档
for i in range(25460):
c = a + 10434
if list_sheet_column_C[c] == None:
list_sheet_column_C[c] = "无有效内容"
# txt文档是没有办法写入none,并且这种的数据一般是视频或者全图片,我们选择直接让它无有效内容
b = "/home/lsgo16/PycharmProjects/untitled1/2012-2013year/{0}.txt".format(a)
with open(b,"w",encoding="utf-8") as f:
# if list_sheet_column_C[a] == :
# list_sheet_column_C[a] == ""
f.write(list_sheet_column_C[c])
print("{0}保存成功".format(a))
a = a + 1