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:")