excel file 조작하기

이전 버전 다운받는 주소 : https://archive.apache.org/dist/poi/release/bin/

POI 4.0 and later require JDK version 1.8 or later. 

POI 3.11 and later 3.x versions require JDK version 1.6 or later. 

POI 3.5 to 3.10 required the JDK version 1.5 or later. Versions prior to 3.5 required JDK 1.4+.

Busy Developers' Guide to HSSF and XSSF Features

https://poi.apache.org/spreadsheet/quick-guide.html

example source : http://neosm.tistory.com/entry/JAVA-POI-%EC%97%91%EC%85%80%ED%8C%8C%EC%9D%BC-%EC%9D%BD%EA%B8%B0-xlsx-%ED%99%95%EC%9E%A5%EC%9E%90

merge cell counting 하기

https://stackoverflow.com/questions/20675866/setting-value-to-cells-after-merging-in-poi/20677211#20677211

여기 검색에서 보면 좋을 듯 : https://www.google.co.kr/search?newwindow=1&safe=off&biw=944&bih=922&q=poi+%EC%8B%9C%ED%8A%B8+%EB%B3%91%ED%95%A9&oq=poi+%EC%8B%9C%ED%8A%B8+%EB%B3%91%ED%95%A9&gs_l=psy-ab.3...3313.3694.0.3838.6.5.0.0.0.0.235.235.2-1.1.0....0...1.1j4.64.psy-ab..6.0.0....0.Pb3A2QbRF_A

create excel file with poi

http://www.avajava.com/tutorials/lessons/how-do-i-write-to-an-excel-file-using-poi.html

setting cell style 

http://blog.daum.net/wiznel/4653768

병합된 셀의 값 가져오기

http://www.programkr.com/blog/MUTO0ADMwYT0.html

copy row

http://www.zachhunter.com/2010/05/npoi-copy-row-helper/

plus 

VBA으로 시트 합치기

http://mo-mo.tistory.com/22

새로운 workbook을 만들어서 엑셀 스타일을 추가하기

- 스타일을 하나의 workbook에 귀속된 것이라고 함 그래서 아래 url 처럼 생성된 workbook에서 만들어줘야한다.

https://stackoverflow.com/questions/10773961/apache-poi-apply-one-style-to-different-workbooks

파일 시스템관리를 하기 위해서 메모리 관리를 찾아보니 아래와 같은 문구가 있었다.

If using HSSFWorkbook or XSSFWorkbook directly, you should generally go through NPOIFSFileSystem or OPCPackage, to have full control of the lifecycle (including closing the file when done):

(링크)

merge된 셀의 리스트를 갖과 와서 객체에서 시작위치, 끝 위치의 정보를 확인하는 것

https://stackoverflow.com/questions/22688866/apache-poi-getnummergedregions

//for (int i = 0; i < sheetCount; i++) { for (int i = 0; i < 1; i++) { excelfile.selectSheet(i); rowCount = excelfile.getRowCount(); //excelfile.isMerge(); // for test TODO delete //System.out.println("rowCount : " + rowCount); for (int j = 0; j < rowCount; j++) { excelfile.selectRow(j); columnCount = excelfile.getColumnCount(); //System.out.println("columnCount : " + columnCount); for (int k = 0; k < columnCount; k++) { System.out.println("["+i+"]["+j+"]["+k+"] : "+excelfile.getValue(k)); } } } */ //excelfile.pasteSheet(excelfile.getWorkbook().getSheetAt(1), 0, 13); //ExcelUtil.pasteSheet(excelfile.getWorkbook().getSheetAt(1), excelfile.getWorkbook().getSheetAt(0), 13);