Python xlrd、xlwt、xlutils修改Excel文件

#!/usr/bin/env python3
#-*- coding:utf-8 -*-
'''
Administrator 
2018/8/17 
'''
# import xlrd
#
# data=xlrd.open_workbook("单县.xls")
#
# table=data.sheets()[0]
# table = data.sheet_by_index(0) #通过索引顺序获取
# table = data.sheet_by_name(u'Sheet1')#通过名称获取
# 4、获取整行和整列的值（返回数组）
#          table.row_values(i)
#          table.col_values(i)
# 5、获取行数和列数　
#         table.nrows
#         table.ncols
# 6、获取单元格
# 　　table.cell(0,0).value
#       table.cell(2,3).value
# print(table.row_values(3))
# print(table.row_values(16))
# print(table.col_values(0))

# a=table.cell(16,14).value
# a=table.cell(16,14).value
# print(a,type(a))  #2.0 <class 'float'>
from xlrd import open_workbook
from xlutils.copy import copy

data=open_workbook("new1.xlsx")
table=data.sheet_by_index(0) #得到sheet1 对象
print(table.ncols)#3列
print(table.nrows)#10行
# for i in range(table.nrows):
#     # print(i)
#     for j in range(table.nrows):
#         print(table.cell(j,i).value,end="\t")
#     print()
for i in range(table.nrows):#10行
    for j in range(table.ncols):#3列
        item=table.cell(i, j).value
        if type(item) is str:
            print("这是一个字符串%s"%item)
        else:
            print(item,type(item),end="\t")
    print()


# wb=copy(rb)# 利用xlutils.copy函数，将xlrd.Book转为xlwt.Workbook，再用xlwt模块进行存储
# #通过get_sheet()获取的sheet有write()方法
# ws = wb.get_sheet(0)
# # ws.write(0, 0, 'changed!')
# # wb.save('new2.xlsx')
# print(ws) #<xlwt.Worksheet.Worksheet object at 0x000000000A83FB00>
# row=ws.nrows
# # col=ws.ncols
# print(row)