! 제품 버전을 정확하게 입력해 주세요.
제품 버전이 정확하게 기재되어 있지 않은 경우,
최신 버전을 기준으로 안내 드리므로
더욱 빠르고 명확한 안내를 위해
제품 버전을 정확하게 입력해 주세요!

인쇄영역 틀어짐 조치할 방법이 있을까요? > Q&A | 토론

본문 바로가기

Java & Kotlin API

Q&A | 토론

Java 인쇄영역 틀어짐 조치할 방법이 있을까요?

페이지 정보

작성자 제이디 작성일 2022-04-20 15:13 조회 806회 댓글 0건
제품 버전 : 5.0.1

본문

첨부파일

안녕하세요 알려주신 내용을 토대로 작업 중입니다. 


보고서를 StringJson 형태로 변환해 DB에 insert 시키고 


해당 정보를 토태로 pdf로 변환하는 작업 중인데요.



JAVA 영역에서


Random random = new Random();

String fileNm = random.nextInt() + "test.pdf";

// Create a new workbook

Workbook workbook = new Workbook();

// Load JSON file

String json = "{\"version\":\"14.2.3\",\"docProps\":{\"docPropsCore\":{\"creator\":\"홍길동\",\"lastModifiedBy\":\"홍길동\",\"lastPrinted\":\"2022-04-20T05:58:23Z\",\"created\":\"2022-04-20T05:50:32Z\",\"modified\":\"2022-04-20T05:59:04Z\"},\"docPropsApp\":{\"Application\":\"Microsoft Excel\",\"DocSecurity\":\"0\",\"ScaleCrop\":\"false\",\"HeadingPairs\":{\"size\":4,\"baseType\":\"variant\",\"workbookInfoArray\":[{\"elementType\":\"vt:lpstr\",\"value\":\"워크시트\"},{\"elementType\":\"vt:i4\",\"value\":\"1\"},{\"elementType\":\"vt:lpstr\",\"value\":\"이름 지정된 범위\"},{\"elementType\":\"vt:i4\",\"value\":\"1\"}]},\"TitlesOfParts\":{\"size\":2,\"baseType\":\"lpstr\",\"sheetsNameArray\":[\"Sheet1\",\"Sheet1!Print_Area\"]},\"Company\":\"\",\"LinksUpToDate\":\"false\",\"SharedDoc\":\"false\",\"HyperlinksChanged\":\"false\",\"AppVersion\":\"16.0300\"}},\"tabStripRatio\":0.6,\"iterativeCalculation\":false,\"iterativeCalculationMaximumIterations\":100,\"iterativeCalculationMaximumChange\":0.001,\"customList\":[],\"sheets\":{\"Sheet1\":{\"name\":\"Sheet1\",\"isSelected\":true,\"rowCount\":43,\"columnCount\":13,\"activeRow\":21,\"zoomFactor\":1.15,\"frozenTrailingRowStickToEdge\":true,\"frozenTrailingColumnStickToEdge\":true,\"theme\":{\"name\":\"Office\",\"themeColor\":{\"name\":\"Office\",\"background1\":{\"a\":255,\"r\":255,\"g\":255,\"b\":255},\"background2\":{\"a\":255,\"r\":231,\"g\":230,\"b\":230},\"text1\":{\"a\":255,\"r\":0,\"g\":0,\"b\":0},\"text2\":{\"a\":255,\"r\":68,\"g\":84,\"b\":106},\"accent1\":{\"a\":255,\"r\":68,\"g\":114,\"b\":196},\"accent2\":{\"a\":255,\"r\":237,\"g\":125,\"b\":49},\"accent3\":{\"a\":255,\"r\":165,\"g\":165,\"b\":165},\"accent4\":{\"a\":255,\"r\":255,\"g\":192,\"b\":0},\"accent5\":{\"a\":255,\"r\":91,\"g\":155,\"b\":213},\"accent6\":{\"a\":255,\"r\":112,\"g\":173,\"b\":71},\"hyperlink\":{\"a\":255,\"r\":5,\"g\":99,\"b\":193},\"followedHyperlink\":{\"a\":255,\"r\":149,\"g\":79,\"b\":114}},\"headingFont\":\"Calibri Light\",\"bodyFont\":\"Calibri\"},\"data\":{\"dataTable\":{\"0\":{\"0\":{\"value\":\"제목\",\"style\":\"__builtInStyle2\"},\"1\":{\"style\":\"__builtInStyle2\"},\"2\":{\"style\":\"__builtInStyle2\"},\"3\":{\"style\":\"__builtInStyle2\"},\"4\":{\"style\":\"__builtInStyle2\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"1\":{\"0\":{\"value\":\"이름\",\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"value\":\"111111111111111\\r\\naaaaaaaaaaaaaaaaaaaaa\\r\\nㄱㄱㄱㄱㄱㄱㄱㄱㄱㄱㄱ\\r\\nㄴㄴㄴㄴㄴㄴㄴㄴㄴㄴㄴ\",\"style\":\"__builtInStyle3\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"2\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"3\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"4\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"5\":{\"0\":{\"value\":\"나이\",\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"6\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"7\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"8\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"9\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"10\":{\"0\":{\"value\":\"종교\",\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"11\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"12\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"13\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"14\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"15\":{\"0\":{\"value\":\"취미\",\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"16\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"17\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"18\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"19\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"20\":{\"0\":{\"value\":\"이름\",\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"21\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"22\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"23\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"24\":{\"0\":{\"value\":\"나이\",\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"25\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"26\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"27\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"28\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"29\":{\"0\":{\"value\":\"종교\",\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"30\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"31\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"32\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"33\":{\"0\":{\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"34\":{\"0\":{\"value\":\"취미\",\"style\":\"__builtInStyle4\"},\"1\":{\"style\":\"__builtInStyle4\"},\"2\":{\"style\":\"__builtInStyle4\"},\"3\":{\"style\":\"__builtInStyle4\"},\"4\":{\"style\":\"__builtInStyle4\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"35\":{\"0\":{\"style\":\"__builtInStyle2\"},\"1\":{\"style\":\"__builtInStyle2\"},\"2\":{\"style\":\"__builtInStyle2\"},\"3\":{\"style\":\"__builtInStyle2\"},\"4\":{\"style\":\"__builtInStyle2\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"36\":{\"0\":{\"style\":\"__builtInStyle2\"},\"1\":{\"style\":\"__builtInStyle2\"},\"2\":{\"style\":\"__builtInStyle2\"},\"3\":{\"style\":\"__builtInStyle2\"},\"4\":{\"style\":\"__builtInStyle2\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"37\":{\"0\":{\"style\":\"__builtInStyle2\"},\"1\":{\"style\":\"__builtInStyle2\"},\"2\":{\"style\":\"__builtInStyle2\"},\"3\":{\"style\":\"__builtInStyle2\"},\"4\":{\"style\":\"__builtInStyle2\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"38\":{\"0\":{\"style\":\"__builtInStyle2\"},\"1\":{\"style\":\"__builtInStyle2\"},\"2\":{\"style\":\"__builtInStyle2\"},\"3\":{\"style\":\"__builtInStyle2\"},\"4\":{\"style\":\"__builtInStyle2\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"39\":{\"0\":{\"value\":\"기타\",\"style\":\"__builtInStyle5\"},\"1\":{\"style\":\"__builtInStyle5\"},\"2\":{\"style\":\"__builtInStyle5\"},\"3\":{\"style\":\"__builtInStyle5\"},\"4\":{\"style\":\"__builtInStyle5\"},\"5\":{\"style\":\"__builtInStyle5\"},\"6\":{\"style\":\"__builtInStyle5\"},\"7\":{\"style\":\"__builtInStyle5\"},\"8\":{\"style\":\"__builtInStyle5\"},\"9\":{\"style\":\"__builtInStyle5\"},\"10\":{\"style\":\"__builtInStyle5\"},\"11\":{\"style\":\"__builtInStyle5\"},\"12\":{\"style\":\"__builtInStyle5\"}},\"40\":{\"0\":{\"style\":\"__builtInStyle2\"},\"1\":{\"style\":\"__builtInStyle2\"},\"2\":{\"style\":\"__builtInStyle2\"},\"3\":{\"style\":\"__builtInStyle2\"},\"4\":{\"style\":\"__builtInStyle2\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"41\":{\"0\":{\"style\":\"__builtInStyle2\"},\"1\":{\"style\":\"__builtInStyle2\"},\"2\":{\"style\":\"__builtInStyle2\"},\"3\":{\"style\":\"__builtInStyle2\"},\"4\":{\"style\":\"__builtInStyle2\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}},\"42\":{\"0\":{\"style\":\"__builtInStyle2\"},\"1\":{\"style\":\"__builtInStyle2\"},\"2\":{\"style\":\"__builtInStyle2\"},\"3\":{\"style\":\"__builtInStyle2\"},\"4\":{\"style\":\"__builtInStyle2\"},\"5\":{\"style\":\"__builtInStyle2\"},\"6\":{\"style\":\"__builtInStyle2\"},\"7\":{\"style\":\"__builtInStyle2\"},\"8\":{\"style\":\"__builtInStyle2\"},\"9\":{\"style\":\"__builtInStyle2\"},\"10\":{\"style\":\"__builtInStyle2\"},\"11\":{\"style\":\"__builtInStyle2\"},\"12\":{\"style\":\"__builtInStyle2\"}}},\"defaultDataNode\":{\"style\":{\"backColor\":null,\"foreColor\":\"Text 1 0\",\"vAlign\":1,\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":null,\"borderTop\":null,\"borderRight\":null,\"borderBottom\":null,\"locked\":true,\"textIndent\":0,\"wordWrap\":false,\"textDecoration\":0,\"diagonalDown\":null,\"diagonalUp\":null,\"fontForColumnWidth\":\"normal normal 14.7px 맑은 고딕\"}}},\"rowHeaderData\":{\"defaultDataNode\":{\"style\":{\"themeFont\":\"Body\"}}},\"colHeaderData\":{\"defaultDataNode\":{\"style\":{\"themeFont\":\"Body\"}}},\"rows\":[{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22},{\"size\":22}],\"columns\":[null,{\"size\":21},null,{\"size\":19},null,null,null,{\"size\":15},{\"size\":19},null,{\"size\":43},{\"size\":30},{\"size\":69}],\"leftCellIndex\":0,\"topCellIndex\":0,\"spans\":[{\"row\":39,\"rowCount\":1,\"col\":0,\"colCount\":13},{\"row\":1,\"rowCount\":38,\"col\":5,\"colCount\":8},{\"row\":40,\"rowCount\":3,\"col\":0,\"colCount\":13},{\"row\":24,\"rowCount\":1,\"col\":0,\"colCount\":5},{\"row\":25,\"rowCount\":4,\"col\":0,\"colCount\":5},{\"row\":29,\"rowCount\":1,\"col\":0,\"colCount\":5},{\"row\":30,\"rowCount\":4,\"col\":0,\"colCount\":5},{\"row\":34,\"rowCount\":1,\"col\":0,\"colCount\":5},{\"row\":35,\"rowCount\":4,\"col\":0,\"colCount\":5},{\"row\":11,\"rowCount\":4,\"col\":0,\"colCount\":5},{\"row\":15,\"rowCount\":1,\"col\":0,\"colCount\":5},{\"row\":16,\"rowCount\":4,\"col\":0,\"colCount\":5},{\"row\":20,\"rowCount\":1,\"col\":0,\"colCount\":5},{\"row\":21,\"rowCount\":3,\"col\":0,\"colCount\":5},{\"row\":0,\"rowCount\":1,\"col\":0,\"colCount\":13},{\"row\":1,\"rowCount\":1,\"col\":0,\"colCount\":5},{\"row\":2,\"rowCount\":3,\"col\":0,\"colCount\":5},{\"row\":5,\"rowCount\":1,\"col\":0,\"colCount\":5},{\"row\":6,\"rowCount\":4,\"col\":0,\"colCount\":5},{\"row\":10,\"rowCount\":1,\"col\":0,\"colCount\":5}],\"selections\":{\"0\":{\"row\":21,\"rowCount\":3,\"col\":0,\"colCount\":5},\"length\":1},\"defaults\":{\"colHeaderRowHeight\":20,\"colWidth\":72,\"rowHeaderColWidth\":40,\"rowHeight\":22,\"_isExcelDefaultColumnWidth\":true},\"rowOutlines\":{\"items\":[]},\"columnOutlines\":{\"items\":[]},\"cellStates\":{},\"states\":{},\"outlineColumnOptions\":{},\"autoMergeRangeInfos\":[],\"shapeCollectionOption\":{\"snapMode\":0},\"index\":0}},\"namedStyles\":[{\"backColor\":\"Accent 1 80\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"20% - Accent1\"},{\"backColor\":\"Accent 2 80\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"20% - Accent2\"},{\"backColor\":\"Accent 3 80\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"20% - Accent3\"},{\"backColor\":\"Accent 4 80\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"20% - Accent4\"},{\"backColor\":\"Accent 5 80\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"20% - Accent5\"},{\"backColor\":\"Accent 6 80\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"20% - Accent6\"},{\"backColor\":\"Accent 1 60\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"40% - Accent1\"},{\"backColor\":\"Accent 2 60\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"40% - Accent2\"},{\"backColor\":\"Accent 3 60\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"40% - Accent3\"},{\"backColor\":\"Accent 4 60\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"40% - Accent4\"},{\"backColor\":\"Accent 5 60\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"40% - Accent5\"},{\"backColor\":\"Accent 6 60\",\"foreColor\":\"Text 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"40% - Accent6\"},{\"backColor\":\"Accent 1 40\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"60% - Accent1\"},{\"backColor\":\"Accent 2 40\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"60% - Accent2\"},{\"backColor\":\"Accent 3 40\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"60% - Accent3\"},{\"backColor\":\"Accent 4 40\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"60% - Accent4\"},{\"backColor\":\"Accent 5 40\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"60% - Accent5\"},{\"backColor\":\"Accent 6 40\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"60% - Accent6\"},{\"backColor\":\"Accent 1 0\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Accent1\"},{\"backColor\":\"Accent 2 0\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Accent2\"},{\"backColor\":\"Accent 3 0\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Accent3\"},{\"backColor\":\"Accent 4 0\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Accent4\"},{\"backColor\":\"Accent 5 0\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Accent5\"},{\"backColor\":\"Accent 6 0\",\"foreColor\":\"Background 1 0\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Accent6\"},{\"backColor\":\"#ffc7ce\",\"foreColor\":\"#9c0006\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Bad\"},{\"backColor\":\"#f2f2f2\",\"foreColor\":\"#fa7d00\",\"font\":\"normal bold 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":{\"color\":\"#7f7f7f\",\"style\":1},\"borderTop\":{\"color\":\"#7f7f7f\",\"style\":1},\"borderRight\":{\"color\":\"#7f7f7f\",\"style\":1},\"borderBottom\":{\"color\":\"#7f7f7f\",\"style\":1},\"textDecoration\":0,\"name\":\"Calculation\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":\"#a5a5a5\",\"foreColor\":\"Background 1 0\",\"font\":\"normal bold 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":{\"color\":\"#3f3f3f\",\"style\":6},\"borderTop\":{\"color\":\"#3f3f3f\",\"style\":6},\"borderRight\":{\"color\":\"#3f3f3f\",\"style\":6},\"borderBottom\":{\"color\":\"#3f3f3f\",\"style\":6},\"textDecoration\":0,\"name\":\"Check Cell\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"formatter\":\"_(* #,##0.00_);_(* (#,##0.00);_(* \\\"-\\\"??_);_(@_)\",\"name\":\"Comma\"},{\"backColor\":null,\"formatter\":\"_(* #,##0_);_(* (#,##0);_(* \\\"-\\\"_);_(@_)\",\"name\":\"Comma [0]\"},{\"backColor\":null,\"formatter\":\"_(\\\"$\\\"* #,##0.00_);_(\\\"$\\\"* (#,##0.00);_(\\\"$\\\"* \\\"-\\\"??_);_(@_)\",\"name\":\"Currency\"},{\"backColor\":null,\"formatter\":\"_(\\\"$\\\"* #,##0_);_(\\\"$\\\"* (#,##0);_(\\\"$\\\"* \\\"-\\\"_);_(@_)\",\"name\":\"Currency [0]\"},{\"backColor\":null,\"foreColor\":\"#7f7f7f\",\"font\":\"italic normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Explanatory Text\"},{\"backColor\":\"#c6efce\",\"foreColor\":\"#006100\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Good\"},{\"backColor\":null,\"foreColor\":\"Text 2 0\",\"font\":\"normal bold 20px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":null,\"borderTop\":null,\"borderRight\":null,\"borderBottom\":{\"color\":\"Accent 1 0\",\"style\":5},\"textDecoration\":0,\"name\":\"Heading 1\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"Text 2 0\",\"font\":\"normal bold 17.3px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":null,\"borderTop\":null,\"borderRight\":null,\"borderBottom\":{\"color\":\"Accent 1 50\",\"style\":5},\"textDecoration\":0,\"name\":\"Heading 2\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"Text 2 0\",\"font\":\"normal bold 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":null,\"borderTop\":null,\"borderRight\":null,\"borderBottom\":{\"color\":\"Accent 1 40\",\"style\":2},\"textDecoration\":0,\"name\":\"Heading 3\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"Text 2 0\",\"font\":\"normal bold 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Heading 4\"},{\"backColor\":\"#ffcc99\",\"foreColor\":\"#3f3f76\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":{\"color\":\"#7f7f7f\",\"style\":1},\"borderTop\":{\"color\":\"#7f7f7f\",\"style\":1},\"borderRight\":{\"color\":\"#7f7f7f\",\"style\":1},\"borderBottom\":{\"color\":\"#7f7f7f\",\"style\":1},\"textDecoration\":0,\"name\":\"Input\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"#fa7d00\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":null,\"borderTop\":null,\"borderRight\":null,\"borderBottom\":{\"color\":\"#ff8001\",\"style\":6},\"textDecoration\":0,\"name\":\"Linked Cell\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":\"#ffeb9c\",\"foreColor\":\"#9c6500\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Neutral\"},{\"backColor\":null,\"foreColor\":\"Text 1 0\",\"hAlign\":3,\"vAlign\":1,\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":null,\"borderTop\":null,\"borderRight\":null,\"borderBottom\":null,\"locked\":true,\"textIndent\":0,\"wordWrap\":false,\"textDecoration\":0,\"name\":\"Normal\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":\"#ffffcc\",\"borderLeft\":{\"color\":\"#b2b2b2\",\"style\":1},\"borderTop\":{\"color\":\"#b2b2b2\",\"style\":1},\"borderRight\":{\"color\":\"#b2b2b2\",\"style\":1},\"borderBottom\":{\"color\":\"#b2b2b2\",\"style\":1},\"name\":\"Note\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":\"#f2f2f2\",\"foreColor\":\"#3f3f3f\",\"font\":\"normal bold 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":{\"color\":\"#3f3f3f\",\"style\":1},\"borderTop\":{\"color\":\"#3f3f3f\",\"style\":1},\"borderRight\":{\"color\":\"#3f3f3f\",\"style\":1},\"borderBottom\":{\"color\":\"#3f3f3f\",\"style\":1},\"textDecoration\":0,\"name\":\"Output\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"formatter\":\"0%\",\"name\":\"Percent\"},{\"backColor\":null,\"foreColor\":\"Text 2 0\",\"font\":\"normal bold 24px Calibri Light\",\"themeFont\":\"Headings\",\"textDecoration\":0,\"name\":\"Title\"},{\"backColor\":null,\"foreColor\":\"Text 1 0\",\"font\":\"normal bold 14.7px Calibri\",\"themeFont\":\"Body\",\"borderLeft\":null,\"borderTop\":{\"color\":\"Accent 1 0\",\"style\":1},\"borderRight\":null,\"borderBottom\":{\"color\":\"Accent 1 0\",\"style\":6},\"textDecoration\":0,\"name\":\"Total\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"#ff0000\",\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"textDecoration\":0,\"name\":\"Warning Text\"},{\"backColor\":null,\"foreColor\":\"Text 1 0\",\"hAlign\":3,\"vAlign\":1,\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"formatter\":\"General\",\"borderLeft\":null,\"borderTop\":null,\"borderRight\":null,\"borderBottom\":null,\"locked\":true,\"textIndent\":0,\"wordWrap\":false,\"textDecoration\":0,\"name\":\"__builtInStyle1\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"Text 1 0\",\"hAlign\":1,\"vAlign\":1,\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"formatter\":\"General\",\"borderLeft\":{\"color\":\"#000000\",\"style\":1},\"borderTop\":{\"color\":\"#000000\",\"style\":1},\"borderRight\":{\"color\":\"#000000\",\"style\":1},\"borderBottom\":{\"color\":\"#000000\",\"style\":1},\"locked\":true,\"textIndent\":0,\"wordWrap\":false,\"textDecoration\":0,\"name\":\"__builtInStyle2\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"Text 1 0\",\"hAlign\":1,\"vAlign\":1,\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"formatter\":\"General\",\"borderLeft\":{\"color\":\"#000000\",\"style\":1},\"borderTop\":{\"color\":\"#000000\",\"style\":1},\"borderRight\":{\"color\":\"#000000\",\"style\":1},\"borderBottom\":{\"color\":\"#000000\",\"style\":1},\"locked\":true,\"textIndent\":0,\"wordWrap\":true,\"textDecoration\":0,\"name\":\"__builtInStyle3\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"Text 1 0\",\"hAlign\":0,\"vAlign\":1,\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"formatter\":\"General\",\"borderLeft\":{\"color\":\"#000000\",\"style\":1},\"borderTop\":{\"color\":\"#000000\",\"style\":1},\"borderRight\":{\"color\":\"#000000\",\"style\":1},\"borderBottom\":{\"color\":\"#000000\",\"style\":1},\"locked\":true,\"textIndent\":0,\"wordWrap\":false,\"textDecoration\":0,\"name\":\"__builtInStyle4\",\"diagonalDown\":null,\"diagonalUp\":null},{\"backColor\":null,\"foreColor\":\"Text 1 0\",\"hAlign\":2,\"vAlign\":1,\"font\":\"normal normal 14.7px Calibri\",\"themeFont\":\"Body\",\"formatter\":\"General\",\"borderLeft\":{\"color\":\"#000000\",\"style\":1},\"borderTop\":{\"color\":\"#000000\",\"style\":1},\"borderRight\":{\"color\":\"#000000\",\"style\":1},\"borderBottom\":{\"color\":\"#000000\",\"style\":1},\"locked\":true,\"textIndent\":0,\"wordWrap\":false,\"textDecoration\":0,\"name\":\"__builtInStyle5\",\"diagonalDown\":null,\"diagonalUp\":null}]}";

workbook.fromJson(json);

//PDF 저장

workbook.save(fileNm);



PDF로 변환하면 아래 이미지 처럼 인쇄영역이 1 페이지가 아닌 

2페이지로 나뉘어서 나타납니다.



 


xlsx 파일을 읽은 후 바로 pdf로 변환 시 해당 문제는 발생하지 않는데 


spreadjs 에서 


var serializationOption : {

       ignoreStyle: false,

       ignoreFormula: false,

       rowHeadersAsFrozenColumns: false,

       columnHeadersAsFrozenRows: false,

       includeBindingSource: true

    },


//결과

var jsonStr = JSON.stringify(spread.toJSON(serializationOption));


해당 값을 위처럼 java 에서 

workbook.fromJson(jsonStr);


받은 후 pdf 변환시 해당 문제가 발생하였습니다.



원본 xlsx 파일과 변환 결과 pdf 파일 첨부했습니다.


엑셀 파일에서 설정한 영역의 인쇄 영역만 pdf 로 변환 하고 싶습니다.


https://www.grapecity.com/documents-api-excel-java/demos/pdfpagesetup


위 링크로 참조하려 했는데 잘 되지 않네요.


  • 페이스북으로 공유
  • 트위터로  공유
  • 링크 복사
  • 카카오톡으로 보내기

댓글목록

등록된 댓글이 없습니다.

1 답변

Java Re: 인쇄영역 틀어짐 조치할 방법이 있을까요?

추천0 이 글을 추천하셨습니다 비추천0 채택채택

페이지 정보

작성자 GCK루카스 작성일 2022-04-22 15:18 댓글 0건

본문

안녕하세요 그레이프시티입니다.


아래 코드를 이용하여 한 페이지에 맞춰 출력할 수 있습니다.

아래 코드 및 도움말을 참고하여 주시기 바랍니다.

worksheet.getPageSetup().setIsPercentScale(false);
worksheet.getPageSetup().setFitToPagesTall(1);
worksheet.getPageSetup().setFitToPagesWide(1);

setFitToPagesWide 도움말setFitToPagesTall 도움말setIsPercentScale 도움말IPageSetup 도움말


다른 궁금한 점이 생기면, 언제든 문의 주시기 바랍니다.


감사합니다.

그레이프시티 드림

* 그레이프시티(GrapeCity)는 개발자를 위하여 ComponentOne(컴포넌트원), Spread(스프레드), ActiveReports(액티브리포츠), SpreadJS(스프레드JS), Wijmo(위즈모)와 같은 엑셀 스프레드시트 리포팅 그리드와 차트 등 다양한 종류의 .NET JavaScript(자바스크립트) 컴포넌트 툴을 생산하고있는 개발툴 전문 회사 입니다.

댓글목록

등록된 댓글이 없습니다.

메시어스 홈페이지를 통해 제품에 대해서 더 자세히 알아 보세요!
홈페이지 바로가기

카테고리

메시어스 홈페이지를 통해 제품에 대해서 더 자세히 알아 보세요!
홈페이지 바로가기
이메일 : sales-kor@mescius.com | 전화 : 1670-0583 | 경기도 과천시 과천대로 7길 33, 디테크타워 B동 1107호 메시어스(주) 대표자 : 허경명 | 사업자등록번호 : 123-84-00981 | 통신판매업신고번호 : 2013-경기안양-00331 ⓒ 2024 MESCIUS inc. All rights reserved.