PHP MySQL Excel to xls?

Question

This my example code:

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->SetCellValue('A2', '1.0');
$objPHPExcel->getActiveSheet()->SetCellValue('B2', '0.0');
$objPHPExcel->getActiveSheet()->SetCellValue('C2', '1.2');
$objPHPExcel->getActiveSheet()->SetCellValue('D2', '100');

I am getting in excel sheet is round off values for A2->1 and B2->0, What I need to output in excel sheet is A2->1.0 and B2->0.0. I need the float values end with .zero (.0) to print.

Please help me out...

Jim Garrison · Accepted Answer · 2009-11-26 05:04:58Z

1

You need to set the display format of the cells to Number. The default in Excel is General, which will display the values as you describe. I don't know if the PHP Excel interface will let you set the cell format, but that's where you should start.

EDIT: According to the PHPExcel website it supports setting cell formats. Read the docs to find out how to set the appropriate format.

answered Nov 26, 2009 at 5:04

Jim Garrison

87k20 gold badges162 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ObjetivoPHP · Accepted Answer · 2010-12-02 20:55:13Z

1

Export / Import excel to mysql. DEAME3P

answered Dec 2, 2010 at 20:55

ObjetivoPHP

111 bronze badge

Comments

Ricardo Origin · Accepted Answer · 2015-05-18 21:15:59Z

1

I think u want something like this

$objPHPExcel->getActiveSheet()->getStyle('D1')->getNumberFormat()->setFormatCode('###.00');

I use it on my project, any doubts, ask away

answered May 18, 2015 at 21:15

Ricardo Origin

1753 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP MySQL Excel to xls?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related