const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 데이터 소스 — IBSheet setData / setRowData에 해당
const budgetData = [
{ dept: '기획예산부', item: '인건비', budget: 85000, used: 72450, rate: 85.2 },
{ dept: '기획예산부', item: '운영비', budget: 12000, used: 9840, rate: 82.0 },
{ dept: '개발사업부', item: '인건비', budget: 120000, used: 98760, rate: 82.3 },
{ dept: '개발사업부', item: '외주용역', budget: 45000, used: 44100, rate: 98.0 },
{ dept: '개발사업부', item: '장비구입', budget: 30000, used: 18900, rate: 63.0 },
{ dept: '인프라팀', item: '유지보수', budget: 15000, used: 15600, rate: 104.0 },
];
// IBSheet colModel → SpreadJS bindColumns
const colInfos = [
{ name: 'dept', displayName: '부서명', size: 100 },
{ name: 'item', displayName: '예산항목', size: 100 },
{ name: 'budget', displayName: '예산액(천원)', size: 110, formatter: '#,##0' },
{ name: 'used', displayName: '집행액(천원)', size: 110, formatter: '#,##0' },
{ name: 'rate', displayName: '집행률(%)', size: 90, formatter: '0.0' },
];
sheet.autoGenerateColumns = false;
sheet.setDataSource(budgetData);
sheet.bindColumns(colInfos);
// 헤더 스타일
for (let c = 0; c < colInfos.length; c++) {
sheet.getCell(0, c, GC.Spread.Sheets.SheetArea.colHeader)
.backColor('#1565C0').foreColor('#ffffff').font('bold 12px sans-serif');
}
sheet.setRowHeight(0, 36, GC.Spread.Sheets.SheetArea.colHeader);
// 조건부 서식: 집행률 100% 초과 → 빨강, 80% 미만 → 주황, 정상 → 녹색
const cfs = sheet.conditionalFormats;
const rateRange = [new GC.Spread.Sheets.Range(0, 4, budgetData.length, 1)];
const overStyle = new GC.Spread.Sheets.Style();
overStyle.backColor = '#FFCDD2'; overStyle.foreColor = '#B71C1C';
cfs.addCellValueRule(
GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan,
100, 0, overStyle, rateRange
);
const lowStyle = new GC.Spread.Sheets.Style();
lowStyle.backColor = '#FFF3E0'; lowStyle.foreColor = '#E65100';
cfs.addCellValueRule(
GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.lessThan,
80, 0, lowStyle, rateRange
);
const goodStyle = new GC.Spread.Sheets.Style();
goodStyle.backColor = '#E8F5E9'; goodStyle.foreColor = '#1B5E20';
cfs.addCellValueRule(
GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between,
80, 100, goodStyle, rateRange
);