HB [DevBlog]

public Map<String, Object> read(MultipartFile multipartFile){
	InputStream is = multipartFile.getInputStream();
		Workbook workbook = StreamingReader.builder()
				.rowCacheSize(100)
				.bufferSize(4096)
				.open(is);
		
		
	    Sheet sheet = workbook.getSheetAt(0);
        Cell cell = null;
        int totalColumns = 0;
        
        for (Row row : sheet) {
        	if(row.getRowNum() == 0) {				
            	totalColumns = row.getLastCellNum(); 	//첫 행에서 totalColumn 사이즈를 가져옴 			
            }
        	for (int i = 0; i <totalColumns; i++) { //이렇게 사용하는 경우 빈 셀을 구분할 수 있음
            	cell = row.getCell(i);
               	if(cell != null){
                	cell.getStringCellValue(); 	//셀 데이터 
                }
            }
        }
        
}

전송 예제

File file = new File("파일 경로");

HttpClient httpClient = HttpClientBuilder.create().build();
HttpPost httpPost = new HttpPost("MultipartFile 전송할 URL");
MultipartEntityBuilder builder = MultipartEntityBuilder.create()
				.setCharset(Charset.forName("UTF-8"))
                                .setMode(HttpMultipartMode.BROWSER_COMPATIBLE);

builder.addPart("file", new FileBody(file));
httpPost.setEntity(builder.build());

MultipartFile mulitipartFile  

File convFile = new File(mulitipartFile.getOriginalFilename());
    convFile.createNewFile();
    FileOutputStream fos = new FileOutputStream(convFile);
    fos.write(mulitipartFile.getBytes());
    fos.close();

or


File convFile = new File(mulitipartFile.getOriginalFilename());      

mulitipartFile.transferTo(convFile);