Generating Excel Workbook Using Apache POI

poi_xls.scala

import org.apache.poi.hssf.usermodel._
import org.apache.poi.ss.util._
import java.io._

val fileOut = new FileOutputStream("/tmp/workbook.xls")

val wb = new HSSFWorkbook

val sheet1 = wb.createSheet(WorkbookUtil.createSafeSheetName("new sheet"))
val sheet2 = wb.createSheet(WorkbookUtil.createSafeSheetName("second sheet"))

val row1 = sheet1.createRow(0)
val row2 = sheet2.createRow(0)

val cell_1 = row1.createCell(0)
val cell_2 = row2.createCell(0)

cell_1.setCellValue("This is a test of fonts");
cell_2.setCellValue(3.14)

wb.write(fileOut);
fileOut.close();