const { sheetRangeData } = resformat;
spread.suspendEvent();
spread.suspendPaint();
sheetRangeData?.map((item: any) => {
const { row, col } = (GC.Spread.Sheets.CalcEngine.formulaToRanges(activeSheet, item.rangeName)[0] as any).ranges[0]
try {
activeSheet.setArray(row, col, item.values, true);
} catch (e) {
if (e === '无效的公式') {
let itemss: object[] = []
item.values.map((items: any) => {
console.log(items)
let pdd: string[] = []
items.map((itemsss: any) => {
pdd.push(itemsss.replaceAll('"', '').replaceAll('\'', ''))
})
itemss.push(pdd)
})
activeSheet.setArray(row, col, itemss, true)
}
}
});
spread.resumeEvent();
spread.resumePaint();
文件里是array的格式 麻烦您这边试一下 有点大
|
|