我是在易表里设的公式导出的,以前都没问题,突然就导不出金额的小数位后数字了。
公式如下:
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)