<em>python</em> excel怎么中文文件名-python 保存为excel,exc

# 需安装 xlrd-0.9.2 和 xlutils-1.7.1 这两个模e799bee5baa6e79fa5e98193e59b9ee7ad94361块
from xlwt import Workbook, Formula
import xlrd
book = Workbook()
sheet1 = book.add_sheet('Sheet 1')
sheet1.write(0,0,10)
sheet1.write(0,1,20)
sheet1.write(1,0,Formula('A1/B1'))
sheet2 = book.add_sheet('Sheet 2')
row = sheet2.row(0)
row.write(0,Formula('sum(1,2,3)'))
row.write(1,Formula('SuM(1;2;3)'))
row.write(2,Formula("$A$1+$B$1*SUM('ShEEt 1'!$A$1:$b$2)"))
book.save('formula.xls')
book = xlrd.open_workbook('formula.xls')
sheet = book.sheets()[0]
nrows=sheet.nrows
ncols=sheet.ncols
for i in range(nrows):
for j in range(ncols):
print (sheet.cell(i,j).value)

#需要将中文路径名decode为utf-8，不然url读不zd出来
file = file_path.decode('utf-8')
#file = 'D:\XXX\中文专名.xlsx'.decode('utf-8')
try:
workbook = xlrd.open_workbook(file)
#所有sheet页的名称，通过属这个可以计算一共多少sheet
worksheets = workbook.sheet_names()
#sheet列表
sheet_num = worksheets
pro = excel_table_byindex(workbook, sheet_num)
except Exception,e:
print str(e)
http://blog.csdn.net/ensoleilly/article/details/25409483

filepath=unicode(filepath,'utf8')
fobj=open(filepath,"r")