Save HCell

Apache POI 라이브러리를 사용하여 SBGrid를 한셀 파일로 저장합니다.


요약

SBGrid에서 saveHcell 기능을 제공합니다.

입력값

String : Save File Name.cell


String : 변환 모듈



예) datagrid1.saveExcel("savedExcelFile.cell", "/importexport/download");

상세설명

SBGrid로 로드 된 데이터들을 한셀 형태로 저장가능 합니다. 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@page language="java"   contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<html xmlns="http://www.w3.org/1999/xhtml" lang="ko">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta http-equiv="X-UA-Compatible" content="IE=edge" />
	<meta name="viewport" content="width=device-width,initial-scale=1.0,minimum-scale=1.0,maximum-scale=1.0" />
	<title> SB Grid </title>
	<link href="/kr/co/softbowl/css/Sbgrid_default.css" type="text/css" rel="stylesheet"  />
	<link href="/css/sort.css" type="text/css" rel="stylesheet"  />
	
	<jsp:include page="/view/common/cmCommon.jsp"/>
	<script type="text/javascript" src="/kr/co/softbowl/SBGrid.js"></script>
	<script type="text/javascript" src="/js/jsondata/DATA_JSON_eval2.js"></script>
	<style type="text/css">
		table{border:0px solid #d6d6d6 !important;}
		table th{border:0px solid #d6d6d6 !important;}
		table td{border:0px solid #d6d6d6 !important; }
	</style>
	<script type="text/javascript">
		SBGrid.DEF.DOMAIN = "../../";
        
                                            var datagrid1,
		datagrid2,
		firstRowHeight = 30;
        $(document).ready(function () {
            __createElements();
        });
        function __createElements() {
            var GridInitInfo = {
                        "strParentId": "sbGridArea",
                        "strId": "datagrid1",
                        "strCaption": "주문번호^배송번호^이름^주민번호^전화번호^금액",
                        "strColWidth": "120, 150, 150, 150, 120, 200",
                        "strJsonRef": "eval1.grid",
                        "strDataHeight": "29",
                        "strBackColorAlternate": "#f7f7f7",
                        "strStyle": "width:100%; height:480px;"
            };
            var SBGridColumnInitInfo = [
                           {
                               "id": "col1",
                               "type": "output",
                               "ref": "orderdate",
                               "style": "text-align:center"
                           },
                           {
                               "id": "col2",
                               "type": "output",
                               "ref": "deliverynum",
                               "style": "text-align:center"
                           },
                           {
                               "id": "col3",
                               "type": "output",
                               "ref": "name",
                               "style": "text-align:center"
                           },
                           {
                               "id": "col4",
                               "type": "output",
                               "ref": "identification",
                               "style": "text-align:center"
                           },
                           {
                               "id": "col5",
                               "type": "output",
                               "ref": "phone",
                               "style": "text-align:center"
                           },
                           {
                               "id": "col6",
                               "type": "output",
                               "ref": "price",
                               "style": "text-align:right;padding:5px"
                           }
            ];
            SBGridColumnInitInfo[0].format = "yyyy-mm-dd";
            SBGridColumnInitInfo[1].format = "L99-LL999";
            SBGridColumnInitInfo[3].format = "999999-9999999";
            SBGridColumnInitInfo[4].format = "99-999-9999";
            SBGridColumnInitInfo[5].format = "#,###";
            datagrid1 = createSBGrid(GridInitInfo, SBGridColumnInitInfo);
            datagrid1.setRowHeight(0, 30);
        };
         function datagridSaveHcell() {
         datagrid1.saveHcellEx("savedHcellFile", 'http://sbgrid.co.kr/saveHcellExManager',true);
     };

      
     function createSBGrid(SBGridInitInfo, SBGridColumnInitInfo) {
         var objJSONdata = new Object();
         objJSONdata.objSBGridInitInfo = SBGridInitInfo;
         objJSONdata.arSBGridColumnInitInfo = SBGridColumnInitInfo;
         return SBGrid.DEF.createSBGrid(objJSONdata);
     };
		
	</script>
</head>
<body>

	<div id="button_group">
	    <input type="button" class="sbgrid_demo_button2" onclick="datagridSaveHcell();" style="width:33%; height:30px; background-color:#F2CB61;" ivalue="SBGrid -> Excel 파일로 저장" />
	</div>
	<div id="sbGridArea"></div>
</body>
</html>