scala 中导出excel

为什么80%的码农都做不了架构师？>>>   

导出代码：

val workbook = new XSSFWorkbook
workbook.createSheet("sub Shop info",data.zipWithIndex){ case (data, _) =>
  Seq(
    "" -> "",
  )
}
workbook

def sendExcel(name: String, workbook: XSSFWorkbook): Result = {
  val out = new ByteArrayOutputStream
  workbook.write(out)
  Results.Ok(out.toByteArray).as("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
    .withHeaders("Content-Disposition" -> s"attachment; filename=$name.xlsx")
}

转载于:https://my.oschina.net/hycky/blog/1540932