const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 데이터 입력
const headers = ['분기', '서울', '부산', '대구'];
const data = [
['Q1', 1200, 850, 620],
['Q2', 1450, 920, 710],
['Q3', 1380, 1050, 680],
['Q4', 1620, 1180, 790],
];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#1565C0').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, c === 0 ? 60 : 85);
});
data.forEach((row, r) => row.forEach((v, c) => sheet.setValue(r + 1, c, v)));
sheet.setRowHeight(0, 32);
// 묶음 세로 막대(Bar) 차트 추가
const chart = sheet.charts.add(
'salesChart',
GC.Spread.Sheets.Charts.ChartType.columnClustered,
0, 125, 560, 310,
'A1:D5',
GC.Spread.Sheets.Charts.RowCol.rows
);
chart.title({ text: '지역별 분기 매출' });