[play 2.3 java] How to serve a generated Apache POI excel file without creating a file on the server?

[Ben Developer]

Hello,

I'm creating an Excel file on-the-fly using Apache POI. 

I want Play to send the file content in an Excel file, but without saving the file to the server. 

Is it correct that I would need to use Chunked Responses? 

I'm using Play 2.3 Java.

Thanks!

[Ramazan AYYILDIZ]

You can use ByteArrayOutputStream and you can serve it chunked data as below:

val responseStream: java.io.ByteArrayOutputStream = new ByteArrayOutputStream()

val sheetOne = Workbook {
  ...
}

val workbookImpure = new WorkbookImpure(sheetOne)
workbookImpure.saveToStream(responseStream)

Ok.chunked(
  Enumerator(responseStream.toByteArray).andThen(Enumerator.eof)
).as("application/vnd.ms-excel").withHeaders("Content-Disposition" -> s"attachment; filename=filename.xls")