如何将多Excel工作簿与多个工作表相结合到单个工作簿中

发布于 2025-01-21 07:43:21 字数 439 浏览 4 评论 0原文

我有3个带有单张纸的工作库。我需要将所有工作簿与3张床单相结合。

我尝试了以下代码：

from pandas import ExcelWriter

writer = ExcelWriter("Sample.xlsx")

for filename in glob.glob("*.xlsx"):
    df_excel = pd.read_excel(filename,engine='openpyxl')

    (_, f_name) = os.path.split(filename)
    (f_short_name, _) = os.path.splitext(f_name)

    df_excel.to_excel(writer, f_short_name, index=False)

writer.save()

我遇到了一个错误，例如“文件不是zip文件”

原文

I have 3 workboooks with single sheets.I need to combine all workbooks into single workbook with 3 sheets.

I tried the below code :

from pandas import ExcelWriter

writer = ExcelWriter("Sample.xlsx")

for filename in glob.glob("*.xlsx"):
    df_excel = pd.read_excel(filename,engine='openpyxl')

    (_, f_name) = os.path.split(filename)
    (f_short_name, _) = os.path.splitext(f_name)

    df_excel.to_excel(writer, f_short_name, index=False)

writer.save()

i got an error like "File is not zip File"

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

╰沐子 2025-01-28 07:43:21

“ sample.xlsx”是在与输入工作簿相同的目录中创建的，然后在使用glob.glob（“*。xlsx”）查找所有文件之前。因此，您尝试读取您的作家的“ sample.xlsx”。这不起作用。

确保仅迭代真实的输入工作簿，例如这样：

import pandas as pd
from pandas import ExcelWriter
import glob
import os

writer = ExcelWriter("Sample.xlsx")
input_workbooks = glob.glob("*.xlsx")
input_workbooks.remove("Sample.xlsx")

for filename in input_workbooks:
    df_excel = pd.read_excel(filename,engine='openpyxl')

    (_, f_name) = os.path.split(filename)
    (f_short_name, _) = os.path.splitext(f_name)

    df_excel.to_excel(writer, f_short_name, index=False)

writer.save()

更好的是将输出工作簿（“ sample.xlsx”）保存到另一个目录中，以避免混淆。显然，当您这样做时，您将无法再从列表中删除它，因此只需删除该行：input_workbooks.remove（“ sample.xlsx”）

"Sample.xlsx" is created in the same directory as the input workbooks and before you look for all files with glob.glob("*.xlsx"). Therefore you try to read "Sample.xlsx" which is your writer. This isn't working.

Make sure to only iterate over the real input workbooks e.g. like that:

import pandas as pd
from pandas import ExcelWriter
import glob
import os

writer = ExcelWriter("Sample.xlsx")
input_workbooks = glob.glob("*.xlsx")
input_workbooks.remove("Sample.xlsx")

for filename in input_workbooks:
    df_excel = pd.read_excel(filename,engine='openpyxl')

    (_, f_name) = os.path.split(filename)
    (f_short_name, _) = os.path.splitext(f_name)

    df_excel.to_excel(writer, f_short_name, index=False)

writer.save()

Better would be to save the output workbook ("Sample.xlsx") to another directory to avoid confusion. Obviously, when you do that, you do can not remove it from the list any longer, so just delete the line: input_workbooks.remove("Sample.xlsx")

回复收藏 0 原文

~没有更多了~