#!/usr/bin/env python
import sys
import xml.sax
dtt = True
if dtt:
sepstring = "\t"
dquote = ''
else:
sepstring = ","
dquote = '"'
class XlsXmlHandler(xml.sax.handler.ContentHandler):
def startElement(self, name, attrs):
if name == "worksheet":
if "name" in attrs:
print("%s" % attrs["name"].encode("UTF-8"))
elif name == "row":
self.cells = dict()
elif name == "label-cell" or name == "number-cell":
if "value" in attrs:
value = attrs["value"].encode("UTF-8")
else:
value = unicode()
if "col" in attrs:
self.cells[int(attrs["col"])] = value
else:
#??
sys.stdout.write("%s%s"%(value.encode("UTF-8"),sepstring))
elif name == "formula-cell":
if "formula-result" in attrs and "col" in attrs:
self.cells[int(attrs["col"])] = \
attrs["formula-result"].encode("UTF-8")
def endElement(self, name, ):
if name == "row":
curidx = 0
for idx, value in self.cells.iteritems():
sys.stdout.write(sepstring * (idx - curidx))
sys.stdout.write('%s%s%s' % (dquote, value, dquote))
curidx = idx
sys.stdout.write("\n")
elif name == "worksheet":
print("")
try:
xml.sax.parse(sys.stdin, XlsXmlHandler())
except:
sys.exit(1)
sys.exit(0)