setCellValue PhpSpreadsheet输出不正确

Question

i set setCellValue in my phpspreadsheet example

$objPHPExcel->getActiveSheet()->setCellValue('A1'.'3209134102750009');

and then the output in xlsx when iam already downloaded is 3209134102750000

why always replace with 0 at the last?

i tried to changed set format code

setFormatCode(PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);

or setFormatCode(PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER);

but not working, the output still not correct.. please help..

please don't suggest me to add ' at the first number ('3209134102750009) cause it make output still have '

Answer 1

already fixed!!

i add more function after value

,PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

so

$objPHPExcel->getActiveSheet()->setCellValueExplicit('A1','3209134102750009',PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);

Thank you