我有多达1500个文本文件,我想从每个文本文件复制5行,比如第4、5、9、14和32行。我想把这些文件列在一个excel表格中,在1500个文本文件中,一个一个列在另一个下。我发现了一个代码,它只接受一个txt文件,但将所有数据复制到行中。任何帮助都将不胜感激。 这是我的代码:
import csv
import xlwt
import os
import sys
# Look for input file in same location as script file:
inputfilename = os.path.join(os.path.dirname(sys.argv[0]),
'C:/path/filename.txt')
# Strip off the path
basefilename = os.path.basename(inputfilename)
# Strip off the extension
basefilename_noext = os.path.splitext(basefilename)[0]
# Get the path of the input file as the target output path
targetoutputpath = os.path.dirname(inputfilename)
# Generate the output filename
outputfilename = os.path.join(targetoutputpath, basefilename_noext + '.xls')
# Create a workbook object
workbook = xlwt.Workbook()
# Add a sheet object
worksheet = workbook.add_sheet(basefilename_noext, cell_overwrite_ok=True)
# Get a CSV reader object set up for reading the input file with tab
delimiters
datareader = csv.reader(open(inputfilename, 'rb'),
delimiter='\t', quotechar='"')
# Process the file and output to Excel sheet
for rowno, row in enumerate(datareader):
for colno, colitem in enumerate(row):
worksheet.write(rowno, colno, colitem)
# Write the output file.
workbook.save(outputfilename)
# Open it via the operating system (will only work on Windows)
# On Linux/Unix you would use subprocess.Popen(['xdg-open', filename])
os.startfile(outputfilename)
您首先需要将所有需要的文本文件放在当前文件夹中,
glob.glob('*.txt')
可用于获取这些文件名的列表。对于每个文本文件,使用readlines()
读取文件,并使用itemgetter()
提取所需的行。对于每个文件,在输出工作表中创建一个新行,并将每一行写入不同的列条目。在相关问题 更多 >
编程相关推荐