const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const migrateStatus = document.getElementById('migrateStatus');
// Luckysheet celldata 구조 예시 (실제 Luckysheet에서 추출한 포맷)
const luckysheetData = {
name: '매출현황',
celldata: [
{ r: 0, c: 0, v: { v: '제품명', ct: { fa: 'General', t: 'g' }, bl: 1, bg: '#1565C0', fc: '#ffffff' } },
{ r: 0, c: 1, v: { v: '1분기', ct: { fa: 'General', t: 'g' }, bl: 1, bg: '#1565C0', fc: '#ffffff' } },
{ r: 0, c: 2, v: { v: '2분기', ct: { fa: 'General', t: 'g' }, bl: 1, bg: '#1565C0', fc: '#ffffff' } },
{ r: 0, c: 3, v: { v: '3분기', ct: { fa: 'General', t: 'g' }, bl: 1, bg: '#1565C0', fc: '#ffffff' } },
{ r: 1, c: 0, v: { v: 'SpreadJS' } }, { r: 1, c: 1, v: { v: 4500 } }, { r: 1, c: 2, v: { v: 5200 } }, { r: 1, c: 3, v: { v: 6100 } },
{ r: 2, c: 0, v: { v: 'Luckysheet' } }, { r: 2, c: 1, v: { v: 1200 } }, { r: 2, c: 2, v: { v: 800 } }, { r: 2, c: 3, v: { v: 300 } },
{ r: 3, c: 0, v: { v: 'Univer' } }, { r: 3, c: 1, v: { v: 900 } }, { r: 3, c: 2, v: { v: 1100 } }, { r: 3, c: 3, v: { v: 1400 } },
],
row: 10,
column: 6,
};
// Luckysheet celldata → SpreadJS 변환 함수
function migrateLuckysheetToSpreadJS(lsData, targetSpread) {
const sheet = targetSpread.getActiveSheet();
sheet.name(lsData.name || 'Sheet1');
lsData.celldata.forEach(({ r, c, v }) => {
if (!v) return;
const cellVal = (v.f) ? null : v.v; // 수식은 별도 처리
if (cellVal !== undefined && cellVal !== null) sheet.setValue(r, c, cellVal);
if (v.f) sheet.setFormula(r, c, v.f.replace(/^=/, ''));
const cell = sheet.getCell(r, c);
// 배경색/글자색 매핑
if (v.bg) cell.backColor(v.bg);
if (v.fc) cell.foreColor(v.fc);
if (v.bl) cell.font(`bold 12px sans-serif`);
// 숫자 서식 매핑
if (v.ct && v.ct.fa && v.ct.fa !== 'General') cell.formatter(v.ct.fa);
});
}
const btnLoad = document.getElementById('btnLoad');
if (btnLoad) {
btnLoad.addEventListener('click', () => {
spread.options.tabStripVisible = false;
migrateLuckysheetToSpreadJS(luckysheetData, spread);
// 열 너비 정리
const sheet = spread.getActiveSheet();
sheet.setColumnWidth(0, 100);
[1, 2, 3].forEach(c => sheet.setColumnWidth(c, 80));
sheet.setRowHeight(0, 36);
if (migrateStatus) migrateStatus.textContent = '✅ Luckysheet → SpreadJS 변환 완료';
});
}