const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
// 초기 시트 구성
const sheet1 = spread.getActiveSheet();
sheet1.name('1월');
['항목', '매출(원)'].forEach((h, c) => {
sheet1.setValue(0, c, h);
sheet1.getCell(0, c).backColor('#1565C0').foreColor('#fff').font('bold 12px sans-serif');
});
[['서울', 3200000], ['부산', 1800000], ['대구', 1100000]].forEach(([r, v], i) => {
sheet1.setValue(i + 1, 0, r); sheet1.setValue(i + 1, 1, v);
});
sheet1.setColumnWidth(0, 80); sheet1.setColumnWidth(1, 130);
const sheet2 = new GC.Spread.Sheets.Worksheet('2월');
spread.addSheet(1, sheet2);
['항목', '매출(원)'].forEach((h, c) => {
sheet2.setValue(0, c, h);
sheet2.getCell(0, c).backColor('#00695C').foreColor('#fff').font('bold 12px sans-serif');
});
[['서울', 4100000], ['부산', 2200000], ['대구', 1400000]].forEach(([r, v], i) => {
sheet2.setValue(i + 1, 0, r); sheet2.setValue(i + 1, 1, v);
});
sheet2.setColumnWidth(0, 80); sheet2.setColumnWidth(1, 130);
// 시트 추가
document.getElementById('btnAdd')?.addEventListener('click', () => {
const count = spread.getSheetCount();
const newSheet = new GC.Spread.Sheets.Worksheet(`시트${count + 1}`);
newSheet.setValue(0, 0, '새 시트가 추가되었습니다.');
spread.addSheet(count, newSheet);
spread.setActiveSheetIndex(count);
});
// 현재 시트 삭제 (최소 1개 유지)
document.getElementById('btnRemove')?.addEventListener('click', () => {
if (spread.getSheetCount() <= 1) return;
const idx = spread.getActiveSheetIndex();
spread.removeSheet(idx);
spread.setActiveSheetIndex(Math.max(0, idx - 1));
});
// 현재 시트 이름 변경
document.getElementById('btnRename')?.addEventListener('click', () => {
const input = document.getElementById('sheetName');
const newName = input.value.trim();
if (!newName) return;
spread.getActiveSheet().name(newName);
input.value = '';
});