float percent PHPExcel_IOFactory

Asked Sep 25 '17 at 10:42

Active Sep 25 '17 at 12:10

Viewed 83 times

I've seen this post and it's work. But the percent is not converted.

Ex : In the xls, C1 = 0,0226115615112098% After the convertion, in the CSV, C1 = ?0.2f%

I don't find how specify the good format in this case.

The post example is :

require_once 'Classes/PHPExcel/IOFactory.php';

$inputFileType = 'Excel5';
$inputFileName = 'YOUR_EXCEL_FILE_PATH';

$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcelReader = $objReader->load($inputFileName);

$loadedSheetNames = $objPHPExcelReader->getSheetNames();

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcelReader, 'CSV');

foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {
    $objWriter->setSheetIndex($sheetIndex);
    $objWriter->save($loadedSheetName.'.csv');
}

Link to the library

edited Sep 25 '17 at 12:10

asked Sep 25 '17 at 10:42

Xenofexs

1

Hello. Can you add a sample of your code ? – One More Light Sep 25 '17 at 10:57
So what is the code that you're using to do this conversion? – Mark Baker Sep 25 '17 at 11:46
I've post the link with the code. It's all. I add it if you want – Xenofexs Sep 25 '17 at 12:09

float percent PHPExcel_IOFactory

0 Answers0