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

wb = XSSFWorkbook()
sheet = wb.createSheet("random numbers");
r=Random(1)
for i in range(50):
   row=sheet.createRow(i)   # create a new row 
   for j in range(20):
      row.createCell(j).setCellValue(r.nextDouble())    
row=sheet.createRow(50)
row.createCell(0).setCellFormula("SUM(A1:A50)") # formula (sum A+B) 
out=FileOutputStream("table2.xlsx");
wb.write(out)
out.close();