JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
sheet.suspendPaint();
// 보고서 제목 (셀 병합)
sheet.addSpan(0, 0, 1, 6);
sheet.getCell(0, 0).value('투자 포트폴리오 분석 보고서').font('bold 16px sans-serif').foreColor('#1565C0').hAlign(GC.Spread.Sheets.HorizontalAlign.left);
sheet.setRowHeight(0, 44);
const headers = ['종목명', '매수가', '현재가', '수량', '수익률(%)', '평가손익'];
headers.forEach((h, c) => {
sheet.getCell(2, c).value(h).backColor('#37474F').foreColor('#fff').font('bold 12px sans-serif').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.setColumnWidth(c, c === 0 ? 130 : 100);
});
sheet.setRowHeight(2, 32);
const report = [
['삼성전자', 60500, 79800, 50, 31.9, 968500],
['SK하이닉스', 88000, 175000, 20, 98.9, 1740000],
['NAVER', 210000, 188000, 15, -10.5, -330000],
['카카오', 55000, 44500, 80, -19.1, -840000],
['현대차', 178000, 255000, 30, 43.3, 2310000],
['셀트리온', 185000, 210000, 25, 13.5, 625000],
];
report.forEach(([name, buy, cur, qty, ret, pnl], r) => {
const row = r + 3;
[name, buy, cur, qty, ret, pnl].forEach((v, c) => sheet.setValue(row, c, v));
sheet.getCell(row, 1).formatter('#,##0');
sheet.getCell(row, 2).formatter('#,##0');
sheet.getCell(row, 4).formatter('0.00');
sheet.getCell(row, 5).formatter('#,##0');
const bg = pnl >= 0 ? '#E8F5E9' : '#FFEBEE';
for (let c = 0; c < 6; c++) sheet.getCell(row, c).backColor(bg);
});
sheet.resumePaint();
// Excel 내보내기
document.getElementById('btnExport')?.addEventListener('click', () => {
spread.export(
blob => {
const url = URL.createObjectURL(blob);
const a = document.createElement('a');
a.href = url;
a.download = 'portfolio_report.xlsx';
a.click();
URL.revokeObjectURL(url);
},
e => console.error(e),
{ fileType: GC.Spread.Sheets.FileType.excel }
);
});