const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 헤더 설정
const cols = ['사원명', '부서', '직급', '근무지'];
cols.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#4A148C').foreColor('#fff').font('bold 13px sans-serif').hAlign(1);
sheet.setColumnWidth(c, 130);
});
sheet.setRowHeight(0, 36);
// 부서 콤보박스 (정적 목록)
const deptCombo = new GC.Spread.Sheets.CellTypes.ComboBox();
deptCombo.items(['개발팀', '기획팀', '디자인팀', '영업팀', '경영지원팀']);
deptCombo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
deptCombo.itemHeight(28);
// 직급 콤보박스 (text/value 구조)
const rankCombo = new GC.Spread.Sheets.CellTypes.ComboBox();
rankCombo.items([
{ text: '사원', value: 1 }, { text: '대리', value: 2 },
{ text: '과장', value: 3 }, { text: '차장', value: 4 },
{ text: '부장', value: 5 }
]);
rankCombo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
// 근무지 콤보박스 — fetch 시뮬레이션 (실제 사용 시 fetch(url) 로 교체)
const locationCombo = new GC.Spread.Sheets.CellTypes.ComboBox();
const mockApiResponse = [
{ name: '서울 본사', code: 'SEL' }, { name: '부산 지점', code: 'PUS' },
{ name: '대구 지점', code: 'TAE' }, { name: '인천 지점', code: 'ICN' }
];
Promise.resolve(mockApiResponse).then(data => {
locationCombo.items(data.map(d => ({ text: d.name, value: d.code })));
locationCombo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.value);
// 실제 코드: fetch('/api/locations').then(r=>r.json()).then(data => {...})
});
const sampleData = [
['김민준', '개발팀', '대리', 'SEL'],
['이서연', '기획팀', '과장', 'PUS'],
['박지호', '영업팀', '사원', 'ICN'],
];
sampleData.forEach(([name, dept, rank, loc], r) => {
sheet.setValue(r + 1, 0, name);
sheet.setValue(r + 1, 1, dept);
sheet.getCell(r + 1, 1).cellType(deptCombo);
sheet.setValue(r + 1, 2, rank);
sheet.getCell(r + 1, 2).cellType(rankCombo);
sheet.setValue(r + 1, 3, loc);
sheet.getCell(r + 1, 3).cellType(locationCombo);
sheet.setRowHeight(r + 1, 34);
});