麦粉社区
>
帖子详情

电子表格导出 Excel:订单号超过 15 位,导出来全变成了科学计数...

AIChat 发表于 半小时前
发表于 半小时前

在电子表格里做的明细表,里面有一列是“订单流水号”,长度是 18 位的纯数字。
在浏览器里预览是完全正常的字符串。但是一点“导出 Excel”,用微软 Excel 打开,这一列直接被截断,后半截全变成了 0,并且显示成了科学计数法!
客户反馈说流水号对不上,没法对账。请问大佬们,导出时怎么强制让这一列以“文本”格式写入 Excel?是不是必须在电子表格的单元格属性里,设置成类似 '${订单号} 的转义写法

发表于 半小时前
谢谢
weibo.com/ttarticle/p/show?id=2309405360965658476585
weibo.com/ttarticle/p/show?comment=1&id=2309405360965578785265
weibo.com/ttarticle/p/show?comment=1&id=2309405360965658476585
weibo.com/ttarticle/p/show?comment=1&id=2309405360965541036362
weibo.com/ttarticle/p/show?id=2309405360965578785265
weibo.com/ttarticle/p/show?id=2309405360965541036362
weibo.com/ttarticle/p/show?id=2309405360965616534114
weibo.com/ttarticle/p/show?id=2309405360965695963347
weibo.com/ttarticle/p/show?comment=1&id=2309405360965695963347
weibo.com/ttarticle/p/show?comment=1&id=2309405360965616534114
weibo.com/ttarticle/p/show?comment=1&id=2309405360965733712078
weibo.com/ttarticle/p/show?id=2309405360983035216019
weibo.com/ttarticle/p/show?id=2309405360965733712078
weibo.com/ttarticle/p/show?comment=1&id=2309405360983035216019
weibo.com/ttarticle/p/show?id=2309405360983253582003
weibo.com/ttarticle/p/show?comment=1&id=2309405360983253582003
weibo.com/ttarticle/p/show?id=2309405360983475617795
weibo.com/ttarticle/p/show?id=2309405360983693721636
weibo.com/ttarticle/p/show?comment=1&id=2309405360983693721636
weibo.com/ttarticle/p/show?comment=1&id=2309405360983475617795
weibo.com/ttarticle/p/show?id=2309405360983911825426
weibo.com/ttarticle/p/show?comment=1&id=2309405360983911825426
weibo.com/ttarticle/p/show?id=2309405360984134123522
weibo.com/ttarticle/p/show?id=2309405360984352489508
weibo.com/ttarticle/p/show?comment=1&id=2309405360984352489508
weibo.com/ttarticle/p/show?comment=1&id=2309405360984570331172
weibo.com/ttarticle/p/show?id=2309405360984570331172
weibo.com/ttarticle/p/show?id=2309405360984788697105
weibo.com/ttarticle/p/show?comment=1&id=2309405360984134123522
weibo.com/ttarticle/p/show?comment=1&id=2309405360984788697105
weibo.com/ttarticle/p/show?id=2309405360985031704607
weibo.com/ttarticle/p/show?comment=1&id=2309405360985031704607
weibo.com/ttarticle/p/show?id=2309405360985472106521
weibo.com/ttarticle/p/show?comment=1&id=2309405360985472106521
weibo.com/ttarticle/p/show?comment=1&id=2309405360985690210311
weibo.com/ttarticle/p/show?id=2309405360985690210311
weibo.com/ttarticle/p/show?comment=1&id=2309405360985908576295
weibo.com/ttarticle/p/show?id=2309405360985908576295
weibo.com/ttarticle/p/show?id=2309405360986130874375
weibo.com/ttarticle/p/show?comment=1&id=2309405360986130874375
weibo.com/ttarticle/p/show?id=2309405360986348978199
weibo.com/ttarticle/p/show?comment=1&id=2309405360986348978199
weibo.com/ttarticle/p/show?id=2309405360986567082011
weibo.com/ttarticle/p/show?comment=1&id=2309405360986567082011
weibo.com/ttarticle/p/show?comment=1&id=2309405360986789380104
weibo.com/ttarticle/p/show?id=2309405360986789380104
weibo.com/ttarticle/p/show?id=2309405360987032387608
weibo.com/ttarticle/p/show?comment=1&id=2309405360987032387608
weibo.com/ttarticle/p/show?comment=1&id=2309405360987250491443
weibo.com/ttarticle/p/show?id=2309405360987250491443
weibo.com/ttarticle/p/show?comment=1&id=2309405360987472789529
weibo.com/ttarticle/p/show?id=2309405360987472789529
weibo.com/ttarticle/p/show?id=2309405360987980562451
weibo.com/ttarticle/p/show?comment=1&id=2309405360987980562451
weibo.com/ttarticle/p/show?id=2309405360988198666247
weibo.com/ttarticle/p/show?comment=1&id=2309405360988198666247
weibo.com/ttarticle/p/show?comment=1&id=2309405360988416507922
weibo.com/ttarticle/p/show?comment=1&id=2309405360988638806025
weibo.com/ttarticle/p/show?id=2309405360988416507922
weibo.com/ttarticle/p/show?comment=1&id=2309405360988857171972
weibo.com/ttarticle/p/show?id=2309405360988857171972
weibo.com/ttarticle/p/show?id=2309405360988638806025
weibo.com/ttarticle/p/show?id=2309405360989079207959
weibo.com/ttarticle/p/show?comment=1&id=2309405360989079207959
weibo.com/ttarticle/p/show?id=2309405360989297573895
weibo.com/ttarticle/p/show?comment=1&id=2309405360989297573895
weibo.com/ttarticle/p/show?id=2309405360989737975812
weibo.com/ttarticle/p/show?comment=1&id=2309405360989737975812
weibo.com/ttarticle/p/show?comment=1&id=2309405360989960011791
weibo.com/ttarticle/p/show?id=2309405360989960011791
weibo.com/ttarticle/p/show?id=2309405360990178377743
weibo.com/ttarticle/p/show?comment=1&id=2309405360990178377743
weibo.com/ttarticle/p/show?comment=1&id=2309405360990400413735
weibo.com/ttarticle/p/show?id=2309405360990400413735
weibo.com/ttarticle/p/show?comment=1&id=2309405360990618779671
weibo.com/ttarticle/p/show?id=2309405360990618779671
weibo.com/ttarticle/p/show?id=2309405360990841077763
weibo.com/ttarticle/p/show?comment=1&id=2309405360990841077763
weibo.com/ttarticle/p/show?id=2309405360991067308040
weibo.com/ttarticle/p/show?comment=1&id=2309405360991067308040
weibo.com/ttarticle/p/show?comment=1&id=2309405360991503777843
weibo.com/ttarticle/p/show?id=2309405360991503777843
weibo.com/ttarticle/p/show?id=2309405360991725813765
weibo.com/ttarticle/p/show?comment=1&id=2309405360991725813765
weibo.com/ttarticle/p/show?comment=1&id=2309405360991944179715
weibo.com/ttarticle/p/show?id=2309405360991944179715
weibo.com/ttarticle/p/show?id=2309405360992162283536
weibo.com/ttarticle/p/show?comment=1&id=2309405360992162283536
weibo.com/ttarticle/p/show?id=2309405360992602423313
weibo.com/ttarticle/p/show?comment=1&id=2309405360992602423313
weibo.com/ttarticle/p/show?id=2309405360992829177867
weibo.com/ttarticle/p/show?comment=1&id=2309405360992829177867
weibo.com/ttarticle/p/show?id=2309405360993055670280
weibo.com/ttarticle/p/show?comment=1&id=2309405360993055670280
weibo.com/ttarticle/p/show?id=2309405360993496072194
weibo.com/ttarticle/p/show?comment=1&id=2309405360993496072194
weibo.com/ttarticle/p/show?id=2309405360993714176008
weibo.com/ttarticle/p/show?comment=1&id=2309405360993714176008
weibo.com/ttarticle/p/show?id=2309405360993932279840
weibo.com/ttarticle/p/show?comment=1&id=2309405360993932279840
weibo.com/ttarticle/p/show?id=2309405360994154315791
weibo.com/ttarticle/p/show?comment=1&id=2309405360994154315791
weibo.com/ttarticle/p/show?comment=1&id=2309405360994372419597
weibo.com/ttarticle/p/show?id=2309405360994372419597
weibo.com/ttarticle/p/show?comment=1&id=2309405360994594979849
weibo.com/ttarticle/p/show?id=2309405360994594979849
weibo.com/ttarticle/p/show?id=2309405360994813083668
weibo.com/ttarticle/p/show?comment=1&id=2309405360994813083668
weibo.com/ttarticle/p/show?id=2309405360995098296323
weibo.com/ttarticle/p/show?comment=1&id=2309405360995098296323
weibo.com/ttarticle/p/show?comment=1&id=2309405360995459006487
weibo.com/ttarticle/p/show?id=2309405360995735568398
weibo.com/ttarticle/p/show?comment=1&id=2309405360995735568398
weibo.com/ttarticle/p/show?id=2309405360995459006487
weibo.com/ttarticle/p/show?comment=1&id=2309405360995970711557
weibo.com/ttarticle/p/show?id=2309405360995970711557
weibo.com/ttarticle/p/show?id=2309405360996193009685
weibo.com/ttarticle/p/show?comment=1&id=2309405360996193009685
weibo.com/ttarticle/p/show?comment=1&id=2309405360996432085002
weibo.com/ttarticle/p/show?id=2309405360996432085002
weibo.com/ttarticle/p/show?comment=1&id=2309405360996654120986
weibo.com/ttarticle/p/show?id=2309405360996654120986
weibo.com/ttarticle/p/show?id=2309405360997094785035
weibo.com/ttarticle/p/show?comment=1&id=2309405360997094785035
weibo.com/ttarticle/p/show?comment=1&id=2309405360997321277457
weibo.com/ttarticle/p/show?id=2309405360997321277457
weibo.com/ttarticle/p/show?id=2309405360997543313413
weibo.com/ttarticle/p/show?comment=1&id=2309405360997543313413
weibo.com/ttarticle/p/show?id=2309405360997770067977
weibo.com/ttarticle/p/show?comment=1&id=2309405360997770067977
weibo.com/ttarticle/p/show?id=2309405360997987909657
weibo.com/ttarticle/p/show?comment=1&id=2309405360997987909657
weibo.com/ttarticle/p/show?comment=1&id=2309405360998206013455
weibo.com/ttarticle/p/show?id=2309405360998206013455
weibo.com/ttarticle/p/show?comment=1&id=2309405360998428311574
weibo.com/ttarticle/p/show?id=2309405360998428311574
weibo.com/ttarticle/p/show?comment=1&id=2309405360998646677510
weibo.com/ttarticle/p/show?id=2309405360998646677510
weibo.com/ttarticle/p/show?id=2309405360998864519206
weibo.com/ttarticle/p/show?comment=1&id=2309405360998864519206
weibo.com/ttarticle/p/show?id=2309405360999086817287
weibo.com/ttarticle/p/show?comment=1&id=2309405360999086817287
weibo.com/ttarticle/p/show?comment=1&id=2309405360999309115404
weibo.com/ttarticle/p/show?id=2309405360999309115404
weibo.com/ttarticle/p/show?id=2309405360999527481370
weibo.com/ttarticle/p/show?comment=1&id=2309405360999527481370
weibo.com/ttarticle/p/show?comment=1&id=2309405360999749779458
weibo.com/ttarticle/p/show?id=2309405360999749779458
weibo.com/ttarticle/p/show?id=2309405360999967621131
weibo.com/ttarticle/p/show?comment=1&id=2309405360999967621131
weibo.com/ttarticle/p/show?id=2309405361000185987083
weibo.com/ttarticle/p/show?comment=1&id=2309405361000185987083
weibo.com/ttarticle/p/show?comment=1&id=2309405361000626126859
weibo.com/ttarticle/p/show?id=2309405361000626126859
weibo.com/ttarticle/p/show?comment=1&id=2309405361000844492808
weibo.com/ttarticle/p/show?id=2309405361000844492808
weibo.com/ttarticle/p/show?id=2309405361001066528770
weibo.com/ttarticle/p/show?id=2309405361001507192847
weibo.com/ttarticle/p/show?comment=1&id=2309405361001289089033
weibo.com/ttarticle/p/show?comment=1&id=2309405361001066528770
weibo.com/ttarticle/p/show?id=2309405361001289089033
weibo.com/ttarticle/p/show?comment=1&id=2309405361001507192847
weibo.com/ttarticle/p/show?comment=1&id=2309405361001733685262
weibo.com/ttarticle/p/show?id=2309405361001733685262
weibo.com/ttarticle/p/show?id=2309405361001955983362
weibo.com/ttarticle/p/show?comment=1&id=2309405361001955983362
weibo.com/ttarticle/p/show?id=2309405361002174087202
weibo.com/ttarticle/p/show?comment=1&id=2309405361002174087202
weibo.com/ttarticle/p/show?id=2309405361002610032728
weibo.com/ttarticle/p/show?comment=1&id=2309405361002610032728
weibo.com/ttarticle/p/show?comment=1&id=2309405361002836525058
weibo.com/ttarticle/p/show?id=2309405361002836525058
weibo.com/ttarticle/p/show?id=2309405361003054891014
weibo.com/ttarticle/p/show?id=2309405361003277189131
weibo.com/ttarticle/p/show?comment=1&id=2309405361003054891014
weibo.com/ttarticle/p/show?comment=1&id=2309405361003277189131
weibo.com/ttarticle/p/show?id=2309405361003495292940
weibo.com/ttarticle/p/show?comment=1&id=2309405361003495292940
weibo.com/ttarticle/p/show?id=2309405361003717591044
weibo.com/ttarticle/p/show?comment=1&id=2309405361003717591044
weibo.com/ttarticle/p/show?id=2309405361003935432713
weibo.com/ttarticle/p/show?comment=1&id=2309405361003935432713
weibo.com/ttarticle/p/show?id=2309405361004153536523
weibo.com/ttarticle/p/show?comment=1&id=2309405361004153536523
weibo.com/ttarticle/p/show?id=2309405361004593938445
weibo.com/ttarticle/p/show?id=2309405361004371640342
weibo.com/ttarticle/p/show?comment=1&id=2309405361004593938445
weibo.com/ttarticle/p/show?comment=1&id=2309405361004371640342
weibo.com/ttarticle/p/show?comment=1&id=2309405361004812042243
weibo.com/ttarticle/p/show?id=2309405361004812042243
weibo.com/ttarticle/p/show?id=2309405361005030146062
weibo.com/ttarticle/p/show?comment=1&id=2309405361005030146062
weibo.com/ttarticle/p/show?comment=1&id=2309405361005256900617
weibo.com/ttarticle/p/show?id=2309405361005256900617
weibo.com/ttarticle/p/show?id=2309405361005475004428
weibo.com/ttarticle/p/show?comment=1&id=2309405361005475004428
weibo.com/ttarticle/p/show?id=2309405361005697302551
weibo.com/ttarticle/p/show?comment=1&id=2309405361005697302551
weibo.com/ttarticle/p/show?comment=1&id=2309405361005919600642
weibo.com/ttarticle/p/show?id=2309405361005919600642
weibo.com/ttarticle/p/show?id=2309405361006137442343
weibo.com/ttarticle/p/show?comment=1&id=2309405361006137442343
weibo.com/ttarticle/p/show?comment=1&id=2309405361006359740425
weibo.com/ttarticle/p/show?id=2309405361006578106386
weibo.com/ttarticle/p/show?comment=1&id=2309405361006578106386
weibo.com/ttarticle/p/show?id=2309405361006359740425
weibo.com/ttarticle/p/show?comment=1&id=2309405361006795948055
weibo.com/ttarticle/p/show?id=2309405361006795948055
weibo.com/ttarticle/p/show?id=2309405361007018508290
weibo.com/ttarticle/p/show?comment=1&id=2309405361007018508290
回复

使用道具 赞 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

1回帖数 0关注人数 4浏览人数
最后回复于:半小时前

社区

指南

AI

搜索

快速回复 返回顶部 返回列表