JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = false;
const sheet = spread.getActiveSheet();
const CF = GC.Spread.Sheets.ConditionalFormatting;
const headers = ['신청번호', '신청인', '대출금액(만원)', '신용점수', '등급', '심사결과', '금리(%)'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#263238').foreColor('#FFFFFF').font('bold 12px sans-serif').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.setColumnWidth(c, [95, 80, 120, 80, 60, 80, 70][c]);
});
sheet.setRowHeight(0, 36);
const data = [
['L-001', '김민준', 30000, 74, 'B+', '승인', 3.9],
['L-002', '이서연', 15000, 37, 'D', '보류', 0 ],
['L-003', '박지호', 80000, 96, 'AAA','승인', 3.2],
['L-004', '최유진', 8000, 22, 'E', '거절', 0 ],
['L-005', '정수민', 25000, 65, 'B', '승인', 4.1],
['L-006', '한지원', 20000, 51, 'C', '조건부',5.3],
['L-007', '오민석', 18000, 50, 'C', '조건부',5.5],
['L-008', '윤채원', 40000, 88, 'AA', '승인', 3.4],
['L-009', '강도현', 12000, 43, 'D', '보류', 0 ],
['L-010', '임지수', 35000, 79, 'A', '승인', 3.7],
];
data.forEach((row, r) => {
row.forEach((val, c) => sheet.setValue(r + 1, c, val));
sheet.getCell(r + 1, 3).hAlign(GC.Spread.Sheets.HorizontalAlign.center).font('bold 12px sans-serif');
sheet.getCell(r + 1, 4).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.getCell(r + 1, 5).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
const result = row[5];
const rowBg = result === '승인' ? '#E8F5E9' : result === '거절' ? '#FFEBEE' : '#FFF9C4';
sheet.getCell(r + 1, 5).backColor(rowBg).font('bold 11px sans-serif')
.foreColor(result === '승인' ? '#2E7D32' : result === '거절' ? '#C62828' : '#F57F17');
});
// 신용점수 열(4번째)에 3단계 색상 스케일: 0(적색) → 60(황색) → 100(녹색)
const scaleRule = new CF.ScaleRule(
CF.RuleType.threeScaleRule,
CF.ScaleValueType.number, 0, '#EF5350',
CF.ScaleValueType.number, 60, '#FFF176',
CF.ScaleValueType.number, 100, '#66BB6A',
[new GC.Spread.Sheets.Range(1, 3, 10, 1)]
);
sheet.conditionalFormats.addRule(scaleRule);