#coding=utf-8
import os
import sys
import xlrd #pip install xlrd
from xlrd import xldate_as_tuple
import json
import time
from datetime import datetime
reload(sys)
sys.setdefaultencoding('utf8')
reload(sys)
excelFile = sys.argv[1]
workbook = xlrd.open_workbook(excelFile)
sheet_names = workbook.sheet_names()
#for sheet_name in sheet_names:
sheet_name = "Data"
sheet1 = workbook.sheet_by_name(sheet_name)
nrows = sheet1.nrows;
str = "行数:{0}".format(nrows)
print(str)
row0 = sheet1.row_values(0) #读取第0行
print(row0)
print(row0[4]) #读取第0行 第4列的单元格值
#写excel的操作
import xlwt #用pip install xlwt安装
wbk = xlwt.Workbook(encoding="utf-8", style_compression=0)
sheet = wbk.add_sheet("sheet 1", cell_overwrite_ok=True)#单元格是否可以多次赋值
sheet.write(0,0,"hello world");
value ="你好世界".decode("gbk") #需要转换一下,否则执行时中文报错
sheet.write(0,1,value)
#sheet.write(0,1,"你好世界")
style = xlwt.XFStyle()
font = xlwt.Font()
font.name="微软雅黑"
font.blod = True
style.font = font
sheet.write(0,2, "设置了字体的文字".decode("gbk"))
wbk.save("1.xls")
编码中print输出的中文显示unicode编码值的解决方法:
在文件头加上:#coding=utf-8,将文件保存为ascii编码格式;