读取excel内容并写入文件

#!/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)