python excel写入加前缀_python excel写入及追加写入

你的名字 2022-10-22 11:49 239阅读 0赞

\# -\*- coding:utf-8 \_\*-

"""

@author:Administrator

@file: excel.py

Description :

如果行数是1000的倍数，进行一次flush，如果行数超过65536，

新开一个sheet，如果超过3个sheet，则新建一个文件

@time: 2018/10/31

"""

import os

import xlwt

from xlrd import open\_workbook

from xlutils.copy import copy

from configs.config import ConfigENum

MAX\_ROW\_NUM = 65536

MAX\_SHEET\_NUM = 3

class XLS:

def \_\_init\_\_(self, name, captionlist: list, typelist: list, encoding='utf8', flushBound=1000):

"""

:type captionlist: list

:type typelist: list

"""

self.name = name

self.captionlist = captionlist\[:\]

self.typeList = typelist\[:\]

self.encoding = encoding

self.flushBound = flushBound

self.bk = xlwt.Workbook(encoding=self.encoding, style\_compression=0)

self.workbookIndex = 1

self.row = 0

self.excel\_name = None

self.sheet = None

self.sheetindex = 0

\# self.\_add\_sheet()

def \_add\_sheet(self):

if self.sheetindex != 0:

\# This method is used to save the Workbook to a file in native Excel format.

self.bk.save(self.name + str(self.sheetindex) + ".xls")

\# create new workbook

if self.sheetindex > MAX\_SHEET\_NUM:

self.workbookIndex += 1

self.bk = xlwt.Workbook(encoding=self.encoding, style\_compression=0)

self.sheetindex = 1

\# a new sheet

index=self.sheetindex

print("self.sheet\_index=",index)

self.sheet = self.bk.add\_sheet(self.name +

index.\_\_str\_\_(),

cell\_overwrite\_ok=False)

for i in range(len(self.captionlist)):

\# This method is used to write a cell to a :class:\`Worksheet\`

self.sheet.write(0, i, self.captionlist\[i\])

self.row = 1

def write(self, data: list):

"""

:type data: list

"""

\# The row of current sheet > the max rows of sheet then create a new sheet

if self.row > MAX\_ROW\_NUM:

self.sheetindex += 1

self.\_add\_sheet()

for i in data:

for j in range(len(i)):

if self.typeList\[j\] == "num":

try:

self.sheet.write(self.row, j, float(i\[j\]))

except:

raise ValueError("\{\} is not a number".format(i\[j\]))

else:

self.sheet.write(self.row, j, i\[j\])

\# when rows =1000 then flush rows

if self.row % self.flushBound == 0:

self.sheet.flush\_row\_data()

self.row += 1

@staticmethod

def \_\_find\_file(keyword):

for root, d, files in os.walk(ConfigENum.DATA\_PATH.value):

for file in files:

if keyword in file:

file = os.path.join(root, file)

return file

return False

def add\_write(self, datas):

result=self.\_\_find\_file(self.name)

if not result:

self.write(datas)

self.save()

return "ok"

if self.row > MAX\_ROW\_NUM:

self.sheetindex += 1

self.\_add\_sheet()

\# read a excel file

self.bk = open\_workbook(result)

\# get the rows of sheet

rows = self.bk.sheets()\[self.sheetindex\].nrows

\# Copy an :class:\`xlrd.Book\` into an :class:\`xlwt.Workbook\`

excel = copy(self.bk)

self.sheet = excel.get\_sheet(self.sheetindex)

self.row = rows

for data in datas:

\# \[1,2,3,4\]

for j in range(len(data)):

self.sheet.write(self.row, j, data\[j\]) \# xlwt对象的写方法，参数分别是行、列、值

if self.row % self.flushBound == 0:

self.sheet.flush\_row\_data()

self.row += 1

self.excel\_name = os.path.join(ConfigENum.DATA\_PATH.value,

self.name + self.workbookIndex.\_\_str\_\_() + ".xls")

excel.save(self.excel\_name)

def save(self):

self.excel\_name = os.path.join(ConfigENum.DATA\_PATH.value,

self.name + self.workbookIndex.\_\_str\_\_() + ".xls")

self.bk.save(self.excel\_name)

\# if \_\_name\_\_ == "\_\_main\_\_":

\# caption\_list = \["name", "gender", "age"\]

\# type\_list = \["str", "str", "num"\]

\# input\_data = \["Lili", "M", 25\]

\# excl=XLS("test",caption\_list,type\_list)

\# excl.write(input\_data)

\# excl.save()

python excel写入加前缀_python excel写入及追加写入

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 pandas 写入Excel

相关 Easy Excel——写入Excel

相关 python写入excel文件

相关 Python读取pdf表格写入excel

相关 Python3 读取、新建、追加写入Excel文件

相关把excel矩阵写入python_Python新手上车27: Python xlwt 写入Excel

相关 python dataframe 写入 excel

相关 python excel写入加前缀_python excel写入及追加写入

相关 python 写入 excel

相关 jxl写入excel