Jun 26, 2011 at 9:42 PM
Edited Jun 26, 2011 at 10:38 PM
I know similar topics have been discussed in this forum. But please note that I have worked through all other post and still have no solution to my problem:
In my database I have values stored like 4.1 (basically an expression for a software version) as a varchar. When I now output it to excel i get 4,1 - with a comma. I tried everything from setting the format code to text (@) or even various conversion attempts
like settype or quoting the variabe.
I also tried:
$objPHPExcel->getActiveSheet()->setCellValueExplicitByColumnAndRow(23, $row, $incomingloader, PHPExcel_Cell_DataType::TYPE_STRING);
In this case the cell is empty!
The explicit set of the locale variable also has no effect.
When I enter the value 4.1 manually in Excel it works fine. I am really despaired. Has anybody a hint for me?
Thanks in advance