Why use xlrd and xlwt in python to manipulate excel

The basic operations of Python on Excel are as follows:

# -*coding: utf-8 -*

import xlrd

import xlwt

from datetime import date,datetimedef read_excel():

Open the file.

workbook = 'f:\')

Get all sheets

print # [u'sheet1', u'sheet2']sheet2_name =

Obtain the content of a sheet based on the index or name of the sheet.

sheet2 = sheet index starts at 0.

sheet2 = 'sheet2')

The name of the sheet, the number of rows, the number of columns.

print to get the values (arrays) of entire rows and columns

rows = get the content of the fourth row.

cols = Get the third column content.

print rows

print cols

Get cell contents.

print ,0).'utf-8')

print ,0).encode('utf-8')print 'utf-8')

Get the data type of the cell contents.

print ,0).ctype

if __name__ == '__main__':

read_excel()

So what do you want to do with it.

I'll give you an example. To use this, you only need to learn an example.

import xlutils,xlrd,xlwtimport os,glob,re,traceback,sys,time

from xlrd import open_workbookfrom import copy

def read_from_xlsx(fn_xlsx):

lists =

try:wb =

except:

print u'The file does not exist, or it cannot be opened, please close excel:',fn_xlsx

return nonesh =

for rownum in range(:

cols =

cols = [unicode(c).strip() for c in cols]

The key to this is row values.

You can also find examples on the website**.

-*coding: utf-8 -* import xlwt module import xlwt Create a workbook object, which is equivalent to creating an excel file book ='utf-8', style_compression=0)'''When the workbook class is initialized, there are encoding and style compression parameters encoding: to set the character encoding, which is usually set like this

w = workbook(encoding='utf-8'), you can output Chinese in excel. The default is ASCII. Of course, remember to add :

#!/usr/bin/env python# -*coding: utf-8 -*style_compression:

Indicates whether compression is performed or not, which is not commonly used. '''Create a sheet object, and one sheet object corresponds to a ** in the excel file. Right-click on the computer desktop to create a new excel file, which contains sheet1, sheet2, sheet3 three sheets sheet ='test', cell overwrite ok=true) where test is the name of the table, cell overwrite ok, indicating whether the cell can be overwritten, is actually a parameter instantiated by worksheet, the default value is false to add data to the table test, 0,'englishname'Among them'0-row, 0-column'Specify the cells in the table'englishname'is what is written to the cell, 0,'marcovaldo')txt1 = 'Chinese name', 1, 'utf-8'Here you need to decode the Chinese string into unicode code, otherwise the error txt2 = will be reported'Marcovaldo', 1, 'utf-8'Finally, save the above operations to the specified excel file'e:

Prefix the string with r to declare it as a raw string so that the escape in it is not handled. Otherwise, an error may be reported.

You need to define the font and style

e.g. font=

times new roman'

truestyle =

font 0, value,style)

I haven't used the module you're talking about, but I can tell you that

The new versions of docx, xlsx, and xls all use xml to control style content

If you don't believe me, change the extension name to zip and unzip it