Jasper Reports Excel Output

Smalltalk Membro desde: 24/06/2004 09:34:24 Mensagens: 2 Offline

Com certeza muitos precisarao dessa dica :) ...

try
{
// Class.forName(oracle.jdbc.driver.OracleDriver);
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = ........
File reportFile = new File("C:jspsample.jasper"); 
String path = reportFile.getAbsolutePath(); //tried getAbsolutePath() 
//System.out.println("Absolute Path = " + reportFile.getAbsolutePath());
Map parameters = new HashMap(); 
parameters.put("myparam",new Integer(2)); 
JasperPrint jasperPrint = JasperManager.fillReport ( path,parameters, conn); 
byte bytes[] = new byte[10];
String result = JasperRunManager.runReportToHtmlFile("C:jspsample.jasper" , parameters, conn);
JRXlsExporter exporter = new JRXlsExporter();

ByteArrayOutputStream xlsReport = new ByteArrayOutputStream();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, xlsReport);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE, "C:JSP");
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, "sample.xls");
exporter.exportReport();
System.out.println("Sixe of byte array:"+xlsReport.size());
bytes = xlsReport.toByteArray();
response.setContentType("application/vnd.ms-excel");
System.out.println("After JasperPrint = "+result);
response.setContentLength(bytes.length);
xlsReport.close();
OutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();
}
catch(Exception e)
{e.printStackTrace();}

klaid dias
klaiddias@tutopia.com.br

Teu post tem quase 3 anos e foi muito útil hoje.
Obrigado!

Vou aumentar para mais de 6 anos

... ainda hoje continua útil.

Sem dúvidas super útil e atual

Notícias, artigos e o maior fórum brasileiro sobre Java