JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
const labels = ['1월','2월','3월','4월','5월','6월'];
const initial = [3200, 3580, 3920, 4150, 3870, 4420];
sheet.setValue(0, 0, '월');
sheet.setValue(0, 1, '매출(만원)');
[0, 1].forEach(c => {
sheet.getCell(0, c).backColor('#1565C0').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, c === 0 ? 60 : 100);
});
labels.forEach((l, r) => {
sheet.setValue(r + 1, 0, l);
sheet.setValue(r + 1, 1, initial[r]);
});
sheet.setRowHeight(0, 32);
sheet.charts.add(
'liveChart',
GC.Spread.Sheets.Charts.ChartType.columnClustered,
190, 0, 380, 250,
'A1:B7',
GC.Spread.Sheets.Charts.RowCol.columns
);
// CellChanged — 차트는 자동 갱신, 여기서는 상태 메시지 출력만
sheet.bind(GC.Spread.Sheets.Events.CellChanged, function(sender, args) {
if (args.propertyName === 'value' && args.col === 1 && args.row > 0) {
document.getElementById('statusMsg').textContent =
labels[args.row - 1] + ' 매출 → ' + sheet.getValue(args.row, 1).toLocaleString() + '만원으로 업데이트됨';
}
});
document.getElementById('btnUpdate')?.addEventListener('click', () => {
const month = parseInt(document.getElementById('monthSel').value, 10);
const val = parseInt(document.getElementById('valInput').value, 10);
if (!isNaN(val) && val >= 0) sheet.setValue(month, 1, val);
});