const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 샘플 손익계산서 데이터
const headers = ['항목', '전월 실적', '당월 실적', '증감'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#004D40').foreColor('#fff').font('bold 12px sans-serif').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.setColumnWidth(c, c === 0 ? 160 : 130);
});
sheet.setRowHeight(0, 36);
const rows = [
['매출액', 85000000, 92000000],
['매출원가', 51000000, 55200000],
['매출총이익', null, null],
['판매관리비', 18000000, 19500000],
['영업이익', null, null],
];
rows.forEach((row, r) => {
sheet.setValue(r + 1, 0, row[0]);
if (row[1] !== null) {
sheet.setValue(r + 1, 1, row[1]);
sheet.setValue(r + 1, 2, row[2]);
}
const isSummary = row[0].includes('이익') || row[0].includes('총');
if (isSummary) {
if (row[0] === '매출총이익') {
sheet.setFormula(r + 1, 1, '=B2-B3');
sheet.setFormula(r + 1, 2, '=C2-C3');
} else if (row[0] === '영업이익') {
sheet.setFormula(r + 1, 1, '=B4-B5');
sheet.setFormula(r + 1, 2, '=C4-C5');
}
for (let c = 0; c < 4; c++) sheet.getCell(r + 1, c).backColor('#E0F2F1').font('bold 12px sans-serif');
} else {
for (let c = 0; c < 4; c++) sheet.getCell(r + 1, c).backColor(r % 2 === 0 ? '#FAFAFA' : '#fff');
}
sheet.setFormula(r + 1, 3, `=C${r+2}-B${r+2}`);
for (let c = 1; c <= 3; c++) sheet.getCell(r + 1, c).formatter('#,##0').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
});
sheet.setRowHeight(5, 36);
// xlsx 내보내기 버튼
const btn = document.getElementById('btnExport');
const lbl = document.getElementById('lblStatus');
if (btn) {
btn.addEventListener('click', () => {
if (lbl) lbl.textContent = '내보내는 중...';
spread.export(
(blob) => {
const url = URL.createObjectURL(blob);
const a = document.createElement('a');
a.href = url;
a.download = `월결산_손익계산서_${new Date().toISOString().slice(0,7)}.xlsx`;
a.click();
URL.revokeObjectURL(url);
if (lbl) lbl.textContent = '✅ 내보내기 완료!';
},
(err) => {
if (lbl) lbl.textContent = '오류: ' + err;
},
{ fileType: GC.Spread.Sheets.FileType.excel }
);
});
}