from  org.apache.poi.xssf.usermodel import XSSFWorkbook 
from  java.io import *

wb = XSSFWorkbook()
sheet = wb.createSheet("New spreadsheet");
row=sheet.createRow(0)   # create a new row 
row.createCell(0).setCellValue(100)     # cell=0 has value 100
row.createCell(1).setCellValue(200)     # cell=1 has value 200
row.createCell(2).setCellValue("dmelt") # cell=2 has "dmelt"
row.createCell(3).setCellValue(False)   # boolean
row.createCell(4).setCellFormula("SUM(A1:B1)") # formula (sum A+B) 
out=FileOutputStream("table1.xlsx");
wb.write(out)
out.close();