$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");