IB Sheet 8 Examples

소계 기능

HTML

<link rel="stylesheet" href="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/css/style.css">
<!-- ibsheet css -->
<link rel="stylesheet" href="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/css/default/main.css"/>
<link rel="stylesheet" href="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/css/compatible/light/main.css"/>

<!--  ibsheet 필수 js -->
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/ibleaders.js"></script>
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/ibsheet.js"></script>
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/locale/ko.js"></script>

<!--  ibsheet 선택/추가 js -->
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/plugins/ibsheet-common.js"></script>
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/plugins/ibsheet-dialog.js"></script>
<script src="https://demo.ibleaders.com/ibsheet/v8/samples/customer-sample/assets/ibsheet/plugins/ibsheet-excel.js"></script>

<div class='ibsheet-wrap' id='descFunc'>
<b>2. down2ExcelBuffer로 하나의 시트에서 컬럼별로 나누어 엑셀파일을 생성</b>
<br>하나의 IBSheet를 하나의 엑셀 파일에 여러개의 worksheet로 다운로드합니다.<br>
<button onclick='ib.sampleBtn(this)' class='mgr10'>엑셀다운로드</button>
<hr>

<div id='sheetDiv' style='width:500px;height:300px'></div>


</div>

JavaScript

var ib = ib || {};
ib = {
  //시트 초기화 구문
  'init': {
    "Def": {
      "Col": {
        "Spanned": 1
      },
      "Row": {
        "Spanned": 1,
      "CanFormula": 1
      }
    },
    //공통기능 설정 부분
    "Cfg": {
      "SearchMode": 0,
      "Export": {
        "Url": "https://api.ibleaders.com/ibsheet/v8/"
      }

    },
    //틀고정 좌측 컬럼 설정
    "LeftCols": [{
      Header: "NO",
      Type: "Int",
      Name: "SEQ",
      FormulaRow: "합계"
    }],
    //중앙(메인) 컬럼 설정
    "Cols": [ {
      Header: "1분기비용",
      Name: "1QTCost",
      Type: "Int",
      Align: "center",
      Width: 100,
      FormulaRow: "Sum"
    }, {
      Header: "2분기비용",
      Name: "2QTCost",
      Type: "Int",
      Align: "center",
      Width: 100,
      FormulaRow: "Sum"
    }, {
      Header: "3분기비용",
      Name: "3QTCost",
      Type: "Int",
      Align: "center",
      Width: 100,
      FormulaRow: "Sum"
    }, {
      Header: "4분기비용",
      Name: "4QTCost",
      Type: "Int",
      Align: "center",
      Width: 100,
      FormulaRow: "Sum"
    }, {
      Header: "1분기이익",
      Name: "1QTProfit",
      Type: "Int",
      Align: "center",
      Width: 100,
      FormulaRow: "Sum"
    }, {
      Header: "2분기이익",
      Name: "2QTProfit",
      Type: "Int",
      Align: "center",
      Width: 100,
      FormulaRow: "Sum"
    }, {
      Header: "3분기이익",
      Name: "3QTProfit",
      Type: "Int",
      Align: "center",
      Width: 100,
      FormulaRow: "Sum"
    }, {
      Header: "4분기이익",
      Name: "4QTProfit",
      Type: "Int",
      Align: "center",
      Width: 100,
      FormulaRow: "Sum"
    }, {
      Header: "영업이익",
      Name: "Total",
      Type: "Int",
      Align: "center",
      Width: 100,
      Formula: "1QTProfit+2QTProfit+3QTProfit+4QTProfit-1QTCost-2QTCost-3QTCost-4QTCost",
      FormulaRow: "Sum"
    }, {
      Header: "요약",
      Name: "Summary",
      Type: "Text",
      Align: "center",
      Width: 100
    }]
  },
  //시트 이벤트
  'event': {
  	onRenderFirstFinish:...