const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 헤더
const headers = ['영업담당', '1분기', '2분기', '3분기', '4분기', '합계', '달성률(%)'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c)
.backColor('#1565C0')
.foreColor('#fff')
.font('bold 13px sans-serif')
.hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.setColumnWidth(c, c === 0 ? 100 : 88);
});
// 샘플 데이터
const salesData = [
['김민준', 1850, 2100, 1970, 2300],
['이서연', 1200, 980, 1350, 1100],
['박지호', 2500, 2800, 2650, 3100],
['최유진', 870, 1050, 920, 860],
['정수민', 1600, 1750, 1820, 1900],
];
const target = 2000;
salesData.forEach(([name, q1, q2, q3, q4], r) => {
sheet.setValue(r + 1, 0, name);
sheet.setValue(r + 1, 1, q1);
sheet.setValue(r + 1, 2, q2);
sheet.setValue(r + 1, 3, q3);
sheet.setValue(r + 1, 4, q4);
// Excel 호환 수식: 합계·달성률 자동 계산
sheet.setFormula(r + 1, 5, `=SUM(B${r+2}:E${r+2})`);
sheet.setFormula(r + 1, 6, `=SUM(B${r+2}:E${r+2})/(${target * 4})*100`);
sheet.getCell(r + 1, 6).formatter('0.0"%"');
});
// 조건부 서식: 목표(2,000) 미달 → 빨간색
const redStyle = new GC.Spread.Sheets.Style();
redStyle.backColor = '#FFEBEE';
redStyle.foreColor = '#C62828';
// 조건부 서식: 목표 달성 → 녹색
const greenStyle = new GC.Spread.Sheets.Style();
greenStyle.backColor = '#E8F5E9';
greenStyle.foreColor = '#2E7D32';
for (let c = 1; c <= 4; c++) {
const range = [new GC.Spread.Sheets.Range(1, c, 5, 1)];
sheet.conditionalFormats.addCellValueRule(
GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.lessThan,
target, undefined, redStyle, range
);
sheet.conditionalFormats.addCellValueRule(
GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between,
target, 999999, greenStyle, range
);
}
sheet.setRowHeight(0, 36);
for (let r = 1; r <= 5; r++) sheet.setRowHeight(r, 32);