const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
spread.suspendPaint();
const months = ['1월', '2월', '3월', '4월', '5월'];
sheet.setArray(0, 0, [['월', '실적(백만원)']]);
months.forEach((m, i) => {
sheet.setValue(i + 1, 0, m);
sheet.setValue(i + 1, 1, Math.round(800 + Math.random() * 600));
});
const chart = sheet.charts.add(
'LiveChart',
GC.Spread.Sheets.Charts.ChartType.columnClustered,
0, 50, 660, 300,
'A1:B6'
);
chart.title({ text: '월별 실적 — 버튼 클릭 시 자동 갱신' });
spread.resumePaint();
document.getElementById('btnUpdate')?.addEventListener('click', () => {
months.forEach((_, i) => {
sheet.setValue(i + 1, 1, Math.round(800 + Math.random() * 600));
});
});