python写excel文件不覆盖_python 3 往Excel 中的写入内容但不覆盖原内容

#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]