Apr 8, 2013 at 8:54 AM
Edited Apr 8, 2013 at 8:56 AM
Thanks a lot. it help me very much.
I m facing another problem.
i tried to read a colum as bellow
here UnitNo is very important for me.
for($row = $startRowIndex;;$row++)
$unitNo = $objSheet->getCellByColumnAndRow(0, $row)->getValue();
$unitNo = trim($unitNo);
// other stuff which depends on unitNo
for value 2.1 it gave me value 2.1 thats fine. but for 2.10 also it gave me 2.1 but i need 2.10 as it is. To solve this i changed all such cells' formatting to "Text" in xlsx sheet. but it didnt work for me. How to change or instruct getValue that
it return me text as it is in xlsx ??