JAVA Excel Create 내보내기 (기초)

---

JAVA Excel Create 내보내기

JAVA 에서 Excel 변환 할 때의 최소한의 코드를 기록.

---

import java.io.BufferedReader;
import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;

import org.apache.log4j.Logger;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;

import com.rsn.common.excutor.ExcutorAbstract;
import com.rsn.def.vo.Demon_Test_VO;

 

 

 

	/**
	 *  Excel  만들어서 반환해줍니다.
	 */
	public void ExcelDataCreate( List<Demon_Test_VO> apiData) {
		
		SXSSFWorkbook workbook = new SXSSFWorkbook();
		SXSSFSheet    sheet    = workbook.createSheet("API DATA → Excel 변환");
		
		sheet.setColumnWidth(1, 8000 );
		sheet.setColumnWidth(2, 10000);
		
		int rowLocation = 0;
		
		Row row = null;
		Cell cell = null;
		
		row = sheet.createRow( ++rowLocation );
		cell = row.createCell(1);
		cell.setCellValue("TITLE");
		
		cell = row.createCell(2);
		cell.setCellValue("CONTENT");
		
		
		row = sheet.createRow( ++rowLocation );
		cell = row.createCell(1);
		cell.setCellValue("제 목");
		
		cell = row.createCell(2);
		cell.setCellValue("컨텐츠");
		
		try {
			String home = System.getProperty("user.home");
			File xlsFile = new File( home + "/Downloads/ApiData.xls");
			FileOutputStream fileOut = new FileOutputStream(xlsFile);
			workbook.write(fileOut);
			
		}catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	

 

 

 

---

 

 

 

 

 

---