Python导出Excel为Lua/Json/Xml实例教程（三）：终极需求
# -*- coding: UTF-8 -*-# Author:Krisik
# 博客地址:http://www.cnblogs.com/krisirk/
import xlrd
fileOutput = open('Configs.lua','w')
# 让py可以读取文件中的中文
import sys
reload(sys)
sys.setdefaultencoding("utf-8")
# 可以在这里写一些固定的注释代码之类的
writeData = "-- @author:kris\n\n\n"
workbook = xlrd.open_workbook('Configs.xls')
print "There are {} sheets in the workbook".format(workbook.nsheets)
for booksheet in workbook.sheets():
# print "Current Booksheet:[" + booksheet.name + "]"
writeData = writeData + 'AT' + booksheet.name + ' = {\n'
# 处理id和index的特殊行
writeData = writeData + '\t' + 'keys' + ' = ' + '{ '
for row in xrange(booksheet.nrows):
ifrow
页:
[1]