有什么方法可以将科学符号读为常规数字phpspreadsheet？

发布于 2025-02-11 06:38:56 字数 984 浏览 3 评论 0原文

因此，我有一个.csv文件，其中包含订单项目ID作为科学符号（单元格式为一般）

And i tried to read the file using PHPSpreadsheet (im using codeigniter 3)

$upload_file = $_FILES['order_report']['name'];

$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();

$spreadsheet = $reader->load($_FILES['order_report']['tmp_name']);

$sheet = $spreadsheet->getActiveSheet()->toArray();

When i tried to read and echo in php,

echo $sheet[1][0];
// result : 7,7736E+14

Is it possible the value to be shown as 777359539596902 like the formula bar says?

PS：

我已经尝试使用number_format（）尝试将其转换，但是输出是完全不同的数字，
我也使用$：$ dreversheet- getActivesHeet（） - ＆gt; getStyle（'a2：a99'） - ＆gt ; getnumberformat（） - ＆gt; setFormatCode（'0'） $ shetch line，但仍然不起作用，

谢谢

原文

So i have this .csv file that contains order item id as scientific notation (cell's format is general)

Excel screenshot

And i tried to read the file using PHPSpreadsheet (im using codeigniter 3)

$upload_file = $_FILES['order_report']['name'];

$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();

$spreadsheet = $reader->load($_FILES['order_report']['tmp_name']);

$sheet = $spreadsheet->getActiveSheet()->toArray();

When i tried to read and echo in php,

echo $sheet[1][0];
// result : 7,7736E+14

Is it possible the value to be shown as 777359539596902 like the formula bar says?

PS :

i've been tried convert it using number_format(), but the output is totally different number
I've also use $spreadsheet->getActiveSheet()->getStyle('A2:A99')->getNumberFormat()->setFormatCode('0') before the $sheet line but it still doesn't work

Thank you

分享到QQ

分享到微博