JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
sheet.suspendPaint();
const colHeaders = ['공종/공사명', '규격', '단위', '수량', '단가(원)', '금액(원)'];
const colWidths = [190, 90, 58, 65, 110, 120];
colHeaders.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.setColumnWidth(c, colWidths[c]);
sheet.getCell(0, c).backColor('#1565C0').foreColor('#fff').font('bold 12px sans-serif').hAlign(1);
});
sheet.setRowHeight(0, 38);
sheet.setRowCount(20);
function setGroupHeader(row, label) {
sheet.setValue(row, 0, label);
for (let c = 0; c < 6; c++) sheet.getCell(row, c).backColor('#CFD8DC').font('bold 12px sans-serif');
sheet.setRowHeight(row, 36);
}
function setDetailRow(row, name, spec, unit, qty, price) {
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, 3).hAlign(2);
sheet.getCell(row, 4).formatter('#,##0');
sheet.getCell(row, 5).formatter('#,##0');
sheet.setRowHeight(row, 32);
}
function setSubtotalRow(row, startRow, endRow) {
sheet.setValue(row, 0, '소 계');
sheet.setFormula(row, 5, '=SUM(F' + (startRow + 1) + ':F' + (endRow + 1) + ')');
sheet.getCell(row, 5).formatter('#,##0').font('bold 11px sans-serif');
for (let c = 0; c < 6; c++) sheet.getCell(row, c).backColor('#ECEFF1').font('bold 11px sans-serif');
sheet.setRowHeight(row, 34);
}
// ─── 토공사 ───
setGroupHeader(1, '▶ 토공사');
setDetailRow(2, '지반굴착', '보통토', 'm³', 250, 35000);
setDetailRow(3, '되메우기', '보통토', 'm³', 80, 15000);
setDetailRow(4, '잔토처리', '트럭운반', 'm³', 170, 28000);
setSubtotalRow(5, 2, 4);
sheet.rowOutlines.group(2, 3);
// ─── 철근콘크리트공사 ───
setGroupHeader(6, '▶ 철근콘크리트공사');
setDetailRow(7, '거푸집공사', '합판', 'm²', 380, 45000);
setDetailRow(8, '철근공사', 'D10', 'kg', 2500, 950);
setDetailRow(9, '콘크리트 타설', '25MPa', 'm³', 85, 120000);
setDetailRow(10, '콘크리트 양생', '양생포', 'm²', 380, 8000);
setSubtotalRow(11, 7, 10);
sheet.rowOutlines.group(7, 4);
// ─── 마감공사 ───
setGroupHeader(12, '▶ 마감공사');
setDetailRow(13, '미장공사', '시멘트몰탈', 'm²', 250, 25000);
setDetailRow(14, '타일공사', '300×300', 'm²', 180, 65000);
setDetailRow(15, '도장공사', '2회도장', 'm²', 320, 18000);
setDetailRow(16, '창호공사', '알루미늄', '개소', 12, 850000);
setSubtotalRow(17, 13, 16);
sheet.rowOutlines.group(13, 4);
// ─── 총합계 ───
sheet.setValue(18, 0, '총 합 계');
sheet.setFormula(18, 5, '=F6+F12+F18');
sheet.getCell(18, 5).formatter('#,##0').font('bold 14px sans-serif');
for (let c = 0; c < 6; c++) {
sheet.getCell(18, c).backColor('#1A237E').foreColor('#FFFFFF').font('bold 13px sans-serif');
}
sheet.setRowHeight(18, 42);
sheet.resumePaint();