const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'), { sheetCount: 2 });
// 데이터 시트 설정
const dataSheet = spread.getSheet(0);
dataSheet.name('데이터');
dataSheet.options.sheetTabColor = '#1976D2';
const headers = ['점포명', '월', '매출액', '목표액'];
const rawData = [
['강남점', '1월', 8400, 8000], ['강남점', '2월', 7900, 8000], ['강남점', '3월', 9200, 8500],
['홍대점', '1월', 6100, 6500], ['홍대점', '2월', 6800, 6500], ['홍대점', '3월', 7200, 7000],
['신촌점', '1월', 5300, 5500], ['신촌점', '2월', 5700, 5500], ['신촌점', '3월', 6100, 6000],
['부산점', '1월', 7200, 7000], ['부산점', '2월', 7600, 7000], ['부산점', '3월', 8100, 8000],
['대구점', '1월', 5900, 6000], ['대구점', '2월', 6200, 6000], ['대구점', '3월', 6700, 6500],
];
dataSheet.setArray(0, 0, [headers, ...rawData]);
dataSheet.tables.add('salesTable', 0, 0, rawData.length + 1, 4);
// 피벗 시트 설정
const pivotSheet = spread.getSheet(1);
pivotSheet.name('피벗분석');
pivotSheet.options.sheetTabColor = '#388E3C';
spread.setActiveSheetIndex(1);
const pt = pivotSheet.pivotTables.add(
'kpiPivot', 'salesTable', 1, 1,
GC.Spread.Pivot.PivotTableLayoutType.outline,
GC.Spread.Pivot.PivotTableThemes.medium2
);
pt.add('점포명', '점포명', GC.Spread.Pivot.PivotTableFieldType.rowField);
pt.add('월', '월', GC.Spread.Pivot.PivotTableFieldType.columnField);
pt.add('매출액', '매출액 합계', GC.Spread.Pivot.PivotTableFieldType.valueField, GC.Pivot.SubtotalType.sum);
for (let i = 1; i <= 5; i++) pivotSheet.autoFitColumn(i);