from simpleodspy.sodsspreadsheet import SodsSpreadSheet
t = SodsSpreadSheet(10, 10)
print("Test spreadsheet naming:")
print("-----------------------")
# setting values and formulas
t.setValue("A1", "Hello world !")
t.setValue("B2:C2", 123.4)
t.setValue("B3", "=B2+3")
t.setValue("B4", "=sum(B2:B3)")
# cell styles
t.setStyle("A1", color="#0000ff")
t.setStyle("A1:A5", background_color="#00ff00")
t.setStyle("B1:B5",
border_left="1pt solid #ff0000",
background_color="#ffff00")
# conditional styles
t.setStyle("B1:B5", condition="cell-content()<=125")
t.setStyle("B1:B5", condition_color="#ff0000")
# export
from simpleodspy.sodsxml import SodsXml
tw = SodsXml(t)
tw.save("test.xml")
str_columnName = chr(65 + int_modulo) + str_columnName
int_dividend = (int_dividend - int_modulo) / 26
return str_columnName
Sods_table = SodsSpreadSheet(len(LILI_TABLE) + 1, len(LILI_TABLE[0]) + 1)
rowsOutput = 0
for rowIndex in range(len(LILI_TABLE)):
rowsOutput = rowsOutput + 1
for colIndex in range(len(LILI_TABLE[rowIndex])):
str_coordinate = GetColumnName(colIndex + 1) + str(
rowIndex + 1) #Spreadsheet is not 0 based.
Sods_table.setValue(str_coordinate,
str(LILI_TABLE[rowIndex][colIndex]))
if LILI_TABLE[rowIndex][colIndex] == "aa":
Sods_table.setStyle(str_coordinate, background_color="#33ff33")
elif LILI_TABLE[rowIndex][colIndex] == "bb":
Sods_table.setStyle(str_coordinate, background_color="#3399ff")
elif LILI_TABLE[rowIndex][colIndex] == "ab":
Sods_table.setStyle(str_coordinate, background_color="#00ffff")
if bool_keepSDCO == False:
str_outFile = (str_vcfName.split(".")[0]) + "_noSDCO.ods"
else:
str_outFile = (str_vcfName.split(".")[0]) + ".ods"
sys.stderr.write("Outputting %s markers to .ods\n" % str(rowsOutput - 1))
Sods_ods = SodsOds(Sods_table)
Sods_ods.save(str_outFile)
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
# Copyright (C) 2010 Yaacov Zamir (2010) <*****@*****.**>
# Author: Yaacov Zamir (2010) <*****@*****.**>
from simpleodspy.sodsspreadsheet import SodsSpreadSheet
from simpleodspy.sodshtml import SodsHtml
t = SodsSpreadSheet()
t.setValue("A1:A3", "green")
t.setStyle("A1:A3", background_color="#00ff00")
t.setValue("B1:B3", "blue")
t.setStyle("B1:B3", background_color="#0000ff")
t.setStyle("B3", border_top="1pt solid #ff0000", border_bottom="1pt solid #ff0000")
tw = SodsHtml(t)
tw.save("test.html")
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
# Copyright (C) 2010 Yaacov Zamir (2010) <*****@*****.**>
# Author: Yaacov Zamir (2010) <*****@*****.**>
from simpleodspy.sodsspreadsheet import SodsSpreadSheet
from simpleodspy.sodshtml import SodsHtml
t = SodsSpreadSheet()
t.setValue("A1:A3", "green")
t.setStyle("A1:A3", background_color = "#00ff00")
t.setValue("B1:B3", "blue")
t.setStyle("B1:B3", background_color = "#0000ff")
t.setStyle("B3", border_top = "1pt solid #ff0000", border_bottom = "1pt solid #ff0000")
tw = SodsHtml(t)
tw.save("test.html")
from simpleodspy.sodsspreadsheet import SodsSpreadSheet
t = SodsSpreadSheet(10, 10)
print("Test spreadsheet naming:")
print("-----------------------")
# setting values and formulas
t.setValue("A1", "Hello world !")
t.setValue("B2:C2", 123.4)
t.setValue("B3", "=B2+3")
t.setValue("B4", "=sum(B2:B3)")
# cell styles
t.setStyle("A1", color = "#0000ff")
t.setStyle("A1:A5", background_color = "#00ff00")
t.setStyle("B1:B5", border_left = "1pt solid #ff0000", background_color = "#ffff00")
# conditional styles
t.setStyle("B1:B5", condition = "cell-content()<=125")
t.setStyle("B1:B5", condition_color = "#ff0000")
# export
from simpleodspy.sodsxml import SodsXml
tw = SodsXml(t)
tw.save("test.xml")
# import
t2 = SodsSpreadSheet(10, 10)
tw = SodsXml(t2)
" {0}".format(appointment_other.start.strftime("%d.%m.")))
course_other_dates_str = ""
if len(course_other_dates) > 0:
course_other_dates_str = "; auch " + ", ".join(course_other_dates)
print_cell(spreadsheet_timetable, course_row_start, weekday_column + 1, ", ".join(course_rooms))
print_cell(spreadsheet_timetable, course_row_start + 2, weekday_column, ", ".join(course_dates) + course_other_dates_str)
block_row_start += block_height[block] * appointment_height
# set borders on timetable
# first the horizontal ones
block_row_start = row_start + 1
timetable_last_row = sum(block_height.values()) * appointment_height + block_row_start
for row in range(block_row_start, timetable_last_row, 3):
spreadsheet_timetable.setStyle("{0}:{1}".format(cell_coordinate(row, column_start+1), cell_coordinate(row, 5*appointment_width + column_start)), border_top=block_separator_appointments)
# print first column: block numbers
current_row = row_start + 1
for block in range(1, 9):
spreadsheet_timetable.setStyle("{0}:{1}".format(cell_coordinate(current_row, column_start+1), cell_coordinate(current_row, 5*appointment_width + column_start)), border_top=block_separator_border)
current_row += block_height[block] * appointment_height
# now the vertical ones
# no border right of Friday
for weekday in range(1, 5):
weekday_column = column_start + 1 + (weekday-1) * appointment_width + 1
spreadsheet_timetable.setStyle("{0}:{1}".format(cell_coordinate(row_start, weekday_column), cell_coordinate(timetable_last_row - 1, weekday_column)), border_right=block_separator_border)
print("Für die folgenden {0} Veranstaltungen wurde kein Termin im gewählten Zeitfenster gefunden:".format(len(courses_missed.values())))
if not courses_missed:
