tc = TableCell(valuetype="string", stylename=style_name)
# set ods text
tc.addElement(P(text=unicode(escape(c.text), "utf-8")))
tr.addElement(tc)
odfdoc.spreadsheet.addElement(table)
odfdoc.save(filename)
if __name__ == "__main__":
from sodsspreadsheet import SodsSpreadSheet
t = SodsSpreadSheet(12, 12)
print "Test spreadsheet naming:"
print "-----------------------"
t.setStyle("A1", text="שלום עולם")
t.setStyle("A1:G2", background_color="#00ff00")
t.setStyle("A3:G5", background_color="#ffff00")
t.setValue("A2", 123.4)
t.setValue("B2", "2010-01-01")
t.setValue("C2", "0.6")
t.setValue("C5", 0.6)
t.setValue("C6", 0.6)
t.setValue("C7", 0.8)
return out
def save(self, filename, i_max = None, j_max = None, delimiter = ",", txt_delimiter = '"'):
''' save table in csv format '''
# if filename is - print to stdout
if filename == '-':
print self.exportCsv(i_max, j_max, delimiter, txt_delimiter)
else:
file(filename,"w").write(self.exportCsv(i_max, j_max, delimiter, txt_delimiter))
if __name__ == "__main__":
from sodsspreadsheet import SodsSpreadSheet
t = SodsSpreadSheet()
print "Test spreadsheet naming:"
print "-----------------------"
t.setStyle("A1", text = "Simple ods python")
t.setStyle("A1:G2", background_color = "#00ff00")
t.setStyle("A3:G5", background_color = "#ffff00")
t.setValue("A2", 123.4)
t.setValue("B2", "2010-01-01")
t.setValue("C2", "=0.6")
t.setValue("D2", "= A2 + 3")
t.setStyle("A3:D3", border_top = "1pt solid #ff0000")
t.setValue("C3", "Sum of cells:")
