Oct 16, 2014 at 7:09 AM
Edited Oct 16, 2014 at 7:10 AM
We are using below code for reading and writing xlsx. and also that xlsx have many conditonal formatting and percentage values.
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load('input.xlsx');
$objWriter =PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
but on result output.xlsx file not showing same as input xlsx file
We are not fetching same result of percentage value and can't showing percentage symbol/format value on cell.
example like in
input.xlsx file cell value 85%
than result is
output.xlsx file cell value 0.85
Could you please help us for above issue?
Any help on this problem would be greatly appreciated!
Thank you in advance!