JavaScript
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('salesTable2', 0, 0, salesData.length, 4);
spread.setActiveSheet('집계전환');
const pivotTable = pivotSheet.pivotTables.add(
'aggrPivot', 'salesTable2', 1, 1,
GC.Spread.Pivot.PivotTableLayoutType.compact,
GC.Spread.Pivot.PivotTableThemes.medium4
);
pivotTable.suspendLayout();
pivotTable.options.showRowHeader = true;
pivotTable.options.showColumnHeader = true;
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 typeMap = {
btnSum: GC.Pivot.SubtotalType.sum,
btnCount: GC.Pivot.SubtotalType.count,
btnAvg: GC.Pivot.SubtotalType.average,
btnMax: GC.Pivot.SubtotalType.max,
btnMin: GC.Pivot.SubtotalType.min,
};
function setActiveBtn(activeId) {
Object.keys(typeMap).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';
}
});
}
Object.keys(typeMap).forEach(id => {
document.getElementById(id)?.addEventListener('click', () => {
pivotTable.subTotalType('집계값', typeMap[id]);
pivotTable.autoFitColumn();
setActiveBtn(id);
});
});