--- a/src/filters/xlsxmltocsv.py
+++ b/src/filters/xlsxmltocsv.py
@@ -32,20 +32,20 @@
dtt = True
if dtt:
- sepstring = "\t"
- dquote = ''
+ sepstring = b"\t"
+ dquote = b""
else:
- sepstring = ","
- dquote = '"'
-
+ sepstring = b","
+ dquote = b'"'
+
class XlsXmlHandler(xml.sax.handler.ContentHandler):
def __init__(self):
- self.output = ""
+ self.output = b''
def startElement(self, name, attrs):
if name == "worksheet":
if "name" in attrs:
- self.output += "%s\n" % attrs["name"].encode("UTF-8")
+ self.output += b"%s\n" % attrs["name"].encode("UTF-8")
elif name == "row":
self.cells = dict()
elif name == "label-cell" or name == "number-cell":
@@ -57,7 +57,7 @@
self.cells[int(attrs["col"])] = value
else:
#??
- self.output += "%s%s" % (value.encode("UTF-8"), sepstring)
+ self.output += b"%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"])] = \
@@ -68,11 +68,11 @@
curidx = 0
for idx, value in self.cells.items():
self.output += sepstring * (idx - curidx)
- self.output += "%s%s%s" % (dquote, value, dquote)
+ self.output += b"%s%s%s" % (dquote, value, dquote)
curidx = idx
- self.output += "\n"
+ self.output += b"\n"
elif name == "worksheet":
- self.output += "\n"
+ self.output += b"\n"
if __name__ == '__main__':