스프링 대용량 엑셀 (excel) 업로드

---

FRONT

 

  <div>

    <input type="file" @change="upload($event)" accept=".csv" required>

  </div>

 

---

upload(event){

    var param = {

        file : event.target.files[0]

      }

      uploadTest( param ).then ()

}

---

export function uploadTest(data){

    const form = new FormData()
    form.append('file', data.file)

    return request({
        url: '/api/test'
        , method: 'post'
        , headers: {
            'Content-Type': 'multipart/form-data' 
        }
        , data : form
    })
}

---

BACK

 

@RestController
@Api(tags = {"TEST"})
@RequestMapping("/api/test")
public class testController {

@Autowired
testService service;

@PostMapping(value = "")
public int test(

@ApiParam( name     = "file"
                  , type     = "MultipartFile"
                  , value    = "파일"
                  , example  = ""
                  , required = true ) @RequestParam(value="file") MultipartFile file
,  HttpServletRequest request ) {
        return service.test(file);
    }
}

---

BACK SETTING

 

application.properties

 

#--File Upload
spring.servlet.multipart.max-file-size=100MB
spring.servlet.multipart.max-request-size=100MB

---