python writes existing excel data instance

The following is an example of writing existing excel data in python. It has a good reference value and I hope it will be helpful to everyone. Let’s take a look together

Python can use xlrd to read excel and xlwt to write excel, but if you want to write data to existing excel, you need another library xlutils to use together.

General idea:

1. Use xlrd.open_workbook to open the existing xsl file

Pay attention to adding the parameter formatting_info=True to save the previous data Format

2. Then use from xlutils.copy import copy;, and then copy to copy a copy from the opened xlrd Book variable to become the new xlwt Workbook variable

3. Then for the Workbook variable of xlwt, it is normal:

Get the corresponding sheet through get_sheet. After getting the sheet variable, you can write new data into the sheet

4. After writing the new data, finally save

Source code example:

import xlrd
import os
from xlutils.copy import copy
from xlwt import Style

def writeExcel(row, col, str, styl=Style.default_style):
 rb = xlrd.open_workbook(file, formatting_info=True)
 wb = copy(rb)
 ws = wb.get_sheet(0)
 ws.write(row, col, str, styl)
 wb.save(file)

style = xlwt.easyxf('font:height 240, color-index red, bold on;align: wrap on, vert centre, horiz center');
writeExcel(1, 1, 'hello world', style)

If you need the original format of excel, you need to add parameters

formatting_info=True

If you need to add excel style, just pass the style string to xlwt.easyxf

Merge cells:

ws.write_merge(top_row, bottom_row, left_column, right_column, string)

Related recommendations:

Python changes have been Methods for existing excel files

Python solves the problem of exceptions thrown when writing Chinese to Excel

Example of python exporting data to excel

The above is the detailed content of python writes existing excel data instance. For more information, please follow other related articles on the PHP Chinese website!