Jasper Reports Excel Output

Com certeza muitos precisarao dessa dica …

try
&#123;
// Class.forName&#40;oracle.jdbc.driver.OracleDriver&#41;;
DriverManager.registerDriver&#40;new oracle.jdbc.driver.OracleDriver&#40;&#41;&#41;;
Connection conn = ........
File reportFile = new File&#40;"C&#58;jspsample.jasper"&#41;; 
String path = reportFile.getAbsolutePath&#40;&#41;; //tried getAbsolutePath&#40;&#41; 
//System.out.println&#40;"Absolute Path = " + reportFile.getAbsolutePath&#40;&#41;&#41;;
Map parameters = new HashMap&#40;&#41;; 
parameters.put&#40;"myparam",new Integer&#40;2&#41;&#41;; 
JasperPrint jasperPrint = JasperManager.fillReport &#40; path,parameters, conn&#41;; 
byte bytes&#91;&#93; = new byte&#91;10&#93;;
String result = JasperRunManager.runReportToHtmlFile&#40;"C&#58;jspsample.jasper" , parameters, conn&#41;;
JRXlsExporter exporter = new JRXlsExporter&#40;&#41;;

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

klaid dias
[email removido]

30/01/2013 - OPA mais uma aqui mas com uma duvida

JasperManager ???
response ???

esta dando o seguinte erro : ele nao acha a varial, blz ate ai mas que tipo de variavel criar ? Desculpa a pergunta leiga. mas sou novato nesse mundo Java

try {
// Class.forName(oracle.jdbc.driver.OracleDriver);   

            this.connection = new ConnectionFactory().getConnection();

            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, connection);
            byte bytes[] = new byte[10];
            String result = JasperRunManager.runReportToHtmlFile("C:jspsample.jasper", parameters, connection);
            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();
        }

    }

Estou tendo o seguinte erro

java.lang.RuntimeException: Uncompilable source code - Erroneous sym type: JasperManager.fillReport
	at gui.MenuGUI.exportarExcelActionPerformed(MenuGUI.java:205)
	at gui.MenuGUI.access$000(MenuGUI.java:23)
	at gui.MenuGUI$1.actionPerformed(MenuGUI.java:73)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
	at java.awt.Component.processMouseEvent(Component.java:6505)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6270)
	at java.awt.Container.processEvent(Container.java:2229)
	at java.awt.Component.dispatchEventImpl(Component.java:4861)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Component.dispatchEvent(Component.java:4687)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
	at java.awt.Container.dispatchEventImpl(Container.java:2273)
	at java.awt.Window.dispatchEventImpl(Window.java:2719)
	at java.awt.Component.dispatchEvent(Component.java:4687)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:723)
	at java.awt.EventQueue.access$200(EventQueue.java:103)
	at java.awt.EventQueue$3.run(EventQueue.java:682)
	at java.awt.EventQueue$3.run(EventQueue.java:680)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
	at java.awt.EventQueue$4.run(EventQueue.java:696)
	at java.awt.EventQueue$4.run(EventQueue.java:694)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:693)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:244)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:163)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:147)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:139)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:97)

8 Respostas

Topicos relacionados