JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
sheet.suspendPaint();
// 타이틀 행
sheet.setValue(0, 0, '○○건설 신축공사 공사비 내역서');
sheet.addSpan(0, 0, 1, 6);
sheet.getCell(0, 0).font('bold 14px sans-serif').hAlign(1).backColor('#1565C0').foreColor('#fff');
sheet.setRowHeight(0, 44);
// 헤더
const hdr = ['항목', '규격', '단위', '수량', '단가(원)', '금액(원)'];
hdr.forEach((h, c) => {
sheet.setValue(1, c, h);
sheet.getCell(1, c).backColor('#455A64').foreColor('#fff').font('bold 11px sans-serif').hAlign(1);
sheet.setColumnWidth(c, c === 0 ? 185 : c === 5 ? 120 : 82);
});
sheet.setRowHeight(1, 34);
const items = [
['토공사', '일식', '식', 1, 14710000],
['RC공사', '일식', '식', 1, 32525000],
['조적공사', 'ALC', 'm²', 250, 95000],
['미장공사', '시멘트','m²', 450, 22000],
['타일공사', '300×300','m²',180, 65000],
['도장공사', '2회', 'm²', 380, 18000],
['창호공사', '알루미늄','개소',12, 850000],
['전기설비공사','일식', '식', 1, 18000000],
];
items.forEach(([name, spec, unit, qty, price], r) => {
const row = r + 2;
sheet.setValue(row, 0, name);
sheet.setValue(row, 1, spec);
sheet.setValue(row, 2, unit);
sheet.setValue(row, 3, qty);
sheet.setValue(row, 4, price);
sheet.setFormula(row, 5, '=D' + (row + 1) + '*E' + (row + 1));
sheet.getCell(row, 4).formatter('#,##0');
sheet.getCell(row, 5).formatter('#,##0');
sheet.setRowHeight(row, 30);
if (r % 2 === 0) for (let c = 0; c < 6; c++) sheet.getCell(row, c).backColor('#F5F5F5');
});
const sumRow = items.length + 2;
sheet.setValue(sumRow, 0, '공사비 합계');
sheet.setFormula(sumRow, 5, '=SUM(F3:F' + sumRow + ')');
sheet.getCell(sumRow, 5).formatter('#,##0').font('bold 13px sans-serif');
for (let c = 0; c < 6; c++) sheet.getCell(sumRow, c).backColor('#E3F2FD').font('bold 12px sans-serif');
sheet.setRowHeight(sumRow, 38);
// ─── PrintInfo 설정 ───
const pi = new GC.Spread.Sheets.Print.PrintInfo();
pi.orientation(2); // 2 = Landscape
pi.repeatRowStart(1); // 컬럼 헤더 행 반복 출력
pi.repeatRowEnd(1);
pi.pageHeaderFooter({
normal: {
header: { left: '○○건설 신축공사', center: '공사비 내역서', right: '&D' },
footer: { left: '대외비', center: '&P / &N 페이지', right: 'SpreadJS' }
}
});
sheet.printInfo(pi);
sheet.resumePaint();
document.getElementById('btnPrint')?.addEventListener('click', () => spread.print(0));