python 追加写入到excel_xlrd open oss bucket-CSDN博客

本文链接：https://blog.csdn.net/persistencequxi/article/details/78934774

本文介绍了一个Python程序，该程序可以实现在现有Excel文件中追加写入数据，并将更新后的文件上传到阿里云OSS存储服务。程序首先检查文件是否存在并创建表头，然后追加数据并将文件保存到指定路径。最后使用阿里云SDK将文件上传到OSS。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

# -*- coding: utf-8 -*-
from xlwt import *
import os
import oss2
from xlrd import open_workbook
from xlutils.copy import copy
import datetime
import random
import sys
import traceback


PREFIX = 'http://'

class cexport_excel():

    """excel追加写入"""
    # excheader表头
    # datasrcset  二维元祖
    # path = 'hh.xls'
    def export_excel(self,path,excname,excheader,datasrcset,username, ossinfo,urlload):
        result = {}
        try:
            # 写头
            if not os.path.exists(path):
                w = Workbook()
                sheet = w.add_sheet(excname)
                headercol = 0
                for header in excheader:
                    sheet.write(0, headercol, str(header).decode('utf-8'))
                    headercol += 1
                w.save(path)

            # 追加写入excel
            rexcel = open_workbook(path)
            rows = rexcel.sheets()[0].nrows
            excel = copy(rexcel)
            table = excel.get_sheet(0)
            newrow = rows
            for i, row in enumerate(datasrcset):
                for j, col in enumerate(row):
                    table.write(newrow, j, col)  # datasrcset
                newrow += 1
            excel.save(path)

            osspath = username + '_' + datetime.now().strftime('%Y%m%d%H%M%S') + '_' + str(random.randint(0, 99)) + '.xls'
            auth = oss2.Auth(ossinfo['ACCESS_KEY_ID'], ossinfo['ACCESS_KEY_SECRET'])
            bucket = oss2.Bucket(auth, ossinfo['ENDPOINT_OUT'], ossinfo['BUCKETNAME_XLS'])
            bucket.put_object('%s/%s' % (urlload, osspath), open(path))
            result['osspath'] = PREFIX + ossinfo['BUCKETNAME_XLS'] + '.' + ossinfo['ENDPOINT_OUT'] + '/' + urlload + '/' + osspath
            result['errorcode'] = 0
            return result
        except Exception as ex:
            result['errorcode'] = -1
            result['errortext'] = '%s:Exception = %s ex=%s  __LINE__=%s' % (traceback.print_exc(), Exception, ex, sys._getframe().f_lineno)
            return result