How to use xlutils class library to implement append writing function in python excel

This article mainly introduces the method of using the xlutils class library to implement the append writing function in python excel. It has a certain reference value. Now I share it with you. Friends in need can refer to it.

Due to the recent writing I submitted a summary and excel version of my work report and found that handwriting was too troublesome. I wanted to write a code to automatically read all the content in a text and write it to the corresponding excel and summary automatically as required.

So I looked for python. Class library, I found a lot of small problems. Share it with everyone. If it helps you, please like it. Thank you

If you add the python xlrd module to copy and read exlce xlwt, you will be responsible for writing it, but you find that if you use xlwt After writing, the format is gone, and additional writing cannot be done.

Then you need to use the xlutils module

1. To copy excel with format

from xlutils.copy import copy
try:

 if not os.path.exists(goal_file) and os.path.exists(model_src) :
 shutil.copy(model_src,goal_file)
 print '复制模版成功'
except Exception ,e:
 print "模版文件复制失败"
 pass

It’s very simple. The key code only has one sentence: copy a template file. In the future, I will use the copied file for additional writing operations

#使用 formatting_info=True 来复制带有格式的excel,否则追加写后格式会丢失
rb = xlrd.open_workbook(goal_file,formatting_info=True) 
#通过sheet_by_index()获取的sheet没有write()方法
rs = rb.sheet_by_index(0) 
wb = copy(rb)
#通过get_sheet()获取的sheet有write()方法
ws = wb.get_sheet(0)
#获得到sheet了 可以进行 追加写 或者 修改某个单元格数据的操作了 最后不要忘了 save()

wb.save(goal_file)

Pay special attention here if the copied template has the xls suffix instead of xlsx Otherwise, an exception will be thrown. xlrd is not supported after version 0.8. I googled it and it seems like this, so the template must be in xls format

and be careful not to manually open the xls file to modify the values ​​inside, otherwise the script will be executed. Finally, the save() sentence will throw an exception. I have tried it many times. I hope someone can give me some advice.

Pay attention to these two points and you can complete it by appending it.

Related recommendations:

Example explanation of python practical implementation of excel reading, statistics, and writing

Python implementation of adding a new row at the end of Excel

The above is the detailed content of How to use xlutils class library to implement append writing function in python excel. For more information, please follow other related articles on the PHP Chinese website!