Python pyexcelerate库将多个工作表写入同一个工作簿？

I am trying to write multiple sheets into one workbook and I'm using pyexcelerate to utilize it's optimized writing time.

我正在尝试将多个工作表写入一个工作簿，并且我正在使用pyexcelerate来利用它的优化写入时间。

Here's my current code to write to a workbook:

这是我写入工作簿的当前代码：

def df_to_excel(df, path, sheet_name='Sheet 1'):
    data = [df.columns.tolist(), ] + df.values.tolist()
    wb = Workbook()
    wb.new_sheet(sheet_name, data=data)
    wb.save(path)

now this works perfectly fine if i only need one sheet; however, if i write in multiple sheet, only the last sheet will be kept (all sheets generated before will be replaced).

现在，如果我只需要一张纸，这完全没问题。但是，如果我在多张纸上书写，则只保留最后一张纸（之前生成的所有纸张都将被替换）。

I want to keep all the sheets (with diff names ofc), and I looked into their github page, but I cannot find info on such capability: https://github.com/kz26/PyExcelerate

我想保留所有的工作表（使用diff名称为c），我查看了他们的github页面，但我找不到有关此类功能的信息：https：//github.com/kz26/PyExcelerate

I also looked into a few other stackoverflow posts but they are using different packages:

我还查看了一些其他stackoverflow帖子，但他们使用不同的包：

Writing resutls into 2 different sheets in the same Excel file
在同一个Excel文件中将resutls写入2个不同的工作表
xlwt create dynamic number of worksheets based on input
xlwt根据输入创建动态数量的工作表
creating multiple excel worksheets using data in a pandas dataframe
使用pandas数据框中的数据创建多个excel工作表

any help is appreciated!

任何帮助表示赞赏！

1 个解决方案

#1

If you want to save different variable in different sheet of one excel file faster and also want header and index of the pandas.dataframe in the excel file. You can do something as follows,

如果要更快地将不同的变量保存在一个excel文件的不同表中，并且还需要excel文件中pandas.dataframe的标题和索引。你可以做如下的事情，

    import timeit
    from pyexcelerate import Workbook

    def to_Excel(data, fileName):
        start_time = timeit.default_timer()
        wb = Workbook()
        for key in data.keys():
            ws = wb.new_sheet(key)
            frame = data[key]
            frame = frame.transpose()
            frame.reset_index(level=0, inplace = True)
            frame = frame.transpose()
            frame.reset_index(level=0, inplace = True)
            row_num = frame.shape[0]    
            col_num = 1
            for col_name, col_series in frame.iteritems():
                ws.range((1,col_num), (row_num,col_num)).value = [[x] for x in col_series]
                col_num += 1       
        wb.save(fileName)
        end_time = timeit.default_timer()
        delta = round(end_time-start_time,2)
        print("Took "+str(delta)+" secs")

'data' is a dictionary variable. The 'key' of 'data' works as 'sheet name' and data type of each key value should be in pandas dataframe.

'data'是一个字典变量。 'data'的'key'作为'sheet name'，每个键值的数据类型应该在pandas数据帧中。

1 个解决方案

#1

更多相关文章

随机推荐