JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = false;
const sheet = spread.getActiveSheet();
const depts = ['개발', '기획', '영업', '디자인', 'QA'];
const regions = ['서울', '경기', '부산', '대전', '광주'];
const headers = ['행 번호', '이름', '부서', '연봉(만원)', '입사년도', '지역'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#37474F').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, c === 1 ? 90 : c === 2 ? 100 : 90);
});
sheet.setRowHeight(0, 34);
document.getElementById('btnLoad')?.addEventListener('click', () => {
const COUNT = 10000;
document.getElementById('loadInfo').textContent = '로딩 중…';
const t0 = Date.now();
// suspendPaint: 렌더링 일시 중단 → 대량 setValue 성능 핵심
spread.suspendPaint();
sheet.setRowCount(COUNT + 1); // 행 수 미리 확보 → 동적 확장 비용 제거
for (let r = 0; r < COUNT; r++) {
sheet.setValue(r + 1, 0, r + 1);
sheet.setValue(r + 1, 1, '사용자' + (r + 1));
sheet.setValue(r + 1, 2, depts[r % 5]);
sheet.setValue(r + 1, 3, 3000 + Math.floor(Math.random() * 5000));
sheet.setValue(r + 1, 4, 2015 + (r % 10));
sheet.setValue(r + 1, 5, regions[r % 5]);
}
spread.resumePaint(); // 한 번에 렌더링
const elapsed = Date.now() - t0;
document.getElementById('loadInfo').textContent =
`✅ ${COUNT.toLocaleString()}행 로드 완료 (${elapsed}ms) — 스크롤해보세요`;
});