public function ods($start, $end)
{
$data = $this->gendate($start, $end);
$ods = new ods();
$table = new odsTable('table 1');
$table->setHorizontalSplit(1);
$table->setVerticalSplit(3);
// Set coluomn width
$styleColumn = new odsStyleTableColumn();
$styleColumn->setColumnWidth("4cm");
$table->addTableColumn(new odsTableColumn($styleColumn));
$table->addTableColumn($column = new odsTableColumn($styleColumn = new odsStyleTableColumn()));
$styleColumn->setColumnWidth("1.5cm");
$column->setRepeated($data['total_days']);
// Set Title Style
$styleTitle1 = new odsStyleTableCell();
$styleTitle1->setBorder("0.01cm solid #000000");
$styleTitle1->setFontWeight('bold');
$styleTitle2 = clone $styleTitle1;
$styleTitle2->setTextAlign("center");
// Months style
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Months:", $styleTitle1));
foreach ($data['months'] as $moi) {
$cell = new odsTableCellString($moi['title'], $styleTitle2);
$cell->setNumberColumnsSpanned($moi['day']);
$row->addCell($cell);
}
$table->addRow($row);
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Weeks :", $styleTitle1));
foreach ($data['weeks'] as $week) {
$cell = new odsTableCellString($week['title'], $styleTitle2);
$cell->setNumberColumnsSpanned($week['day']);
$row->addCell($cell);
}
$table->addRow($row);
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Days:", $styleTitle1));
foreach ($data['days'] as $day) {
$cell = new odsTableCellString($day['title'], $styleTitle2);
$cell->setNumberColumnsSpanned($day['day']);
$row->addCell($cell);
}
$table->addRow($row);
foreach ($data['projects'] as $projet) {
$row = new odsTableRow();
$row->addCell(new odsTableCellString($projet['title'], $styleTitle1));
if ($projet["shift"]) {
$cell = new odsTableCellEmpty();
$cell->setNumberColumnsRepeated($projet["shift"]);
$row->addCell($cell);
}
$styleX = clone $styleTitle2;
$styleX->setBackgroundColor($projet[color]);
$cell = new odsTableCellString($projet['title'], $styleX);
$cell->setNumberColumnsSpanned($projet['days']);
$row->addCell($cell);
$table->addRow($row);
}
$ods->addTable($table);
$ods->downloadOdsFile("tab.ods");
exit;
}
<?php
// Load library
require_once '../ods.php';
// Create Ods object
$ods = new ods();
//Set vertical split
$table = new odsTable('V Split');
$table->setVerticalSplit(1);
$ods->addTable($table);
//Set Horizontal split
$table = new odsTable('H Split');
$table->setHorizontalSplit(1);
$ods->addTable($table);
// Both split
$table = new odsTable('B Split');
$table->setVerticalSplit(1);
$table->setHorizontalSplit(1);
$ods->addTable($table);
// Download the file
$ods->downloadOdsFile("TableSplit.ods");
<?php
// This example is writen in UTF-8
// Load library
require_once '../ods.php';
// Create Ods object
$ods = new ods();
// Create table named 'table 1'
$table1 = new odsTable('table 1');
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Hello"));
$row->addCell(new odsTableCellString("World"));
$table1->addRow($row);
$ods->addTable($table1);
// Create table named 'table 2'
$table2 = new odsTable('table 2');
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Rand1"));
$row->addCell(new odsTableCellString("="));
$row->addCell(new odsTableCellString(rand()));
$table2->addRow($row);
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Rand2"));
$row->addCell(new odsTableCellString("="));
$row->addCell(new odsTableCellString(rand()));
$table2->addRow($row);
$ods->addTable($table2);
//Select 'table 2'
$ods->setDefaultTable($table2);
// Download the file
$ods->downloadOdsFile("multiTable.ods");
