Hi Nick ,
Thanks for your quick reply...but we have added some Font
,CellStyle,Hyperlinks ,Pei Charts ,So can you please share your views on
this..does it hamper performance..?
Let me explain our approach to you..We are taking data from server and we
have an .xlsx template file in which we have defined some templates.so we
pick this template and write data to this template using poi API like create
row,cell.setCellValue(..)etc.It is not taking much time.but when we write
this to output stream using Workbook.write(out); it is taking around 20-30
minutes.
//Get the workbook instance for XLS file
String templateFile= "C:/home/filled_title_reports.xlsx";
XSSFWorkbook workbook= new XSSFWorkbook(templateFile);
workbook.setActiveSheet(0);
System.out.println(" update workbook start : "+new
Date());
updateWorkBook(workbook, dataMatrix);
System.out.println(" update workbook end : "+new
Date());
FileOutputStream out = new FileOutputStream(new
File("c:/home",
sessionID+".xlsx"));
System.out.println(" write workbook start : "+new
Date());
workbook.write(out); //This line is taking tooooo much
time...
System.out.println(" write workbook end : "+new Date());
out.close();
Can you please share your thoughts.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/XSSFWorkbook-SXSSFWorkbook-takes-to-much-time-to-generate-xlsx-tp5717171p5717173.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
