public function setUp()
{
if (!defined('PHPEXCEL_ROOT')) {
define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
}
require_once PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php';
PHPExcel_Shared_String::setDecimalSeparator('.');
PHPExcel_Shared_String::setThousandsSeparator(',');
}
/**
* @dataProvider provider
*/
public function testCurrency($value, $valueBinded, $format, $thousandsSeparator, $decimalSeparator, $currencyCode)
{
$sheet = $this->getMock('PHPExcel_Worksheet', array('getStyle', 'getNumberFormat', 'setFormatCode'));
$sheet->expects($this->once())->method('getStyle')->will($this->returnSelf());
$sheet->expects($this->once())->method('getNumberFormat')->will($this->returnSelf());
$sheet->expects($this->once())->method('setFormatCode')->with($format)->will($this->returnSelf());
PHPExcel_Shared_String::setCurrencyCode($currencyCode);
PHPExcel_Shared_String::setDecimalSeparator($decimalSeparator);
PHPExcel_Shared_String::setThousandsSeparator($thousandsSeparator);
$cell = new PHPExcel_Cell('A', 1, null, PHPExcel_Cell_DataType::TYPE_STRING, $sheet);
$binder = new PHPExcel_Cell_AdvancedValueBinder();
$binder->bindValue($cell, $value);
$this->assertEquals($valueBinded, $cell->getValue());
}
/**
* @dataProvider provider
*/
public function testCurrency($value, $valueBinded, $format, $thousandsSeparator, $decimalSeparator, $currencyCode)
{
$sheet = $this->getMock('PHPExcel_Worksheet', array('getStyle', 'getNumberFormat', 'setFormatCode', 'getCellCacheController'));
$cache = $this->getMockBuilder('PHPExcel_CachedObjectStorage_Memory')->disableOriginalConstructor()->getMock();
$cache->expects($this->any())->method('getParent')->will($this->returnValue($sheet));
$sheet->expects($this->once())->method('getStyle')->will($this->returnSelf());
$sheet->expects($this->once())->method('getNumberFormat')->will($this->returnSelf());
$sheet->expects($this->once())->method('setFormatCode')->with($format)->will($this->returnSelf());
$sheet->expects($this->any())->method('getCellCacheController')->will($this->returnValue($cache));
PHPExcel_Shared_String::setCurrencyCode($currencyCode);
PHPExcel_Shared_String::setDecimalSeparator($decimalSeparator);
PHPExcel_Shared_String::setThousandsSeparator($thousandsSeparator);
$cell = new PHPExcel_Cell(NULL, PHPExcel_Cell_DataType::TYPE_STRING, $sheet);
$binder = new PHPExcel_Cell_AdvancedValueBinder();
$binder->bindValue($cell, $value);
$this->assertEquals($valueBinded, $cell->getValue());
}
<?php
if ($format == 'xlsx') {
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
}
if ($format == 'xls') {
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
}
if ($format == 'csv') {
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV')->setDelimiter(';')->setEnclosure('"')->setLineEnding("\r\n")->setSheetIndex(0);
require_once '../../PHPExcel/Classes/PHPExcel/Shared/String.php';
PHPExcel_Shared_String::setDecimalSeparator(',');
PHPExcel_Shared_String::setThousandsSeparator('.');
}
$objWriter->save($filename);
chmod($filename, 0777);
while (!file_exists($filename)) {
sleep(1);
}
if ($format === 'csv') {
print '<br><img src=../images/csv.gif class=downloadimage><a href="../temp/' . $rand . '.' . $format . '">Open csv-bestand</a> (' . formatSizeUnits(filesize($filename)) . ')';
} else {
print '<br><img src=../images/excel.gif class=downloadimage><a href="../../temp/' . $rand . '.' . $format . '">Open Excel-bestand</a> (' . formatSizeUnits(filesize($filename)) . ')';
}
?>
<script type="text/javascript">
$(document).ready(function() {
$('#download').css({'background-image':'none'});
});
</script>
