excel to [objs]

import os
import sys
import codecs
import xlrd
if len(sys.argv) != 2 :
print “argv count != 2, program exit”
print “USAGE: a.py excelfilename”
exit(0)
print “excel to json”
excelFileName = sys.argv[1]
def FloatToString (aFloat):
if type(aFloat) != float:
return “”
strTemp = str(aFloat)
strList = strTemp.split(“.”)
if len(strList) == 1 :
return strTemp
else:
if strList[1] == “0” :
return strList[0]
else:
return strTemp

def table2jsn(table, jsonfilename):
nrows = table.nrows
ncols = table.ncols
f = codecs.open(jsonfilename,”w”,”utf-8″)
f.write(u”[\n”)
for r in range(nrows-1):
if r == 0:
continue
f.write(u”\t{ “)
for c in range(ncols):
strCellValue = u””
CellObj = table.cell_value(r+1,c)
if type(CellObj) == unicode:
strCellValue = CellObj
elif type(CellObj) == float:
strCellValue = FloatToString(CellObj)
else:
strCellValue = str(CellObj)
strTmp = u”\”” + table.cell_value(1,c) + u”\”:\””+ strCellValue+u”\””
if c< ncols-1:
strTmp += u”, “
f.write(strTmp)
f.write(u” }”)
if r < nrows-2:
f.write(u”,”)
f.write(u”\n”)
f.write(u”]\n”)
f.close()
print “Create “,jsonfilename,” OK”
return

data = xlrd.open_workbook(excelFileName)
table = data.sheet_by_name(u”tablelist”)
rs = table.nrows
for r in range(rs-1):
print table.cell_value(r+1,0), “==>”, table.cell_value(r+1,2)
desttable = data.sheet_by_name(table.cell_value(r+1,0))
destfilename = table.cell_value(r+1,2)
table2jsn(desttable,destfilename)

print “All OK”