回答：EXCEL中将单元格切下格式看下

回答：SELECT    CONVERT(VARCHAR(10), createtime, 120) AS createdate,    CONVERT(VARCHAR(2), createtime, 108) AS createhour,    SUM(opc_so2) AS opc_so2,    SUM(opc_nox) AS opc_nox,    SUM(opc_yc) AS opc_ycFROM    TABLEGROUP BY     CONVERT(VARCHAR(10), createtime, 120),    CONVERT(VARCHAR(2), createtime, 108);

回答：参考https://bbs.fanruan.com/wenda/question1/113795.html  @flyingsnake 大神的回复修补了下var obj = document.getElementById("popup_container");   obj.style.cssText = "position: absolute; z-index: 99999; padding: 0px; margin: 0 auto; top: 50%; left: 50%;transform: translate(-50%, -50%);  min-width: 600px; max-width: 600px; width:600px; min-height: 300px; height: auto; font-family: microsoft yahei;"var obj0 = document.getElementById("popup_title");   obj0.style.cssText = "font-size: 14.8px; font-family: microsoft yahei;"var obj1 = document.getElementById("popup_header");   obj1.style.cssText = "width: 100%; font-family: microsoft yahei;"var obj2 = document.getElementById("popup_content");   obj2.style.cssText = "left: 10%; width: 70%; background-position: 23px 31px; font-family: microsoft yahei; height: auto;"var obj3 = document.getElementById("popup_message");   obj3.style.cssText = "width: 100%;color: grey; font-size: 14.8px; font-family: microsoft yahei; text-align: left; padding-left: 6%; padding-right: 10%; height: auto;"$('.fr-core-btn-style-blue').css('left','25%');$('.fr-core-btn-style-gray').css('right','25%');// height: auto; 好像不能自动调整高度；

回答：在填报属性设置列值那里双击选择公式，输入上面的公式就哦

回答：建议删减排除法【狗头】

回答：第二个问题暂时找到答案了因为设置了主键，主键相同的内容被覆盖了；