http://www.guj.com.br/posts/list/5.java JForum - http://www.jforum.net

[code]
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();}

[/code]


klaid dias
klaiddias@tutopia.com.br]]> http://www.guj.com.br/prepost/13473/70109/jasper-reports-excel-output http://www.guj.com.br/prepost/13473/70109/jasper-reports-excel-output GMT Obrigado!]]> http://www.guj.com.br/prepost/13473/485294/rejasper-reports-excel-output http://www.guj.com.br/prepost/13473/485294/rejasper-reports-excel-output GMT ... ainda hoje continua útil.]]> http://www.guj.com.br/prepost/13473/992421/rejasper-reports-excel-output http://www.guj.com.br/prepost/13473/992421/rejasper-reports-excel-output GMT http://www.guj.com.br/prepost/13473/1002882/rejasper-reports-excel-output http://www.guj.com.br/prepost/13473/1002882/rejasper-reports-excel-output GMT http://www.guj.com.br/prepost/13473/1107572/rejasper-reports-excel-output http://www.guj.com.br/prepost/13473/1107572/rejasper-reports-excel-output GMT

Fora quem usou o post e não comentou...

rsrsrsrsrs

Valeu!]]> http://www.guj.com.br/prepost/13473/1380907/rejasper-reports-excel-output http://www.guj.com.br/prepost/13473/1380907/rejasper-reports-excel-output GMT

Fora quem usou o post e não comentou...

rsrsrsrsrs

Valeu!]]> http://www.guj.com.br/prepost/13473/1380910/rejasper-reports-excel-output http://www.guj.com.br/prepost/13473/1380910/rejasper-reports-excel-output GMT