#!/usr/bin/env python
# coding:utf-8
#处理中文字符的情况
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
import xlrd
def read(filename, sheetNo=0):
book=xlrd.open_workbook(filename)
sh=book.sheet_by_index(sheetNo)
cols = sh.ncols
rows = sh.nrows
print 'cols=',cols, 'rows=',rows
resultStr = ''
for r in range(rows): # cols and rows start from 0
key = sh.cell_value(rowx=r,colx=0)
key = key.replace('"', '\\"')
value = sh.cell_value(rowx=r,colx=1)
value = value.replace('"', '\\"')
# print '\"%s\"=\"%s\";' %(key,value)
rowStr = '\"%s\"=\"%s\";\n' %(key,value)
resultStr = resultStr + rowStr
# '/Users/le.xin/Desktop/apptrans.strings'
f = open('/Users/le.xin/Desktop/apptrans.strings','w')
# print resultStr
f.write(resultStr)
f.close()
print "保存成功"
read("app.xlsx",0)
网友评论