How to insert data into Excel file with Python and xlrd module?

Question

I try to insert value into Excel files with Python and xlrd module as follow:

import xlrd
data=xlrd.open_workbook('1.xls')       
table=data.sheets()[0]
row = 0
col = 0
ctype = 1 # 类型 0 empty,1 string, 2 number, 3 date, 4 boolean, 5 error
value = 'abc'
xf = 0 # 扩展的格式化 (默认是0)
table.put_cell(row, col, ctype, value, xf)

but no new data 'abc' in the Excel file. So anyone helps? Thanks ahead.

Have a look at stackoverflow.com/questions/2725852/…

George
– George

2013-05-17 11:48:42 +00:00
Commented May 17, 2013 at 11:48 — George
– George, Commented May 17, 2013 at 11:48

Ignacio Vazquez-Abrams · Accepted Answer · 2013-05-17 11:15:20Z

3

xlrd is for reading. You need xlwt if you want to write.

answered May 17, 2013 at 11:15

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Baoqger Bao Over a year ago

I just find this point about xlwt. Now I can use xlwt to insert data into a new Excel file, but how to insert data into an exiting file? Still need more suggestion. Thanks a lot.

Collectives™ on Stack Overflow

How to insert data into Excel file with Python and xlrd module?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related