这里拿的是passwd作为测试文件。后期优化一下可以通过交互灵活导出数据到excle表格
没有模块的可以这样
pip3 install xlwt
代码如下
#!/usr/local/bin/python3
import xlwt
import sys
def file_to_xls(sour_file, dest_file):
mk_table = xlwt.Workbook()
mk_sheel = mk_table.add_sheet('passwd')
mk_sheel.write(0, 0, 'username')
mk_sheel.write(0, 1, 'password')
mk_sheel.write(0, 2, 'uid')
mk_sheel.write(0, 3, 'gid')
mk_sheel.write(0, 4, 'comment')
mk_sheel.write(0, 5, 'homedir')
mk_sheel.write(0, 6, 'shell')
fobj = open(sour_file)
row_num = 1
for line in fobj:
data = line.strip('\n').split(':')
mk_sheel.write(row_num, 0, data[0])
mk_sheel.write(row_num, 1, data[1])
mk_sheel.write(row_num, 2, data[2])
mk_sheel.write(row_num, 3, data[3])
mk_sheel.write(row_num, 4, data[4])
mk_sheel.write(row_num, 5, data[5])
mk_sheel.write(row_num, 6, data[6])
row_num += 1
mk_table.save(dest_file)
if __name__ == '__main__':
file_to_xls(sys.argv[1], sys.argv[2])
使用方法:
python3 xxxxx.py sour_file dest_file