JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
// ✅ C1: 올바른 탭 색상 설정 (tabColor() 함수는 v19에 없음)
spread.suspendPaint();
sheet.options.sheetTabColor = '#1976D2';
sheet.name('v19 API 가이드');
spread.resumePaint();
// 헤더
['번호', '잘못된 패턴 (AI 생성)', '올바른 v19 코드'].forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#37474F').foreColor('#FFFFFF').font('bold 11px sans-serif');
});
const rows = [
['C1', 'sheet.options.sheetTabColor = "#f00"', "sheet.options.sheetTabColor = '#f00'"],
['C2', 'spread.moveSheet(0, 1)', 'spread.changeSheetIndex("sheet1", 3)'],
['C3', "spread.save('report.xlsx')", 'spread.export(cb, errCb, {fileType:...})'],
['C4', 'DataOrientation.Horizontal', 'DataOrientation.horizontal (소문자)'],
['C5', "new GC.Spread.Excel.IO()", 'IO 플러그인 import 후 사용'],
];
rows.forEach((row, r) => {
sheet.setValue(r + 1, 0, row[0]);
sheet.setValue(r + 1, 1, row[1]);
sheet.setValue(r + 1, 2, row[2]);
sheet.getCell(r + 1, 1).backColor('#FFEBEE').foreColor('#C62828');
sheet.getCell(r + 1, 2).backColor('#E8F5E9').foreColor('#1B5E20');
});
[50, 210, 220].forEach((w, c) => sheet.setColumnWidth(c, w));
sheet.setRowHeight(0, 34);
for (let r = 1; r <= rows.length; r++) sheet.setRowHeight(r, 30);
spread.options.tabStripVisible = true;