JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = false;
const sheet = spread.getActiveSheet();
// PDF 한글 폰트 사전 로드 (NanumGothic) — 기본 PDF 폰트는 CJK 미지원
const KOREAN_FONT_URLS = [
'https://cdn.jsdelivr.net/gh/google/fonts@main/ofl/nanumgothic/NanumGothic-Regular.ttf',
'https://cdn.jsdelivr.net/gh/google/fonts@main/ofl/notosanskr/NotoSansKR-Regular.ttf'
];
function isValidTTF(buf) {
if (buf.byteLength < 4) return false;
const sig = new DataView(buf).getUint32(0, false);
return sig === 0x00010000 || sig === 0x4F54544F || sig === 0x74727565;
}
const koreanFontPromise = (async () => {
for (const url of KOREAN_FONT_URLS) {
try {
const r = await fetch(url);
if (!r.ok) { console.warn('[PDF 폰트] HTTP', r.status, url); continue; }
const buf = await r.arrayBuffer();
if (!isValidTTF(buf)) { console.warn('[PDF 폰트] 유효하지 않은 TTF:', url); continue; }
GC.Spread.Sheets.PDF.PDFFontsManager.registerFont('NanumGothic', { normal: buf });
GC.Spread.Sheets.PDF.PDFFontsManager.fallbackFont = function() { return buf; };
console.log('[PDF 폰트] 로드 완료:', url);
return;
} catch (e) {
console.warn('[PDF 폰트] 로드 실패:', e.message);
}
}
console.warn('[PDF 폰트] 모든 URL 실패 — 기본 폰트로 PDF 생성');
})();
// 보고서 타이틀 행
sheet.setValue(0, 0, '○○시청 2024년도 예산 집행 현황 보고');
sheet.addSpan(0, 0, 1, 5);
sheet.getCell(0, 0)
.backColor('#1A237E').foreColor('#FFFFFF')
.fontWeight('bold').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.setRowHeight(0, 46);
// 헤더
const headers = ['부서명', '예산액(천원)', '집행액(천원)', '잔액(천원)', '집행률(%)'];
headers.forEach((h, c) => {
sheet.setValue(1, c, h);
sheet.getCell(1, c)
.backColor('#283593').foreColor('#FFFFFF')
.fontWeight('bold').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.setColumnWidth(c, c === 0 ? 120 : 108);
});
sheet.setRowHeight(1, 32);
// 데이터
const reportData = [
['총무과', 420000, 318500],
['기획예산과', 288000, 220800],
['주민복지과', 915000, 712400],
['건설도시과', 1398000, 486000],
['환경위생과', 575000, 398200],
['경제문화과', 349000, 275600],
['보건의료과', 742000, 612300],
];
reportData.forEach((row, r) => {
const ri = r + 2;
sheet.setValue(ri, 0, row[0]);
sheet.setValue(ri, 1, row[1]);
sheet.setValue(ri, 2, row[2]);
sheet.setFormula(ri, 3, `=B${ri+1}-C${ri+1}`);
sheet.setFormula(ri, 4, `=ROUND(C${ri+1}/B${ri+1}*100,1)`);
[1,2,3].forEach(c => {
sheet.getCell(ri, c).formatter('#,##0').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
});
sheet.getCell(ri, 4).formatter('0.0').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.getCell(ri, 0).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
const bg = r % 2 === 0 ? '#FFFFFF' : '#F5F5F5';
for (let c = 0; c < 5; c++) sheet.getCell(ri, c).backColor(bg);
sheet.setRowHeight(ri, 28);
});
// 합계 행
const sumRow = reportData.length + 2;
sheet.setValue(sumRow, 0, '합 계');
['B','C','D'].forEach((col, i) => {
sheet.setFormula(sumRow, i + 1, `=SUM(${col}3:${col}${sumRow})`);
sheet.getCell(sumRow, i + 1).formatter('#,##0').hAlign(GC.Spread.Sheets.HorizontalAlign.right);
});
sheet.setFormula(sumRow, 4, `=ROUND(C${sumRow+1}/B${sumRow+1}*100,1)`);
sheet.getCell(sumRow, 4).formatter('0.0').hAlign(GC.Spread.Sheets.HorizontalAlign.center);
sheet.getCell(sumRow, 0).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
for (let c = 0; c < 5; c++) {
sheet.getCell(sumRow, c).backColor('#E3F2FD').fontWeight('bold');
}
sheet.setRowHeight(sumRow, 34);
// 인쇄 설정 (공문서 형식)
const printInfo = sheet.printInfo();
printInfo.showGridLine(false);
printInfo.showRowHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);
printInfo.showColumnHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);
sheet.printInfo(printInfo);
// PDF 내보내기 버튼
const pdfStatus = document.getElementById('pdfStatus');
document.getElementById('btnPdf')?.addEventListener('click', async () => {
pdfStatus.textContent = 'PDF 생성 중...';
await koreanFontPromise; // 한글 폰트 로드 대기
spread.savePDF((blob) => {
const url = URL.createObjectURL(blob);
const a = document.createElement('a');
a.href = url;
a.download = '예산집행현황_보고서.pdf';
a.click();
URL.revokeObjectURL(url);
pdfStatus.textContent = '✅ PDF 저장 완료!';
}, (e) => {
pdfStatus.textContent = '오류: ' + (e.errorMessage || e);
console.error(e);
}, {
title: '2024년도 예산 집행 현황',
author: '기획예산과',
subject: '예산 집행 현황 보고서'
});
});