xlsxwriter 创建多个Excel文件

xlsxwriter 模块如何创建多个Excel文件，先读取先筛选符合要求的Excel文件并将筛选出的Excel文件存到新的Excel文件中，筛选出几个就创建几个，但是现在卡在创建多个Excel文件了 客户那边只让用xlsxwriter模块

首先，使用xlsxwriter模块读取原始Excel文件：

import xlsxwriter

# open the existing file
workbook = xlsxwriter.Workbook('original_file.xlsx')
worksheet = workbook.add_worksheet()

然后，使用xlsxwriter模块的函数对excel文件进行筛选：

# Do some filtering
for row in range(worksheet.nrows):
    # get the cell value to check against conditions
    cell_value = worksheet.cell(row, 0).value 
    
    # filter out certain values
    if cell_value == "start":
        # remember row position
        start_row = row
    elif cell_value == "end":
        # remember row position
        end_row = row
        
# process data according to the filters
processed_data = worksheet.row_slice(start_row, end_row)

最后，将处理过的数据写入新创建的Excel文件：

# create new workbook for each filtered file
new_workbook = xlsxwriter.Workbook("filtered_file.xlsx")

# add new worksheet to the new workbook
new_worksheet = new_workbook.add_worksheet()

# and write the processed_data
for row in range(len(processed_data):
    for col in range(len(processed_data[row])):
        new_worksheet.write(row, col, processed_data[row][col])

如果需要创建多个Excel文件，可以使用循环来重复上述操作：

# iterate over a list of files
for filename in file_list:
    # open the existing file
    workbook = xlsxwriter.Workbook(filename)
    worksheet = workbook.add_worksheet()
    
    # Do some filtering...

    # create new workbook for each filtered file
    new_workbook = xlsxwriter.Workbook("filtered_" + filename)

    # add new worksheet to the new workbook
    new_worksheet = new_workbook.add_worksheet()

    # and write the processed_data
    for row in range(len(processed_data):
        for col in range(len(processed_data[row])):
            new_worksheet.write(row, col, processed_data[row][col])

• 这篇博客也许可以解决你的问题👉 ：利用xlsxwriter，对excel进行条件输出

问题解决了吗？xlxs文件有多少个

以下答案引用自GPT-3大模型,请合理使用：

可以使用XlsxWriter模块实现创建多个Excel文件的需求，如下代码所示：

# 导入XlsxWriter模块
import xlsxwriter
 
# 创建workbook
workbook = xlsxwriter.Workbook('multi-files.xlsx')
 
# 按照文件名创建worksheet
worksheet1 = workbook.add_worksheet('Sheet1')
worksheet2 = workbook.add_worksheet('Sheet2')
worksheet3 = workbook.add_worksheet('Sheet3')
 
# 写入数据
worksheet1.write('A1', 'Hello')
worksheet1.write('A2', 'world!')
 
worksheet2.write('A1', 'Hello')
worksheet2.write('A2', 'excel!')
 
worksheet3.write('A1', 'Hello')
worksheet3.write('A2', 'xlsxwrtier!')
 
# 保存workbook
workbook.close()

如果我的回答解决了您的问题，请采纳我的回答