模板下载怎么隐藏

收藏

比如说我有一个需求， 1510281453(1).jpg

，我需要隐藏最后一列，但是我是在这个方法下面写的
$("#saveModel").click(function(){
   var fileName = $("#exportFileName").val();
                  var months=${months};
                  var nowdate ='${campaign}';
                  //alert(months);
               // console.log(months);
                  if (fileName.substr(-5, 5) !== '.xlsx') {
                     fileName += '.xlsx';
                  }
// var json = '{"version":"10.2.0","tabStripRatio":0.731,"sheets":{"月度需求填报":{"name":"月度需求填报","defaults":{"colHeaderRowHeight":20,"rowHeaderColWidth":40,"rowHeight":18,"colWidth":72},"rowCount":2,"columnCount":4,"activeRow":2,"zoomFactor":0.85,"data":{"dataTable":{"0":{"0":{"value":"物料编码","style":"__builtInStyle46"},"1":{"value":"仓库","style":"__builtInStyle46"},"2":{"value":"[X]月需求","style":"__builtInStyle46"},"3":{"value":"[X+1]月需求","style":"__builtInStyle46"}}},"columnDataArray":[null,{"style":"__builtInStyle2"},{"style":"__builtInStyle2"},{"style":"__builtInStyle2"}],"defaultDataNode":{"style":{"backColor":null,"foreColor":"Text 1 0","vAlign":2,"font":"14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"selections":{"0":{"row":2,"rowCount":1,"col":-1,"colCount":4},"length":1},"theme":{"name":"Office","themeColor":{"name":"Office","background1":{"a":255,"r":255,"g":255,"b":255},"background2":{"a":255,"r":238,"g":236,"b":225},"text1":{"a":255,"r":0,"g":0,"b":0},"text2":{"a":255,"r":31,"g":73,"b":125},"accent1":{"a":255,"r":79,"g":129,"b":189},"accent2":{"a":255,"r":192,"g":80,"b":77},"accent3":{"a":255,"r":155,"g":187,"b":89},"accent4":{"a":255,"r":128,"g":100,"b":162},"accent5":{"a":255,"r":75,"g":172,"b":198},"accent6":{"a":255,"r":247,"g":150,"b":70},"hyperlink":{"a":255,"r":0,"g":0,"b":255},"followedHyperlink":{"a":255,"r":128,"g":0,"b":128}},"headingFont":"Cambria","bodyFont":"Calibri"},"rows":[{"size":32},null],"columns":[null,{"size":74},{"size":74},{"size":94}],"printInfo":{"orientation":2,"pageOrder":1,"blackAndWhite":true,"paperSize":{"width":850,"height":1100,"kind":1}},"sheetTabColor":"#ffc000","allowCellOverflow":true,"index":0}},"namedStyles":[{"backColor":"Accent 1 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent1"},{"backColor":"Accent 2 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent2"},{"backColor":"Accent 3 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent3"},{"backColor":"Accent 4 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent4"},{"backColor":"Accent 5 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent5"},{"backColor":"Accent 6 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent6"},{"backColor":"Accent 1 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent1"},{"backColor":"Accent 2 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent2"},{"backColor":"Accent 3 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent3"},{"backColor":"Accent 4 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent4"},{"backColor":"Accent 5 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent5"},{"backColor":"Accent 6 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent6"},{"backColor":"Accent 1 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent1"},{"backColor":"Accent 2 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent2"},{"backColor":"Accent 3 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent3"},{"backColor":"Accent 4 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent4"},{"backColor":"Accent 5 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent5"},{"backColor":"Accent 6 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent6"},{"backColor":"Accent 1 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent1"},{"backColor":"Accent 2 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent2"},{"backColor":"Accent 3 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent3"},{"backColor":"Accent 4 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent4"},{"backColor":"Accent 5 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent5"},{"backColor":"Accent 6 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent6"},{"backColor":"#ffc7ce","foreColor":"#9c0006","font":"14.7px Calibri","themeFont":"Body","name":"Bad"},{"backColor":"#f2f2f2","foreColor":"#fa7d00","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#7f7f7f","style":1},"borderTop":{"color":"#7f7f7f","style":1},"borderRight":{"color":"#7f7f7f","style":1},"borderBottom":{"color":"#7f7f7f","style":1},"name":"Calculation"},{"backColor":"#a5a5a5","foreColor":"Background 1 0","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#3f3f3f","style":6},"borderTop":{"color":"#3f3f3f","style":6},"borderRight":{"color":"#3f3f3f","style":6},"borderBottom":{"color":"#3f3f3f","style":6},"name":"Check Cell"},{"backColor":null,"name":"Comma"},{"backColor":null,"name":"Comma [0]"},{"backColor":null,"name":"Currency"},{"backColor":null,"name":"Currency [0]"},{"backColor":null,"foreColor":"#7f7f7f","font":"italic 14.7px Calibri","themeFont":"Body","name":"Explanatory Text"},{"backColor":"#c6efce","foreColor":"#006100","font":"14.7px Calibri","themeFont":"Body","name":"Good"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 20px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{"color":"Accent 1 0","style":5},"name":"Heading 1"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 17.3px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{"color":"Accent 1 49","style":5},"name":"Heading 2"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{"color":"Accent 1 39","style":2},"name":"Heading 3"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 14.7px Calibri","themeFont":"Body","name":"Heading 4"},{"backColor":"#ffcc99","foreColor":"#3f3f76","font":"14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#7f7f7f","style":1},"borderTop":{"color":"#7f7f7f","style":1},"borderRight":{"color":"#7f7f7f","style":1},"borderBottom":{"color":"#7f7f7f","style":1},"name":"Input"},{"backColor":null,"foreColor":"#fa7d00","font":"14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{"color":"#ff8001","style":6},"name":"Linked Cell"},{"backColor":"#ffeb9c","foreColor":"#9c6500","font":"14.7px Calibri","themeFont":"Body","name":"Neutral"},{"backColor":"#ffffcc","borderLeft":{"color":"#b2b2b2","style":1},"borderTop":{"color":"#b2b2b2","style":1},"borderRight":{"color":"#b2b2b2","style":1},"borderBottom":{"color":"#b2b2b2","style":1},"name":"Note"},{"backColor":"#f2f2f2","foreColor":"#3f3f3f","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#3f3f3f","style":1},"borderTop":{"color":"#3f3f3f","style":1},"borderRight":{"color":"#3f3f3f","style":1},"borderBottom":{"color":"#3f3f3f","style":1},"name":"Output"},{"backColor":null,"name":"Percent"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 24px Cambria","themeFont":"Headings","name":"Title"},{"backColor":null,"foreColor":"Text 1 0","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{"color":"Accent 1 0","style":1},"borderRight":{},"borderBottom":{"color":"Accent 1 0","style":6},"name":"Total"},{"backColor":null,"foreColor":"#ff0000","font":"14.7px Calibri","themeFont":"Body","name":"Warning Text"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"Normal"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle2"},{"backColor":"Background 1 0","foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle3","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 12px 宋体","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"name":"__builtInStyle4","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","formatter":"","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle5","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle6"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","formatter":"0%","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle7","parentName":"常规 10 2"},{"backColor":"#00b050","foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle8","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle9"},{"backColor":null,"foreColor":"Text 1 14","hAlign":3,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle10","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle11"},{"backColor":null,"foreColor":null,"hAlign":3,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle12","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle13"},{"backColor":"Background 1 0","foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"name":"__builtInStyle14","parentName":"常规 10 2"},{"backColor":"#00b050","foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"m/d/yyyy","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle15"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle16"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle17"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"m/d/yyyy","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle18"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle19"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle20"},{"backColor":"#ffc000","foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle21"},{"backColor":"#92d050","foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle22"},{"backColor":"#00b0f0","foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle23"},{"backColor":null,"foreColor":null,"hAlign":3,"vAlign":1,"font":"normal bold 18.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle24"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle25"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle26"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle27"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal bold 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle28"},{"backColor":"Accent 2 -24","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal bold 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle29"},{"backColor":"Accent 2 -24","foreColor":"Background 1 0","hAlign":1,"vAlign":1,"font":"normal bold 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle30"},{"backColor":"Accent 2 -24","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal bold 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle31"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle32"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle33"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle34"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle35"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle36"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle37"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle38"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle39"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle40"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle41"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle42"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle43"},{"backColor":null,"foreColor":null,"hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle44"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle45"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle46","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle47"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle48"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle49","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle50"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle51"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle52"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle53"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","formatter":"0.00%","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle54","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0.00%","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle55"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0.00%","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle56"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0%","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle57"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0%","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle58"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle59"},{"backColor":"#cc9900","foreColor":"Text 1 0","hAlign":0,"vAlign":2,"font":"normal bold 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle60"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle61"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle62"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle63"},{"backColor":null,"foreColor":"#ff0000","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle64"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle65"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle66"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle67"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle68"},{"backColor":null,"foreColor":"#ff0000","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle69"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle70"}]}';
var json='{"version":"10.2.0","tabStripRatio":0.731,"sheets":{"月度需求填报":{"name":"月度需求填报","defaults":{"colHeaderRowHeight":20,"rowHeaderColWidth":40,"rowHeight":18,"colWidth":72},"rowCount":2,"columnCount":3,"activeRow":2,"zoomFactor":0.85,"data":{"dataTable":{"0":{"0":{"value":"物料编码","style":"__builtInStyle46"},"1":{"value":"仓库","style":"__builtInStyle46"}}},"columnDataArray":[null,{"style":"__builtInStyle2"},{"style":"__builtInStyle2"},{"style":"__builtInStyle2"}],"defaultDataNode":{"style":{"backColor":null,"foreColor":"Text 1 0","vAlign":2,"font":"14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"selections":{"0":{"row":2,"rowCount":1,"col":-1,"colCount":4},"length":1},"theme":{"name":"Office","themeColor":{"name":"Office","background1":{"a":255,"r":255,"g":255,"b":255},"background2":{"a":255,"r":238,"g":236,"b":225},"text1":{"a":255,"r":0,"g":0,"b":0},"text2":{"a":255,"r":31,"g":73,"b":125},"accent1":{"a":255,"r":79,"g":129,"b":189},"accent2":{"a":255,"r":192,"g":80,"b":77},"accent3":{"a":255,"r":155,"g":187,"b":89},"accent4":{"a":255,"r":128,"g":100,"b":162},"accent5":{"a":255,"r":75,"g":172,"b":198},"accent6":{"a":255,"r":247,"g":150,"b":70},"hyperlink":{"a":255,"r":0,"g":0,"b":255},"followedHyperlink":{"a":255,"r":128,"g":0,"b":128}},"headingFont":"Cambria","bodyFont":"Calibri"},"rows":[{"size":32},null],"columns":[null,{"size":74},{"size":74},{"size":94}],"printInfo":{"orientation":2,"pageOrder":1,"blackAndWhite":true,"paperSize":{"width":850,"height":1100,"kind":1}},"sheetTabColor":"#ffc000","allowCellOverflow":true,"index":0}},"namedStyles":[{"backColor":"Accent 1 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent1"},{"backColor":"Accent 2 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent2"},{"backColor":"Accent 3 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent3"},{"backColor":"Accent 4 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent4"},{"backColor":"Accent 5 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent5"},{"backColor":"Accent 6 79","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"20% - Accent6"},{"backColor":"Accent 1 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent1"},{"backColor":"Accent 2 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent2"},{"backColor":"Accent 3 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent3"},{"backColor":"Accent 4 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent4"},{"backColor":"Accent 5 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent5"},{"backColor":"Accent 6 59","foreColor":"Text 1 0","font":"14.7px Calibri","themeFont":"Body","name":"40% - Accent6"},{"backColor":"Accent 1 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent1"},{"backColor":"Accent 2 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent2"},{"backColor":"Accent 3 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent3"},{"backColor":"Accent 4 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent4"},{"backColor":"Accent 5 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent5"},{"backColor":"Accent 6 39","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"60% - Accent6"},{"backColor":"Accent 1 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent1"},{"backColor":"Accent 2 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent2"},{"backColor":"Accent 3 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent3"},{"backColor":"Accent 4 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent4"},{"backColor":"Accent 5 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent5"},{"backColor":"Accent 6 0","foreColor":"Background 1 0","font":"14.7px Calibri","themeFont":"Body","name":"Accent6"},{"backColor":"#ffc7ce","foreColor":"#9c0006","font":"14.7px Calibri","themeFont":"Body","name":"Bad"},{"backColor":"#f2f2f2","foreColor":"#fa7d00","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#7f7f7f","style":1},"borderTop":{"color":"#7f7f7f","style":1},"borderRight":{"color":"#7f7f7f","style":1},"borderBottom":{"color":"#7f7f7f","style":1},"name":"Calculation"},{"backColor":"#a5a5a5","foreColor":"Background 1 0","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#3f3f3f","style":6},"borderTop":{"color":"#3f3f3f","style":6},"borderRight":{"color":"#3f3f3f","style":6},"borderBottom":{"color":"#3f3f3f","style":6},"name":"Check Cell"},{"backColor":null,"name":"Comma"},{"backColor":null,"name":"Comma [0]"},{"backColor":null,"name":"Currency"},{"backColor":null,"name":"Currency [0]"},{"backColor":null,"foreColor":"#7f7f7f","font":"italic 14.7px Calibri","themeFont":"Body","name":"Explanatory Text"},{"backColor":"#c6efce","foreColor":"#006100","font":"14.7px Calibri","themeFont":"Body","name":"Good"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 20px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{"color":"Accent 1 0","style":5},"name":"Heading 1"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 17.3px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{"color":"Accent 1 49","style":5},"name":"Heading 2"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{"color":"Accent 1 39","style":2},"name":"Heading 3"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 14.7px Calibri","themeFont":"Body","name":"Heading 4"},{"backColor":"#ffcc99","foreColor":"#3f3f76","font":"14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#7f7f7f","style":1},"borderTop":{"color":"#7f7f7f","style":1},"borderRight":{"color":"#7f7f7f","style":1},"borderBottom":{"color":"#7f7f7f","style":1},"name":"Input"},{"backColor":null,"foreColor":"#fa7d00","font":"14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{"color":"#ff8001","style":6},"name":"Linked Cell"},{"backColor":"#ffeb9c","foreColor":"#9c6500","font":"14.7px Calibri","themeFont":"Body","name":"Neutral"},{"backColor":"#ffffcc","borderLeft":{"color":"#b2b2b2","style":1},"borderTop":{"color":"#b2b2b2","style":1},"borderRight":{"color":"#b2b2b2","style":1},"borderBottom":{"color":"#b2b2b2","style":1},"name":"Note"},{"backColor":"#f2f2f2","foreColor":"#3f3f3f","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#3f3f3f","style":1},"borderTop":{"color":"#3f3f3f","style":1},"borderRight":{"color":"#3f3f3f","style":1},"borderBottom":{"color":"#3f3f3f","style":1},"name":"Output"},{"backColor":null,"name":"Percent"},{"backColor":null,"foreColor":"Text 2 0","font":"bold 24px Cambria","themeFont":"Headings","name":"Title"},{"backColor":null,"foreColor":"Text 1 0","font":"bold 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{"color":"Accent 1 0","style":1},"borderRight":{},"borderBottom":{"color":"Accent 1 0","style":6},"name":"Total"},{"backColor":null,"foreColor":"#ff0000","font":"14.7px Calibri","themeFont":"Body","name":"Warning Text"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"Normal"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle2"},{"backColor":"Background 1 0","foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle3","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 12px 宋体","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"name":"__builtInStyle4","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","formatter":"","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle5","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle6"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","formatter":"0%","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle7","parentName":"常规 10 2"},{"backColor":"#00b050","foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle8","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle9"},{"backColor":null,"foreColor":"Text 1 14","hAlign":3,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle10","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle11"},{"backColor":null,"foreColor":null,"hAlign":3,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle12","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle13"},{"backColor":"Background 1 0","foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"name":"__builtInStyle14","parentName":"常规 10 2"},{"backColor":"#00b050","foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"m/d/yyyy","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle15"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle16"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle17"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"m/d/yyyy","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle18"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle19"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle20"},{"backColor":"#ffc000","foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle21"},{"backColor":"#92d050","foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle22"},{"backColor":"#00b0f0","foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle23"},{"backColor":null,"foreColor":null,"hAlign":3,"vAlign":1,"font":"normal bold 18.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle24"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle25"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle26"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle27"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal bold 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle28"},{"backColor":"Accent 2 -24","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal bold 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle29"},{"backColor":"Accent 2 -24","foreColor":"Background 1 0","hAlign":1,"vAlign":1,"font":"normal bold 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle30"},{"backColor":"Accent 2 -24","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal bold 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle31"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle32"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle33"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle34"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle35"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle36"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle37"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle38"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle39"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{"color":"#000000","style":1},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle40"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle41"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle42"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle43"},{"backColor":null,"foreColor":null,"hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle44"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle45"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle46","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle47"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle48"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle49","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle50"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle51"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle52"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle53"},{"backColor":null,"foreColor":"Text 1 14","hAlign":1,"vAlign":1,"font":"normal normal 13.3px Calibri","themeFont":"Body","formatter":"0.00%","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"shrinkToFit":true,"name":"__builtInStyle54","parentName":"常规 10 2"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0.00%","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle55"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0.00%","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle56"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0%","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle57"},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":2,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0%","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle58"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle59"},{"backColor":"#cc9900","foreColor":"Text 1 0","hAlign":0,"vAlign":2,"font":"normal bold 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle60"},{"backColor":null,"foreColor":"Text 1 0","hAlign":1,"vAlign":1,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle61"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{},"borderTop":{},"borderRight":{},"borderBottom":{},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle62"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"name":"__builtInStyle63"},{"backColor":null,"foreColor":"#ff0000","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle64"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle65"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle66"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle67"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle68"},{"backColor":null,"foreColor":"#ff0000","hAlign":1,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle69"},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px 微软雅黑","formatter":"@","borderLeft":{"color":"#000000","style":1},"borderTop":{},"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"name":"__builtInStyle70"}]}';
                  var obj =JSON.parse(json);
                  var obj_sheet = obj.sheets;
                  var obj_name = obj_sheet.月度需求填报;
               // alert(obj_name.columnCount);
                  var obj_data = obj_name.data;
                  var obj_dataTable = obj_data.dataTable;
                  var obj_0_col = obj_dataTable['0'];
                  obj_name.columnCount = 2+months+1;
                  //var json_data = JSON.stringify(obj_0_col);
               // var obj_2_row = obj_0_col['2'];
            //var obj_3_row = obj_0_col['3'];
            var year = Number(nowdate.substring(0,4));
            var month = Number(nowdate.substring(4,6));
            //console.log(year);
            //console.log(month);
            var month_result = '';
               //obj_2_row.value=year+""+(date.getMonth()+1)+"月需求";
               // obj_3_row.value="12月需求";
               for(var i=2;i<2+months;i++){//这里的1为前面传过来的月数

               var obj_next_row = {};
               if((month%12)==0){
               obj_next_row.value =year+""+"12月需求";
               year = year+1;
               }else{
               if(month%12<10){
               month_result = '0'+(month%12);
               }else{
               month_result = month%12;
               }
               obj_next_row.value =year+""+month_result+"月需求";
               }
               obj_next_row.style="__builtInStyle46";
               obj_0_col[i+""] = obj_next_row;
               month++;
               }
               var checkid={};
               checkid.value='${campaignId}';
               checkid.style="__builtInStyle46";
               obj_0_col[2+months] = checkid;
               // console.log(JSON.stringify(obj));

               json = JSON.stringify(obj);
//var json = spread.toJSON();
sheet = getSheet(1);
sheet.setColumnVisible(sheet.getColumnCount(), false);

                  // here is excel IO API
                  excelIo.save(json, function (blob) {
                     saveAs(blob, fileName);

                  }, function (e) {
                     // process error
                     console.log(e);
                  });

好像导出来的模板还是没有隐藏那最后一列

Clark.Pan · Clark.Pan

您好：
您可以这样做
首先创建两个spread对象
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
var temp_spread = new GC.Spread.Sheets.Workbook();
spread 是在前端显示的，temp_spread是隐藏着导出用的，
然后使用spread.fromJSON(json)加载json，temp_spread.fromJSON(json)同样加载模板json，之后
temp_spread直接删掉需要隐藏的列，最后导出temp_spread

Yuengh · Yuengh

ClarkPan 发表于 2017-11-10 16:19
您好：
您可以这样做
首先创建两个spread对象

额，我的意思是为什么我用sheet = getSheet(1);
sheet.setColumnVisible(sheet.getColumnCount(), false);这个方法不行？好像是只能getSheet(0)，不能getSheet(1)，我感觉如果能用这个方法不是更简单一点吗？

Clark.Pan · Clark.Pan

getSheet是这样的
image.png372367553.png

其中索引跟数组的索引是类似的，从0开始，0代表第一个sheet，以此类推。就看您需要隐藏的列是在哪个sheet了。

		自动登录	找回密码
密码			立即注册

[已处理] 模板下载怎么隐藏

3 个回复

讲师达人

悬赏达人

微信认证勋章

SpreadJS 认证

SpreadJS 高级认证

元老葡萄