const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'), { sheetCount: 2 });
const dataSheet = spread.getSheet(0);
const pivotSheet = spread.getSheet(1);
dataSheet.name('데이터');
pivotSheet.name('레이아웃');
const salesData = [
['지역', '제품', '분기', '매출액'],
['서울', '스프레드시트', 'Q1', 15000000],
['서울', 'PDF뷰어', 'Q1', 8000000],
['서울', '스프레드시트', 'Q2', 18000000],
['서울', 'PDF뷰어', 'Q2', 9500000],
['부산', '스프레드시트', 'Q1', 12000000],
['부산', 'PDF뷰어', 'Q1', 6000000],
['부산', '스프레드시트', 'Q2', 13000000],
['부산', 'PDF뷰어', 'Q2', 7000000],
['대구', '스프레드시트', 'Q1', 9000000],
['대구', 'PDF뷰어', 'Q2', 5200000],
];
dataSheet.setArray(0, 0, salesData);
dataSheet.tables.add('salesTable5', 0, 0, salesData.length, 4);
spread.setActiveSheet('레이아웃');
const pivotTable = pivotSheet.pivotTables.add(
'layoutPivot', 'salesTable5', 1, 1,
GC.Spread.Pivot.PivotTableLayoutType.compact,
GC.Spread.Pivot.PivotTableThemes.medium2
);
pivotTable.suspendLayout();
pivotTable.options.showRowHeader = true;
pivotTable.options.showColumnHeader = true;
pivotTable.add('지역', '지역', GC.Spread.Pivot.PivotTableFieldType.rowField);
pivotTable.add('제품', '제품', GC.Spread.Pivot.PivotTableFieldType.rowField);
pivotTable.add('분기', '분기', GC.Spread.Pivot.PivotTableFieldType.columnField);
pivotTable.add('매출액', '합계 (매출액)', GC.Spread.Pivot.PivotTableFieldType.valueField, GC.Pivot.SubtotalType.sum);
pivotTable.resumeLayout();
pivotTable.autoFitColumn();
// 레이아웃 전환 + 버튼 활성화 상태 관리
const layoutBtns = ['btnCompact', 'btnOutline', 'btnTabular'];
function setLayoutActive(activeId) {
layoutBtns.forEach(id => {
const el = document.getElementById(id);
if (id === activeId) {
el.style.background = '#1565C0';
el.style.color = '#fff';
el.style.border = 'none';
} else {
el.style.background = '';
el.style.color = '';
el.style.border = '1px solid #bbb';
}
});
}
document.getElementById('btnCompact')?.addEventListener('click', () => {
pivotTable.layoutType(GC.Spread.Pivot.PivotTableLayoutType.compact);
pivotTable.autoFitColumn();
setLayoutActive('btnCompact');
});
document.getElementById('btnOutline')?.addEventListener('click', () => {
pivotTable.layoutType(GC.Spread.Pivot.PivotTableLayoutType.outline);
pivotTable.autoFitColumn();
setLayoutActive('btnOutline');
});
document.getElementById('btnTabular')?.addEventListener('click', () => {
pivotTable.layoutType(GC.Spread.Pivot.PivotTableLayoutType.tabular);
pivotTable.autoFitColumn();
setLayoutActive('btnTabular');
});
// 값 영역에 3색 컬러 스케일 조건부 서식 적용
document.getElementById('btnConditional')?.addEventListener('click', () => {
pivotTable.addConditionalRule(
[{ dataOnly: true }],
new GC.Spread.Sheets.ConditionalFormatting.ScaleRule(
GC.Spread.Sheets.ConditionalFormatting.RuleType.threeScaleRule,
1, 0, '#FFEB3B', // LowestValue → 노랑
0, 9000000, '#FF9800', // Number → 주황
2, 0, '#F44336' // HighestValue → 빨강
)
);
});