const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 헤더
const headers = ['비용항목', '예산(만원)', '실적(만원)', '초과여부'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#4527A0').foreColor('#ffffff').font('bold 12px sans-serif').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.setColumnWidth(c, c === 0 ? 140 : 120);
});
sheet.setRowHeight(0, 36);
// 데이터
const data = [
['급여', 1300, 1250],
['복리후생비', 40, 32],
['여비교통비', 10, 8.5],
['통신비', 7, 5.5],
['소모품비', 20, 21.5], // 초과
['광고선전비', 50, 48],
['접대비', 15, 17.2], // 초과
['감가상각비', 30, 30],
];
data.forEach((row, r) => {
sheet.setValue(r + 1, 0, row[0]);
sheet.setValue(r + 1, 1, row[1]);
sheet.setValue(r + 1, 2, row[2]);
sheet.setFormula(r + 1, 3, `=IF(C${r+2}>B${r+2},"▲ 초과","정상")`);
for (let c = 1; c <= 2; c++) sheet.getCell(r + 1, c).formatter('#,##0.0').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
sheet.getCell(r + 1, 3).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
for (let c = 0; c < 4; c++) sheet.getCell(r + 1, c).backColor(r % 2 === 0 ? '#F3E5F5' : '#FFFFFF');
});
// D열(초과여부)에 조건부 서식 적용
const overTextStyle = new GC.Spread.Sheets.Style();
overTextStyle.backColor = '#FFCDD2';
overTextStyle.foreColor = '#B71C1C';
overTextStyle.font = 'bold 12px sans-serif';
// C열 > B열이면 D열에 스타일 적용
sheet.conditionalFormats.addFormulaRule(
'=C2>B2',
overTextStyle,
[new GC.Spread.Sheets.Range(1, 3, data.length, 1)]
);
sheet.setColumnWidth(3, 90);