pyexcel处理excel文件

GitHub - pyexcel/pyexcel: Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

install

pip install pyexcel pyexcel-xlsx

merge csv into xlsx

from pyexcel.cookbook import merge_all_to_a_book
import glob

merge_all_to_a_book(glob.glob("your_csv_directory/*.csv"), "output.xlsx")