<?php
//--------------------------------------------------------------
//EXCEL CONSTANTS FOR PEAR
//--------------------------------------------------------------
error_reporting(E_ALL | E_NOTICE);
$cSeparator = (PHP_SHLIB_SUFFIX == 'dll') ? ';' : ':';
define('INCLUDE_SEPARATOR', $cSeparator);
define('FOLDER_SITE', $_SERVER['REQUEST_URI']);
define('PEAR_FOLDER', 'PEAR/');

// set in ini, else PEAR gets lost
ini_set('include_path', '.'.INCLUDE_SEPARATOR . FOLDER_SITE . INCLUDE_SEPARATOR . PEAR_FOLDER);


// New instance of excel writer
require_once "Spreadsheet/Excel/Writer.php";
$xls = new Spreadsheet_Excel_Writer('created_test.xls');
$xls->setVersion(8);
$sheet = & $xls->addWorksheet('test_worksheet');
$sheet->setInputEncoding('UTF-8');

//Append data
$sheet->writeString(0, 0, "Prvi stolpec");
$sheet->writeString(0, 1, "Drugi stolpec");
$sheet->writeString(0, 2, "Tretji stolpec");
$sheet->writeString(0, 3, "Četrti stolpec");
$sheet->writeString(0, 4, "Datum");

//Set column width (if you set width for one column, all next column will inherite this attribute)
$sheet->setColumn(0, 0, 9.14);
$sheet->setColumn(0, 1, 11.14);
$sheet->setColumn(0, 2, 29.86);
$sheet->setColumn(0, 3, 8.57);
$sheet->setColumn(0, 4, 15.57);

// Set row height
$sheet->setRow(0, 15.75);

// Create date format
$date_format =& $xls->addFormat();
$date_format->setNumFormat('date');

//Add test data
$data = array(100, 200, 300, 400, '21-06-1987');

for ($j=1; $j < 10; $j++) {
	for ($i=0; $i<5; $i++) {
		// Add date format
		if ($i == 4) {
			$sheet->writeString($j, $i, $data[$i], $date_format);
		// Write integer
		} else {
			$sheet->writeNumber($j, $i, $data[$i]+$j+$i);
		}
	}
}

// Usage of some more advanced features
$xls->setCustomColor(10, 128, 128, 128); // Index of color -> 10

// Creating new format
$gray_bg_white_content = & $xls->addFormat();
$gray_bg_white_content->setColor('white'); // font color
$gray_bg_white_content->setFgColor(10); // use above created custom color for background color
$gray_bg_white_content->setSize(10); // font size
$gray_bg_white_content->setBold(); // make it bold
$gray_bg_white_content->setFontFamily('Verdana');
//$gray_bg_white_content->setNumFormat('€#,##'); // number format
$gray_bg_white_content->setBottom(1); // bottom border
$gray_bg_white_content->setTop(1); // top border
$gray_bg_white_content->setRight(1); // right border
$gray_bg_white_content->setAlign('left'); // left aligned

// Create sum formula
$sheet->writeFormula(11, 0, '=SUM(A3:A9)', $gray_bg_white_content);

// Write email
$sheet->writeUrl(13, 0, 'mailto:info@trsplet.com', 'info@trsplet.com');

// Write URL
$sheet->writeUrl(15,0, 'http://www.trsplet.com', 'www.trsplet.com');

// Insert picture
$sheet->insertBitmap(17, 0, 'trspletlogo.bmp', 20, 20, 1, 1);

// Merge columns
//$xls->mergeCells(0,0,0,3);

//Save file
$xls->close();
?>