解析合并单元格 - 《初级程序员的成长之路》

conversionJson(jsonStrInfo) {
if (jsonStrInfo) {
letconvJsonInfo = JSON.parse(jsonStrInfo)
convJsonInfo.forEach(element=> {
for (letxinelement.config.merge) {
letr = parseInt(x.substr(0, x.indexOf(‘‘)))
letc = parseInt(x.substr(x.indexOf(‘‘) + 1))
letmcInfo = element.config.merge[x]
letitem = element.celldata.find(item=>item.c == c && item.r == r)
item.v.mc = mcInfo
console.log(item.v.mc, ‘查询到的’)
}
})
console.log(convJsonInfo, ‘ces1111’)
returnJSON.stringify(convJsonInfo)
} else {
returnjsonStrInfo
}
},

mergeCalculation:function(index){

    letfile = Store.luckysheetfile[this.getSheetIndex(index)];<br />        letconfig = file.config, data = file.data;<br />        if(config==null){<br />            return;<br />        }<br />        letmergeConfig = config.merge;<br />        if(mergeConfig==null || indexinthis.mergeCalculationSheet || file["autoCalculationMerge"]===false){<br />            return;<br />        }<br />        this.mergeCalculationSheet[index] = 1;<br />        for(let x in mergeConfig){<br />            letr = parseInt(x.substr(0, x.indexOf('_')));<br />            letc = parseInt(x.substr(x.indexOf('_') + 1));<br />            letmcInfo = mergeConfig[x];<br />            if(data[r][c]==null){<br />                data[r][c] = {};<br />            }<br />            data[r][c]["mc"] = {<br />                r:r,<br />                c:c,<br />                rs:mcInfo.rs,<br />                cs:mcInfo.cs,<br />            }<br />            for(letir=r;ir<r+mcInfo.rs;ir++){<br />                for(letic=c;ic<c+mcInfo.cs;ic++){<br />                    if(ir==r && ic==c){<br />                        continue;<br />                    }<br />                    if(data[ir][ic]==null){<br />                        data[ir][ic] = {};<br />                    }<br />                    data[ir][ic]["mc"] = {<br />                        r:r,<br />                        c:c,<br />                    }<br />                }<br />            }<br />        }