python打印后结果粘贴到excel并分列好

python运行结果：
[(1, 2, 3, 4, 5, 6), (1, 2, 3, 4, 5, 7), (1, 2, 3, 4, 5, 8), (1, 2, 3, 4, 6, 7), (1, 2, 3, 4, 6, 8), (1, 2, 3, 4, 7, 8), (1, 2, 3, 5, 6, 7), (1, 2, 3, 5, 6, 8), (1, 2, 3, 5, 7, 8), (1, 2, 3, 6, 7, 8), (1, 2, 4, 5, 6, 7), (1, 2, 4, 5, 6, 8), (1, 2, 4, 5, 7, 8), (1, 2, 4, 6, 7, 8), (1, 2, 5, 6, 7, 8), (1, 3, 4, 5, 6, 7), (1, 3, 4, 5, 6, 8), (1, 3, 4, 5, 7, 8), (1, 3, 4, 6, 7, 8), (1, 3, 5, 6, 7, 8), (1, 4, 5, 6, 7, 8), (2, 3, 4, 5, 6, 7), (2, 3, 4, 5, 6, 8), (2, 3, 4, 5, 7, 8), (2, 3, 4, 6, 7, 8), (2, 3, 5, 6, 7, 8), (2, 4, 5, 6, 7, 8), (3, 4, 5, 6, 7, 8)]
大量数据的话怎么样复制到excel中按照一列排序好
例如这样：
1, 2, 3, 4, 5, 6
1, 2, 3, 4, 5, 7
1, 2, 3, 4, 5, 8
1, 2, 3, 4, 6, 7

img

看我这篇博客怎么写入excel，http://t.csdn.cn/gk7TI

直接调用模块，通过代码可以写到Excel里面，

1、可以用pandas直接操作
2、可以将运行结果写入文本，用Excel 直接读取

  我的python 环境没成功pip install pandas ，用csv文本做个示例——

  • 代码运行效果截屏图片

    img

保存的csv文本内容

img

  • 代码
#!/sur/bin/nve python
# coding: utf-8


lis = [(1,2,3,4,5,6),(1,2,3,4,5,7),(1,2,3,4,5,8),(1,2,3,4,6,7),(1,2,3,4,6,8),(1,2,3,4,7,8),(1,2,3,5, 6,7),(1,2,3,5,6,8),(1,2,3,5,7, 8),(1,2,3,6,7,8),(1,2,4,5,6,7),(1,2,4,5,6,8),(1,2,4,5,7,8),(1,2,4,6,7,8),(1,2,5,6,7,8),(1,3, 4,5,6,7),(1,3,4,5,6,8),(1,3,4,5,7,8),(1,3,4,6,7,8),(1,3,5,6,7,8),(1,4,5,6, 7,8),(2,3,4,5,6,7),(2,3,4,5,6,8),(2,3,4,5,7,8),(2,3,4,6,7,8),(2,3,5,6,7,8),(2,4,5,6,7,8),(3, 4,5,6,7,8)]
path = '/sdcard/Documents/'
filename = f"{path}array.txt"
with open(filename, 'w') as f:
    f.write('Array\n') # 写入列名。
    
    for line in lis: # 循环写入数据。
        line = ','.join(map(str, line))
        f.write(line + '\n')
        print(line) 

print(f"\n{' 数据已成功写入csv文本文件：':~^29}\n{filename:^41}")