drrvnbwle80177811 2019-06-24 07:12
浏览 147

在HTML和PHP中将“String”转换为“Float”导出为EXCEL

I am exporting an HTML table to excel. But when I want to export a number with decimals (float / double) that contain a point

20.02 < "." 

The excel thinks that it is a string, no matter what type it is (because I've done a gettype and it shows me double), just because it contains the point it reads it as a string.

Im using next code:

$filename = "filename.xls";
header('Content-Type: content=text/html; charset=ISO-8859-1');
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=$filename");

Then table: (this is a example)

<table>

  <tr>
    <th>Float</th>
  </tr>

  <tr>
    <td> <?php echo utf8_decode($float) ?></td>
  </tr>

</table>

All the code works, I export a perfect excel, just as I want, the only problem I find is the conversion of the float that HTML reads as a STRING when reading a " . "

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 用visual studi code完成html页面
    • ¥15 聚类分析或者python进行数据分析
    • ¥15 逻辑谓词和消解原理的运用
    • ¥15 三菱伺服电机按启动按钮有使能但不动作
    • ¥15 js,页面2返回页面1时定位进入的设备
    • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
    • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
    • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
    • ¥20 腾讯企业邮箱邮件可以恢复么
    • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?