JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = false;
const sheet = spread.getActiveSheet();
spread.suspendPaint();
const headers = ['작업 항목', '담당자', '진행 상태', '완료 여부'];
const widths = [170, 100, 120, 90];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.setColumnWidth(c, widths[c]);
sheet.getCell(0, c).backColor('#4527A0').foreColor('#FFFFFF').font('bold 12px sans-serif').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
});
sheet.setRowHeight(0, 36);
const tasks = ['원자재 입고 검사', '절단 가공 준비', '용접 작업', '도장 전처리', '최종 품질 검사'];
const workers = ['김민준', '이서연', '박지호', '최유진', '정수민'];
const statuses = ['완료', '완료', '진행중', '대기', '대기'];
const done = [true, true, false, false, false];
tasks.forEach((task, r) => {
sheet.setValue(r + 1, 0, task);
sheet.setValue(r + 1, 1, workers[r]);
sheet.setValue(r + 1, 2, statuses[r]);
sheet.setValue(r + 1, 3, done[r]);
sheet.setRowHeight(r + 1, 32);
[0,1,2,3].forEach(c =>
sheet.getCell(r+1,c).hAlign(GC.Spread.Sheets.HorizontalAlign.center).vAlign(GC.Spread.Sheets.VerticalAlign.center)
);
});
// ComboBox: 진행 상태 컬럼 (col 2)
const combo = new GC.Spread.Sheets.CellTypes.ComboBox();
combo.items([
{ text: '대기', value: '대기' },
{ text: '진행중', value: '진행중' },
{ text: '완료', value: '완료' },
{ text: '지연', value: '지연' },
]);
combo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
for (let r = 1; r <= 5; r++) {
sheet.setCellType(r, 2, combo, GC.Spread.Sheets.SheetArea.viewport);
}
// CheckBox: 완료 여부 컬럼 (col 3)
const checkBox = new GC.Spread.Sheets.CellTypes.CheckBox();
checkBox.caption('');
for (let r = 1; r <= 5; r++) {
sheet.setCellType(r, 3, checkBox, GC.Spread.Sheets.SheetArea.viewport);
}
spread.resumePaint();