New table

Simple example
Create a simple spreadsheet class.

SodsSpreadSheet - simple spreadsheet class

  • Set cells - string, float, date and functions
  • Ses cell styles - color, background, font and borders
  • Calculate formula cells values
  • Calculate conditional styles
  • Import xml and ods table files
  • Export xml, html, ods, xls, xlsx and csv files

from simpleodspy.sodsspreadsheet import SodsSpreadSheet
from simpleodspy.sodcsv import SodsCsv
from simpleodspy.sodsxml import SodsXml
from simpleodspy.sodshtml import SodsHtml
 
t = SodsSpreadSheet()
t.setValue("A1", "Hello world")
 
tw = SodsCsv(t)
tw.save("test.csv")
tw = SodsXml(t)
tw.save("test.xml")
tw = SodsHtml(t)
tw.save("test.html")

Simple example with none default size

Set the size of columns and rows in a new table:
SodsSpreadSheet(rows, columns)
default value is 30 rows by 30 columns

from simpleodspy.sodsspreadsheet import SodsSpreadSheet
from simpleodspy.sodcsv import SodsCsv
from simpleodspy.sodsxml import SodsXml
from simpleodspy.sodshtml import SodsHtml
 
t = SodsSpreadSheet(3, 8)
t.setValue("A1", "Hello world")
 
tw = SodsCsv(t)
tw.save("test.csv")
tw = SodsXml(t)
tw.save("test.xml")
tw = SodsHtml(t)
tw.save("test.html")