python excel文件的append data (不覆盖之添加操作)

1. 测试代码

#coding=utf-8

import xlwt
import xlrd
import xlutils.copy

#################################################################################
# Create a new sheet1
#workbook = xlwt.Workbook()
#sheet1 = workbook.add_sheet('sheet1',cell_overwrite_ok=True)

# Write something into the sheet1
#sheet1.write(0,0,'connected IP')
#sheet1.write(0,1,'Addr IPV4 IP(s)')

# save excel file
#workbook.save('C:\\Users\\32065\\Desktop\\Net\\simulation\\excel\\test.xls')
#print 'create excel file successfully!'

################################################################################
rb = xlrd.open_workbook('C:\\Users\\32065\\Desktop\\Net\\simulation\\excel\\test.xls')
wb = xlutils.copy.copy(rb)
#获取sheet对象，通过sheet_by_index()获取的sheet对象没有write()方法
ws = wb.get_sheet(0)
#写入数据
ws.write(0, 1, 'changed!')
ws.write(1, 0, '10-changed!')
ws.write(2, 0, '20-changed!')
#添加sheet页
# wb.add_sheet('sheetnnn2',cell_overwrite_ok=True)
#利用保存时同名覆盖达到修改excel文件的目的,注意未被修改的内容保持不变
wb.save('C:\\Users\\32065\\Desktop\\Net\\simulation\\excel\\test.xls')


##############################################################################

# read the excel file
data = xlrd.open_workbook('C:\\Users\\32065\\Desktop\\Net\\simulation\\excel\\test.xls')
table = data.sheets()[0] # open the first sheet
nrows = table.nrows # not-null rows
print nrows
for i in range(nrows): # print by rows
    if i == 0: # 跳过第一行
        continue
    print table.row_values(i)[0:2]

参考

1. http://blog.csdn.net/canhui_wang/article/details/78662742
2. http://blog.csdn.net/canhui_wang/article/details/78704688