| 以文本方式查看主题 - 易表在线答疑 (http://www.egrid2000.com/dvbbs/index.asp) -- 用户社区 (http://www.egrid2000.com/dvbbs/list.asp?boardid=2) ---- 导出数据无小数位后的数字 (http://www.egrid2000.com/dvbbs/dispbbs.asp?boardid=2&id=29319) |
| -- 作者：zmdb -- 发布时间：2017/7/12 13:20:00 -- 导出数据无小数位后的数字 以前都好好的，突然从易表中导成的EXCEL文件金额中缺少了小数位后面的数字，如：原本应该导出13.11，而错误的导成了13 |
| -- 作者：zmdb -- 发布时间：2017/7/12 13:51:00 -- 在线等啊～请各位帮助解决下问题吧！ |
| -- 作者：iyplx2425 -- 发布时间：2017/7/12 13:57:00 -- 看看EXCEL单元格的设置？ |
| -- 作者：zmdb -- 发布时间：2017/7/12 14:12:00 -- 我是在易表里设的公式导出的，以前都没问题，突然就导不出金额的小数位后数字了。 公式如下： OpenView(1) and filterfor("区域","<>","b") and filterfor("区域","<>","g") and filterfor("区域","<>","s") and filterfor("省份","<>","十部") and movecol("发货单号",1) and movecol("经理",2) and movecol("客户编码",3) and movecol("客户名称",4) and movecol("产品名称",5) and movecol("发货数量",6) and movecol("单价",7) and movecol("金额",8) and movecol("挂账日期",9) and movecol("规格",10) and ExportDBFile("C:\\Users\\administrator\\desktop\\发货.xls",5,"2016总表","年份","=","2017","月份","=","7","区域","<>","b","区域","<>","g","区域","<>","s","省份","<>","十部","执行情况","<>","供不应求","发货单号","<>","","执行情况","<>","资信未审过","执行情况","<>","合同不合格","执行情况","<>","特批待审") and delfile("C:\\Users\\Administrator\\desktop\\发货.xls.bak") and OpenView(5) and movecol("合同号",1) and movecol("制单日期",2) and movecol("挂账日期",3) and movecol("区域",4) and movecol("省份",5) and movecol("经理",6) and movecol("执行情况",7) and movecol("发货单号",8) and movecol("客户编码",9) and movecol("客户名称",10) and movecol("收货地址",11) and movecol("邮编",12) and movecol("电话",13) and movecol("收货人",14) and movecol("运输方式",15) and movecol("铁路到站",16) and movecol("传真",17) and movecol("备注",18) and movecol("特殊说明",19) and movecol("合同原件",20) and movecol("日期",21) and movecol("月份",22) and movecol("年份",23) and movecol("刷新标记",24) and movecol("明细",25) and movecol("产品名称",26) and movecol("规格",27) and movecol("申请数量",28) and movecol("发货数量",29) and movecol("件数",30) and movecol("单价",31) and movecol("金额",32) and ShowAllRows() and do(127)
|