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('슬라이서');
pivotSheet.options.gridline = { showVerticalGridline: false, showHorizontalGridline: false };
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뷰어', 'Q1', 4500000],
['대구', '스프레드시트', 'Q2', 10500000],
['대구', 'PDF뷰어', 'Q2', 5200000],
];
dataSheet.setArray(0, 0, salesData);
dataSheet.tables.add('salesTable4', 0, 0, salesData.length, 4);
spread.setActiveSheet('슬라이서');
const pivotTable = pivotSheet.pivotTables.add(
'slicerPivot', 'salesTable4', 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.columnField);
pivotTable.add('매출액', '합계 (매출액)', GC.Spread.Pivot.PivotTableFieldType.valueField, GC.Pivot.SubtotalType.sum);
pivotTable.resumeLayout();
pivotTable.autoFitColumn();
// 지역 슬라이서 추가
const slicerRegion = pivotSheet.slicers.add(
'slicerRegion',
pivotTable.name(),
'지역',
GC.Spread.Sheets.Slicers.SlicerStyles.light4(),
GC.Spread.Sheets.Slicers.SlicerType.pivotTable
);
slicerRegion.startRow(1);
slicerRegion.startColumn(5);
slicerRegion.startRowOffset(0);
slicerRegion.startColumnOffset(0);
slicerRegion.width(160);
slicerRegion.height(180);
// 제품 슬라이서 추가
const slicerProduct = pivotSheet.slicers.add(
'slicerProduct',
pivotTable.name(),
'제품',
GC.Spread.Sheets.Slicers.SlicerStyles.light1(),
GC.Spread.Sheets.Slicers.SlicerType.pivotTable
);
slicerProduct.startRow(8);
slicerProduct.startColumn(5);
slicerProduct.startRowOffset(0);
slicerProduct.startColumnOffset(0);
slicerProduct.width(160);
slicerProduct.height(130);