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>