dongqingcheng2903 2015-11-27 10:26
浏览 30

使用PHP Excel工作表显示加密字符串而不是我使用的数字

I am using PHP Excel to make sheet in XLS format. There is an cell which is used to hold a number let's suppose 34567898 but when the sheet generates/downloaded it will became like 234E876 (like encrypted number). When I double-click on the sheet it converted into number same as I want.

I heard about to make cell format in text, so I change the format to text by this function

($objPHPExcel->getActiveSheet()
->getStyle('C1')
->getNumberFormat()
->setFormatCode(
    \PHPExcel_Style_NumberFormat::FORMAT_TEXT
);)

but it not works although when I check the format in sheet it is in text means function works but cell still showing the string 234E876.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测