const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = false;
const sheet = spread.getActiveSheet();
const dataManager = spread.dataManager();
// GraphQL 응답 시뮬레이션
const mockGqlResponse = {
data: {
employees: [
{ id: 1, name: '김민준', department: '개발팀', salary: 5800000, hireDate: '2021-03-15' },
{ id: 2, name: '이서연', department: '기획팀', salary: 4900000, hireDate: '2020-07-01' },
{ id: 3, name: '박지호', department: '개발팀', salary: 6200000, hireDate: '2019-11-20' },
{ id: 4, name: '최유진', department: '디자인팀', salary: 5100000, hireDate: '2022-01-10' },
{ id: 5, name: '정수민', department: '개발팀', salary: 7000000, hireDate: '2018-05-30' },
{ id: 6, name: '한도현', department: '영업팀', salary: 4700000, hireDate: '2023-02-14' },
]
}
};
// remote.read를 함수로 지정 → GraphQL 응답의 중첩 배열 추출 후 반환
const empTable = dataManager.addTable('employees', {
remote: {
read: function () {
// 실제 환경: fetch('/graphql', {...}).then(r=>r.json()).then(j=>j.data.employees)
return Promise.resolve(mockGqlResponse.data.employees);
}
}
});
empTable.fetch().then(() => {
const table = sheet.tables.addFromDataSource(
'empTable', 0, 0, 'employees',
GC.Spread.Sheets.Tables.TableThemes.medium7
);
[50, 90, 90, 120, 110].forEach((w, i) => sheet.setColumnWidth(i, w));
sheet.getRange(1, 3, 10, 1).formatter('₩#,##0');
});