导出失败

我在sheet中设置过rowRangeGroup
sheet.rowRangeGroup.direction = GcSpread.Sheets.RangeGroupDirection.Backward;
sheet.showRowRangeGroup(false);
sheet.rowRangeGroup.group(row, length);

导出excel时显示失败

direction是个方法
activeSheet.rowOutlines.direction(GC.Spread.Sheets.Outlines.OutlineDirection.Backward);

"{"version":"10.0.1","allowUserDragDrop":false,"showHorizontalScrollbar":false,"scrollbarMaxAlign":true,"tabStripVisible":false,"sheetCount":2,"sheets":{"Sheet1":{"name":"Sheet1","frozenColCount":1,"rowCount":25,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"租赁指标"},"1":{"value":"本月"},"2":{"value":"月末累计"},"3":{"value":"备注"}},"1":{"0":{"value":"整体平均有效租金（含自用）（元/m2/月）"},"1":{"value":0,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.00_","locked":true}},"2":{"value":71.3381777778,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.00_"}},"3":{"style":{"formatter":"@","locked":true}}},"2":{"0":{"value":"整体平均有效租金（不含自用）（元/m2/月）"},"1":{"value":0,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.00_","locked":true}},"2":{"value":129.1824222222,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.00_"}},"3":{"style":{"formatter":"@","locked":true}}},"3":{"0":{"value":"外租收入（万元）"},"1":{"style":{"hAlign":2,"formatter":"#,##0.0000_","locked":true,"cellType":{"digit":4}}},"2":{"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"4":{"0":{"value":"内租收入（万元）"},"1":{"value":224.6819,"style":{"hAlign":2,"formatter":"#,##0.0000_","locked":true,"cellType":{"digit":4}}},"2":{"value":2067.4999,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"5":{"0":{"value":"自用虚拟收入（万元）"},"1":{"style":{"hAlign":2,"formatter":"#,##0.0000_","locked":true,"cellType":{"digit":4}}},"2":{"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"6":{"0":{"value":"车位费收入（万元）"},"1":{"style":{"hAlign":2,"formatter":"#,##0.0000_","locked":true,"cellType":{"digit":4}}},"2":{"value":116.6014,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"7":{"0":{"value":"其他收入（万元）"},"1":{"style":{"hAlign":2,"formatter":"#,##0.0000_","locked":true,"cellType":{"digit":4}}},"2":{"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"8":{"0":{"value":"租金收入（含自用）（万元）"},"1":{"value":224.6819,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":2067.4999,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"9":{"0":{"value":"租金收入（不含自用）（万元）"},"1":{"value":224.6819,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":2067.4999,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"10":{"0":{"value":"营业收入（含自用）（万元）"},"1":{"value":224.6819,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":2184.1013,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"11":{"0":{"value":"营业收入（不含自用）（万元）"},"1":{"value":224.6819,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":2184.1013,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"12":{"0":{"value":"租金实收率（%）"},"1":{"style":{"hAlign":2,"formatter":"0.00%","locked":true,"cellType":{}}},"2":{"value":0.8071,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"0.00%"}},"3":{"style":{"formatter":"@","locked":true}}},"13":{"0":{"value":"营业税金及附加（万元）"},"1":{"style":{"hAlign":2,"formatter":"#,##0.0000_","locked":true,"cellType":{"digit":4}}},"2":{"value":63.0348,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"14":{"0":{"value":"房产税（万元）"},"1":{"value":55.5667,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":500.1003,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"15":{"0":{"value":"土地使用税（万元）"},"1":{"value":0.6826,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":6.1434,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"16":{"0":{"value":"合同印花税及其它税金（万元）"},"1":{"value":0.2642,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":2.3778,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"17":{"0":{"value":"营业费用（不含折旧、管理费及税金）（万元）"},"1":{"style":{"hAlign":2,"formatter":"#,##0.0000_","locked":true,"cellType":{"digit":4}}},"2":{"value":12.0784,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"18":{"0":{"value":"营业费用及税金合计（万元）"},"1":{"value":56.5135,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":583.7347,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"19":{"0":{"value":"资产管理费（万元）"},"1":{"value":21.8425,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true}},"2":{"value":196.5825,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"20":{"0":{"value":"资本性支出（万元）"},"1":{"style":{"hAlign":2,"formatter":"#,##0.0000_","locked":true,"cellType":{"digit":4}}},"2":{"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"}},"3":{"style":{"formatter":"@","locked":true}}},"21":{"0":{"value":"资产管理费前EBITDA（不含自用）（万元）"},"1":{"value":1904.27933824121,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true},"formula":"C12-C14-C18*(1-自用比例)-(C15+C16+C17)/12*填报月份*(1-自用比例)"},"2":{"value":1904.27933824121,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"},"formula":"B22"},"3":{"style":{"formatter":"@","locked":true}}},"22":{"0":{"value":"资产管理费后EBITDA（不含自用）（万元）"},"1":{"value":929.677900098935,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_","locked":true},"formula":"C22-C20*填报月份*(1-自用比例)"},"2":{"value":929.677900098935,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"#,##0.0000_"},"formula":"B23"},"3":{"style":{"formatter":"@","locked":true}}},"23":{"0":{"value":"资产管理费前EBITDA Yield（不含自用）（%）"},"1":{"value":0.0668234950803689,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"0.00%","locked":true},"formula":"C22/考核规模/填报月份*12"},"2":{"value":0.0668234950803689,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"0.00%"},"formula":"B24"},"3":{"style":{"formatter":"@","locked":true}}},"24":{"0":{"value":"资产管理费后EBITDA Yield（不含自用）（%）"},"1":{"value":0.032623536545309,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"0.00%","locked":true},"formula":"C23/考核规模/填报月份*12"},"2":{"value":0.032623536545309,"style":{"backColor":"#e6e6e6","hAlign":2,"formatter":"0.00%"},"formula":"B25"},"3":{"style":{"formatter":"@","locked":true}}}},"defaultDataNode":{"style":{"hAlign":0,"themeFont":"Body","borderLeft":{"color":"#cfcfcf","style":1},"borderTop":{"color":"#cfcfcf","style":1},"borderRight":{"color":"#cfcfcf","style":1},"borderBottom":{"color":"#cfcfcf","style":1}}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"dataTable":{"0":{"0":{"value":"租赁指标"},"1":{"value":"本月"},"2":{"value":"月末累计"},"3":{"value":"备注"}}},"defaultDataNode":{"style":{"themeFont":"Body"}}},"selections":{"activeSelectedRangeIndex":-1,"length":0},"theme":"Office","columns":[{"size":250},{"size":150},{"size":150},{"size":200}],"names":[{"name":"考核规模","formula":"custom!$A$1","row":0,"col":0},{"name":"自用比例","formula":"custom!$A$2","row":0,"col":0},{"name":"填报月份","formula":"custom!$A$3","row":0,"col":0}],"rowHeaderVisible":false,"isProtected":true,"protectionOptions":{"allowResizeRows":true,"allowResizeColumns":true},"index":0},"custom":{"name":"custom","data":{"dataTable":{"0":{"0":{"value":37996.2035}},"1":{"0":{"value":0.44914197}},"2":{"0":{"value":9}}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"selections":{"0":{"row":0,"rowCount":1,"col":0,"colCount":1},"length":1},"theme":"Office","index":1}}}"

导出提示

您这个json是何种方式生产的，里面的celltype有问题

function NumberCellType(option) {
                this.digit = 2;
                if (option && option.digit && angular.isNumber(option.digit)) {
                    this.digit = option.digit;
                }
            }
            NumberCellType.prototype = new GC.Spread.Sheets.CellTypes.Text();
            NumberCellType.prototype.getEditorValue = function (editorContext) {
                var value = editorContext.value;
                if (value) {
                    if (value == null || isNaN(value) || value === "") {
                        return null;
                    } else {
                        return parseFloat(value).toFixed(this.digit);
                    }
                }
            };
            spread.NumberCellType = NumberCellType;

怎么改才能让他导出成功

http://demo.gcpowertools.com.cn/ ... customItemSerialize

构造函数里加上typeName  
this.typeName = "NumberCellType"

修改了，导出后的excel仍然提示styles.xml错误

嗯，重现了，正在检查问题