- spread.suspendPaint();
- let qianArray = [[80], [102], [2345], [13040], [123567], [1234670], [123789767], [12345154567]];
- sheet.setArray(10, 10, qianArray)
- qianArray.forEach((item, index) => {
- let num = item[0] + '';
- if (num.length < 3) {
- sheet.setValue(10, 11, parseInt(num))
- sheet.setFormatter(10, 11, '0"元"', GC.Spread.Sheets.SheetArea.viewport);
- }
- else if (num.length == 3) sheet.setFormula(10 + index, 11, `=ROUND(K${11 + index}/100,2)&"百元"`);
- else if (num.length == 4) sheet.setFormula(10 + index, 11, `=ROUND(K${11 + index}/1000,2)&"千元"`);
- else if (num.length >= 5 && num.length < 9) sheet.setFormula(10 + index, 11, `=ROUND(K${11 + index}/10000,2)&"万元"`);
- else if (num.length >= 9 && num.length < 13) sheet.setFormula(10 + index, 11, `=ROUND(K${11 + index}/100000000,2)&"亿元"`);
- })
- spread.resumePaint();
复制代码
|