JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
const COL_WIDTHS = [95, 80, 130, 105, 105, 72, 72];
COL_WIDTHS.forEach((w, c) => sheet.setColumnWidth(c, w));
const HEADERS = ['구매번호', '부서', '품목', '예산(만원)', '집행(만원)', '집행률', '상태'];
HEADERS.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c)
.backColor('#1565C0').foreColor('#ffffff')
.font('bold 13px sans-serif')
.hAlign(GC.Spread.Sheets.HorizontalAlign.center);
});
sheet.setRowHeight(0, 38);
const DATA = [
['PO-001', '영업부', '노트북 20대', 2000, 1950, '완료'],
['PO-002', '개발부', '서버 장비', 5000, 3200, '진행중'],
['PO-003', '인사부', '사무용품', 500, 130, '진행중'],
['PO-004', '마케팅부', '광고 소재', 1200, 1300, '초과'],
['PO-005', '운영부', '냉방 설비', 3000, 0, '대기'],
['PO-006', '재무부', 'ERP 라이선스', 8000, 8000, '완료'],
['PO-007', '개발부', '개발 도구', 600, 420, '진행중'],
];
const BG = { '완료': '#E8F5E9', '초과': '#FFEBEE', '대기': '#FFF3E0', '진행중': '#F5F9FF' };
const FG = { '완료': '#2E7D32', '초과': '#C62828', '대기': '#E65100', '진행중': '#1565C0' };
DATA.forEach(([po, dept, item, budget, exec, status], i) => {
const r = i + 1;
sheet.setValue(r, 0, po); sheet.setValue(r, 1, dept); sheet.setValue(r, 2, item);
sheet.setValue(r, 3, budget); sheet.setValue(r, 4, exec);
sheet.setFormula(r, 5, `=IF(D${r + 1}=0,"",E${r + 1}/D${r + 1})`);
sheet.setValue(r, 6, status);
sheet.setRowHeight(r, 34);
for (let c = 0; c < 7; c++) sheet.getCell(r, c).backColor(BG[status] || '#fff');
sheet.getCell(r, 3).formatter('#,##0').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
sheet.getCell(r, 4).formatter('#,##0').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
sheet.getCell(r, 5).formatter('0%').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
sheet.getCell(r, 6)
.foreColor(FG[status] || '#333').font('bold 12px sans-serif')
.hAlign(GC.Spread.Sheets.HorizontalAlign.center);
});
const TR = DATA.length + 1;
sheet.setValue(TR, 2, '합 계');
sheet.setFormula(TR, 3, `=SUM(D2:D${TR})`);
sheet.setFormula(TR, 4, `=SUM(E2:E${TR})`);
sheet.setFormula(TR, 5, `=IFERROR(SUM(E2:E${TR})/SUM(D2:D${TR}),"")`);
sheet.getCell(TR, 3).formatter('#,##0').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
sheet.getCell(TR, 4).formatter('#,##0').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
sheet.getCell(TR, 5).formatter('0%').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
for (let c = 0; c < 7; c++) {
sheet.getCell(TR, c).backColor('#BBDEFB').font('bold 13px sans-serif');
}
sheet.setRowHeight(TR, 40);