$ods->addFontFaces($Webdings);
$style10 = new odsStyleTableCell();
$style10->setFontFace($Webdings);
$table = new odsTable('odsStyleTableCell');
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Red text", $style1));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Green background", $style2));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Blue border", $style3));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Align :"));
$row->addCell(new odsTableCellString("start", $style4_1));
$row->addCell(new odsTableCellString("center", $style4_2));
$row->addCell(new odsTableCellString("end", $style4_3));
$row->addCell(new odsTableCellString("justify : 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 ... ", $style4_4));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Bold", $style5));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Italic", $style6));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Underline", $style7));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Font size", $style8));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Times New Roman", $style9));
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("Webdings", $style10));
$ods->addTable($table);
// Download the file
$ods->downloadOdsFile("Properties.ods");
$row->addCell(new odsTableCellString("US :"));
$row->addCell(new odsTableCellDateTime(date('Y-m-d') . 'T20:30:50', 'MMDDYYHHMMSSAMPM'));
$row->addCell(new odsTableCellString("FR :"));
$row->addCell(new odsTableCellDateTime(date('Y-m-d') . 'T20:30:50', 'DDMMYYHHMMSS'));
$table->addRow($row);
// EUR cell
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Euro cell"));
$row->addCell(new odsTableCellCurrency(rand(0, 100), 'EUR'));
$row->addCell(new odsTableCellCurrency(-rand(0, 100), 'EUR'));
$table->addRow($row);
// USD cell
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Dolars cell"));
$row->addCell(new odsTableCellCurrency(rand(0, 100), 'USD'));
$row->addCell(new odsTableCellCurrency(-rand(0, 100), 'USD'));
$table->addRow($row);
// GBP cell
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Pounds cell"));
$row->addCell(new odsTableCellCurrency(rand(0, 100), 'GBP'));
$row->addCell(new odsTableCellCurrency(-rand(0, 100), 'GBP'));
$table->addRow($row);
// Image cell
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Image cell"));
$row->addCell(new odsTableCellImage("logo.png"));
$table->addRow($row);
$ods->addTable($table);
// Download the file
$ods->downloadOdsFile("CellType.ods");
$row = new odsTableRow();
// Create 10 number cell
for ($i = 0; $i < 10; $i++) {
$row = new odsTableRow();
$row->addCell(new odsTableCellEmpty());
$row->addCell(new odsTableCellFloat(rand(0, 50)));
$table->addRow($row);
}
// Add Formula cell
// Forumla is writen in english language, it's internal format for formula
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Sum :"));
$cell = new odsTableCellFloat(0);
$cell->setFormula("SUM([.B1:.B10])");
$row->addCell($cell);
$table->addRow($row);
// Empty row
$row = new odsTableRow();
$table->addRow($row);
// 2nd example contatenate string
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Laurent"));
$row->addCell(new odsTableCellString("VUIBERT"));
$cell = new odsTableCellString("");
$row->addCell($cell);
$cell->setFormula('CONCATENATE([.A13];" ";[.B13];" : ";[.B11])');
$table->addRow($row);
// Attach talble to ods
$ods->addTable($table);
// Download the file
$ods->downloadOdsFile("HelloWorld.ods");
$ods = new ods();
// Create table named 'utf8'
$table = new odsTable('utf8');
// Create french row
$row = new odsTableRow();
$row->addCell(new odsTableCellString("French"));
$row->addCell(new odsTableCellString("àôïîéèç..."));
$table->addRow($row);
// Create greek row
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Greek"));
$row->addCell(new odsTableCellString("αβγδεζϕΩ..."));
$table->addRow($row);
// Create hebrew row
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Hebrew"));
$row->addCell(new odsTableCellString("ש֓חרםא..."));
$table->addRow($row);
// Create arab row
$row = new odsTableRow();
$row->addCell(new odsTableCellString("Arab"));
$row->addCell(new odsTableCellString("ڤڦڪصى..."));
$table->addRow($row);
$row = new odsTableRow();
$row->addCell(new odsTableCellString("..."));
$row->addCell(new odsTableCellString("..."));
$table->addRow($row);
// Attach talble to ods
$ods->addTable($table);
// Download the file
$ods->downloadOdsFile("Unicode.ods");
$table->addRow($row);
// Merge 4 vertical cell
$row = new odsTableRow();
$cell = new odsTableCellString('Merge 4 cells');
$cell->setNumberRowsSpanned(4);
$row->addCell($cell);
$table->addRow($row);
for ($i = 0; $i < 3; $i++) {
// You need add cell odsCoveredTableCell, in covered cell except the first row (implicit)
$row = new odsTableRow();
$row->addCell(new odsCoveredTableCell());
$table->addRow($row);
}
// Merge 4*7 cell
$row = new odsTableRow();
$cell = new odsTableCellString('Merge 4*4 cells');
$cell->setNumberColumnsSpanned(4);
$cell->setNumberRowsSpanned(4);
$row->addCell($cell);
$table->addRow($row);
for ($i = 0; $i < 3; $i++) {
// You need add cell odsCoveredTableCell, in covered cell except the first row (implicit)
$row = new odsTableRow();
$row->addCell(new odsCoveredTableCell());
$row->addCell(new odsCoveredTableCell());
$row->addCell(new odsCoveredTableCell());
$row->addCell(new odsCoveredTableCell());
$table->addRow($row);
}
// Download the file
$ods->downloadOdsFile("MergeCell.ods");
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
// 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");
<?php
// All file is writen in UTF-8
// Load library
require_once '../ods.php';
// Create Ods object
$ods = new ods();
// Create table named 'table 1'
$table = new odsTable('table 1');
// Create the first row
$row = new odsTableRow();
// Create and add 2 cell 'Hello' and 'World'
$row->addCell(new odsTableCellString("Hello"));
$row->addCell(new odsTableCellString("World"));
// Attach row to table
$table->addRow($row);
// Attach talble to ods
$ods->addTable($table);
// Download the file
$ods->downloadOdsFile("HelloWorld.ods");
<?php
// Load library
require_once '../ods.php';
// Create Ods object
$ods = new ods();
$table = new odsTable('Column Width');
// create column width 1cm
$styleColumn = new odsStyleTableColumn();
$styleColumn->setColumnWidth("1cm");
$column1 = new odsTableColumn($styleColumn);
// create column width 7cm
$styleColumn = new odsStyleTableColumn();
$styleColumn->setColumnWidth("7cm");
$column2 = new odsTableColumn($styleColumn);
// add 2 1cm column
$table->addTableColumn($column1);
$table->addTableColumn($column1);
// add 1 7cm column
$table->addTableColumn($column2);
// Create data
$table->addRow($row = new odsTableRow());
$row->addCell(new odsTableCellString("1cm"));
$row->addCell(new odsTableCellString("1cm"));
$row->addCell(new odsTableCellString("7cm ..."));
// Add table to ods
$ods->addTable($table);
// Download the file
$ods->downloadOdsFile("ColumnWidth.ods");
