JAVA JSF ERRO IndexOutOfBoundsException index 0 size 0

Programação
, , ,
#1

Alguém pode me ajudar estou tentando gerar um bean que busca os dados gera a planilha salva os dados na planilha e faz o download da planilha porem esta dando este erro, alguém consegue me dar um help?

15:28:27,673 ERROR [stderr] (default task-45) java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
15:28:27,674 ERROR [stderr] (default task-45) at java.util.ArrayList.rangeCheck(Unknown Source)
15:28:27,674 ERROR [stderr] (default task-45) at java.util.ArrayList.get(Unknown Source)
15:28:27,674 ERROR [stderr] (default task-45) at jxl.write.biff.WritableWorkbookImpl.getSheet(WritableWorkbookImpl.java:408)
15:28:27,674 ERROR [stderr] (default task-45) at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:794)
15:28:27,674 ERROR [stderr] (default task-45) at com.cad.beans.digitalizacaoNf.RelatorioTituloMeiBean.gerarRelatorio(RelatorioTituloMeiBean.java:115)
15:28:27,674 ERROR [stderr] (default task-45) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:28:27,674 ERROR [stderr] (default task-45) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
15:28:27,674 ERROR [stderr] (default task-45) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
15:28:27,674 ERROR [stderr] (default task-45) at java.lang.reflect.Method.invoke(Unknown Source)
15:28:27,674 ERROR [stderr] (default task-45) at com.sun.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:181)
15:28:27,674 ERROR [stderr] (default task-45) at com.sun.el.parser.AstValue.invoke(AstValue.java:289)
15:28:27,674 ERROR [stderr] (default task-45) at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:304)
15:28:27,674 ERROR [stderr] (default task-45) at org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:40)
15:28:27,674 ERROR [stderr] (default task-45) at org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50)
15:28:27,674 ERROR [stderr] (default task-45) at org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:40)
15:28:27,674 ERROR [stderr] (default task-45) at org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50)
15:28:27,674 ERROR [stderr] (default task-45) at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:149)
15:28:27,674 ERROR [stderr] (default task-45) at javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
15:28:27,674 ERROR [stderr] (default task-45) at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:814)
15:28:27,674 ERROR [stderr] (default task-45) at javax.faces.component.UICommand.broadcast(UICommand.java:300)
15:28:27,674 ERROR [stderr] (default task-45) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790)
15:28:27,674 ERROR [stderr] (default task-45) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282)
15:28:27,674 ERROR [stderr] (default task-45) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
15:28:27,674 ERROR [stderr] (default task-45) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
15:28:27,675 ERROR [stderr] (default task-45) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198)
15:28:27,675 ERROR [stderr] (default task-45) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:658)
15:28:27,675 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
15:28:27,675 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
15:28:27,675 ERROR [stderr] (default task-45) at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:78)
15:28:27,675 ERROR [stderr] (default task-45) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
15:28:27,675 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:168)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)
15:28:27,675 ERROR [stderr] (default task-45) at com.spring.infra.FilterLogin.doFilter(FilterLogin.java:91)
15:28:27,675 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)
15:28:27,676 ERROR [stderr] (default task-45) at com.spring.infra.FilterLogin.doFilter(FilterLogin.java:91)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)
15:28:27,676 ERROR [stderr] (default task-45) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
15:28:27,676 ERROR [stderr] (default task-45) at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
15:28:27,676 ERROR [stderr] (default task-45) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
15:28:27,677 ERROR [stderr] (default task-45) at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
15:28:27,677 ERROR [stderr] (default task-45) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
15:28:27,678 ERROR [stderr] (default task-45) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202)
15:28:27,678 ERROR [stderr] (default task-45) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:805)
15:28:27,678 ERROR [stderr] (default task-45) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
15:28:27,678 ERROR [stderr] (default task-45) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
15:28:27,678 ERROR [stderr] (default task-45) at java.lang.Thread.run(Unknown Source)
15:30:00,003 INFO [org.quartz.plugins.history.LoggingTriggerHistoryPlugin] (ScheduleCad2Testes_Worker-3) Trigger COMERCIAL.Confirmar NFs estoquista Dealer Workflow fired job COMERCIAL.Confirmar NFs estoquista Dealer Workflow next: 15:35:00 05/15/2018
15:30:00,003 INFO [org.quartz.plugins.history.LoggingTriggerHistoryPlugin] (ScheduleCad2Testes_Worker-4) Trigger COMERCIAL.Atualizar Produto Anúncio fired job COMERCIAL.Atualizar Produto Anúncio next: 16:00:00 05/15/2018
15:30:00,003 INFO [org.quartz.plugins.history.LoggingTriggerHistoryPlugin] (ScheduleCad2Testes_Worker-2) Trigger NFE.Baixa Cte fired job NFE.Baixa Cte next: 16:00:00 05/15/2018
15:30:00,003 INFO [com.cad.infra.batchs.TriggerListenerImpl] (ScheduleCad2Testes_Worker-2) Baixa Cte Início
15:30:00,003 INFO [com.cad.infra.batchs.TriggerListenerImpl] (ScheduleCad2Testes_Worker-4) Atualizar Produto Anúncio Início
15:30:00,003 INFO [com.cad.infra.batchs.TriggerListenerImpl] (ScheduleCad2Testes_Worker-3) Confirmar NFs estoquista Dealer Workflow Início
15:30:00,003 INFO [stdout] (ScheduleCad2Testes_Worker-4) NORMAL
15:30:00,003 INFO [stdout] (ScheduleCad2Testes_Worker-3) NORMAL
15:30:00,003 INFO [stdout] (ScheduleCad2Testes_Worker-2) NORMAL
15:30:00,003 INFO [com.cad.batchs.BatchAtualizarProdutoAnuncio] (ScheduleCad2Testes_Worker-4) Atualizar Produto Anúncio - JBOSS NODE: go01vwdes09
15:30:00,003 INFO [com.cad.batchs.BatchBaixaCteDfe] (ScheduleCad2Testes_Worker-2) Baixa Cte - JBOSS NODE: go01vwdes09
15:30:00,003 INFO [com.cad.batchs.BatchConfirmaNotasEstoquistaDealerWorkflow] (ScheduleCad2Testes_Worker-3) Confirmar NFs estoquista Dealer Workflow - JBOSS NODE: go01vwdes09
15:30:00,003 INFO [com.cad.batchs.BatchAtualizarProdutoAnuncio] (ScheduleCad2Testes_Worker-4) Atualizar Produto Anúncio - HOST NAME: go01vwdes09
15:30:00,003 INFO [com.cad.batchs.BatchBaixaCteDfe] (ScheduleCad2Testes_Worker-2) Baixa Cte - HOST NAME: go01vwdes09
15:30:00,003 INFO [com.cad.batchs.BatchConfirmaNotasEstoquistaDealerWorkflow] (ScheduleCad2Testes_Worker-3) Confirmar NFs estoquista Dealer Workflow - HOST NAME: go01vwdes09
15:30:00,003 INFO [com.cad.batchs.BatchAtualizarProdutoAnuncio] (ScheduleCad2Testes_Worker-4) Execução cancelada. - go01vwdes09 - go01vwdes09
15:30:00,003 INFO [com.cad.batchs.BatchBaixaCteDfe] (ScheduleCad2Testes_Worker-2) Execução cancelada. - go01vwdes09 - go01vwdes09
15:30:00,003 INFO [com.cad.batchs.BatchConfirmaNotasEstoquistaDealerWorkflow] (ScheduleCad2Testes_Worker-3) Execução cancelada. - go01vwdes09 - go01vwdes09
15:30:00,003 INFO [org.quartz.plugins.history.LoggingTriggerHistoryPlugin] (ScheduleCad2Testes_Worker-4) Trigger COMERCIAL.Atualizar Produto Anúncio completed next 16:00:00 05/15/2018
15:30:00,003 INFO [org.quartz.plugins.history.LoggingTriggerHistoryPlugin] (ScheduleCad2Testes_Worker-2) Trigger NFE.Baixa Cte completed next 16:00:00 05/15/2018
15:30:00,003 INFO [org.quartz.plugins.history.LoggingTriggerHistoryPlugin] (ScheduleCad2Testes_Worker-3) Trigger COMERCIAL.Confirmar NFs estoquista Dealer Workflow completed next 15:35:00 05/15/2018
15:30:00,003 INFO [com.cad.infra.batchs.TriggerListenerImpl] (ScheduleCad2Testes_Worker-2) Finalizado com sucesso Web Service de Distribuição de DF - e de Interesse dos Atores da CT-e (PF ou PJ) NOOP
15:30:00,003 INFO [com.cad.infra.batchs.TriggerListenerImpl] (ScheduleCad2Testes_Worker-4) Finalizado com sucesso Atualiza informações dos produtos anunciados NOOP
15:30:00,003 INFO [com.cad.infra.batchs.TriggerListenerImpl] (ScheduleCad2Testes_Worker-3) Finalizado

#2

Assim fica difícil, você deve postar uma parte do código para vermos.
A única coisa que podemos afirmar é que, o seu array está vazio (não ajudou muito, né ?)

Mas vamos lá, provavelmente precisa criar uma planilha, tente createSheet em vez do getSheet.

#3

private void adicionarCabecalho(WritableSheet planilha, ExcelExportUtils exportUtils) throws RowsExceededException, WriteException {
int row = 0;
int nColumn = 0;
exportUtils.adicionarCelula(nColumn++, row, “Número Nota”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Fornecedor”, true, planilha, 30, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Nº PIS”, true, planilha, 25, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Unidade”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Data de Emissão”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Data de Inclusão”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Data de Vencimento”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Valor da NF”, true, planilha, 20, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Valor do INSS 20%”, true, planilha, 20, Alignment.CENTRE);
}

private void adicionarLinhaPlanilha(WritableSheet planilha, ExcelExportUtils exportUtils,
                                    NotaTituloMei notaTituloMei) throws RowsExceededException, WriteException {
    int numeroColuna = 0;
    exportUtils.adicionarCelula(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getNumeroNota(), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getDigitalizacaoNf().getFornecedorNf().getNome(), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getDigitalizacaoNf().getFornecedorNf().getPis(), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getDigitalizacaoNf().getUnidadeOrganizacional().getNomeFantasia(), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, CalendarToString.obterDataEHoraCalendar(notaTituloMei.getDataEmissao()), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, CalendarToString.obterDataEHoraCalendar(notaTituloMei.getDataInclusao()), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, CalendarToString.obterDataCalendar(notaTituloMei.getDataVencimento()), false, planilha);
    exportUtils.adicionarCelulaNumeralDinheiro(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getValorNota(), false, planilha);
    exportUtils.adicionarCelulaNumeralDinheiro(numeroColuna++, linha, notaTituloMei.getValorNota(), false, planilha);


    linha++;
}

private void ajustarLarguraColunas(WritableSheet planilha) {
    for (int x = 0; x < planilha.getColumns(); x++) {
        CellView cell = planilha.getColumnView(x);
        cell.setAutosize(true);
        planilha.setColumnView(x, cell);
    }
}

public void gerarRelatorio() {

    List<NotaTituloMei> notaTituloMeiList = tituloMeiHome.buscaListaNotaTituloByFiltro(getDataInicioEmissao(),
            getDataFimEmissao(), getDataInicioInclusao(), getDataFimInclusao(), getDataInicioVencimento(), getDataFimVencimento(), getListaUnidadesFiltro());

    ExcelExportUtils exportUtils = new ExcelExportUtils();
    ByteArrayOutputStream outputStream = null;
    try {
        outputStream = new ByteArrayOutputStream();
        WritableWorkbook workbook = jxl.Workbook.createWorkbook(outputStream);

        if (notaTituloMeiList != null && notaTituloMeiList.isEmpty() == false) {
            montaPlanilha(notaTituloMeiList, exportUtils, workbook);
        }

        workbook.write();
        workbook.close();

        InputStream inputStream = new ByteArrayInputStream(outputStream.toByteArray());
        String fileName = "RelatórioTituloMei.xls";
        relatorioExcel = new DefaultStreamedContent(inputStream, "application/vnd.ms-excel", fileName);
    } catch (Exception e) {
        e.printStackTrace();
    }

}

private void montaPlanilha(List<NotaTituloMei> notaTituloMeiList, ExcelExportUtils exportUtils, WritableWorkbook workbook) throws RowsExceededException, WriteException {
    WritableSheet planilha = workbook.createSheet("NotaTituloMei", 1);

    linha = 1;

    SheetSettings settings = planilha.getSettings();
    settings.setVerticalFreeze(1);

    adicionarCabecalho(planilha, exportUtils);
    int diffDias;
    for (NotaTituloMei notaTituloMei : notaTituloMeiList) {
        if (notaTituloMei.getDataEmissao() != null) {
            diffDias = Uteis.getDiferencaEmDias(notaTituloMei.getDataEmissao(), notaTituloMei.getDataVencimento());
            if (diffDias<0)
                adicionarLinhaPlanilha(planilha, exportUtils, notaTituloMei);

        }
    }

    ajustarLarguraColunas(planilha);

}

public TituloMeiHome getTituloMeiHome() {
    return tituloMeiHome;
}

public void setTituloMeiHome(TituloMeiHome tituloMeiHome) {
    this.tituloMeiHome = tituloMeiHome;
}


public List<UnidadeOrganizacional> getListaUnidadesFiltro() {
    return listaUnidadesFiltro;
}

public void setListaUnidadesFiltro(List<UnidadeOrganizacional> listaUnidadesFiltro) {
    this.listaUnidadesFiltro = listaUnidadesFiltro;
}

public Calendar getDataInicioInclusao() {
    return dataInicioInclusao;
}

public void setDataInicioInclusao(Calendar dataInicioInclusao) {
    this.dataInicioInclusao = dataInicioInclusao;
}

public Calendar getDataFimInclusao() {
    return dataFimInclusao;
}

public void setDataFimInclusao(Calendar dataFimInclusao) {
    this.dataFimInclusao = dataFimInclusao;
}

public Calendar getDataInicioEmissao() {
    return dataInicioEmissao;
}

public void setDataInicioEmissao(Calendar dataInicioEmissao) {
    this.dataInicioEmissao = dataInicioEmissao;
}

public Calendar getDataFimEmissao() {
    return dataFimEmissao;
}

public void setDataFimEmissao(Calendar dataFimEmissao) {
    this.dataFimEmissao = dataFimEmissao;
}

public Calendar getDataInicioVencimento() {
    return dataInicioVencimento;
}

public void setDataInicioVencimento(Calendar dataInicioVencimento) {
    this.dataInicioVencimento = dataInicioVencimento;
}

public Calendar getDataFimVencimento() {
    return dataFimVencimento;
}

public void setDataFimVencimento(Calendar dataFimVencimento) {
    this.dataFimVencimento = dataFimVencimento;
}

public StreamedContent getRelatorioExcel() {
    return relatorioExcel;
}

public void setRelatorioExcel(StreamedContent relatorioExcel) {
    this.relatorioExcel = relatorioExcel;
}

}

#4

já estou usando createSheet

#5

Qual versão do POI você está usando ?

Tente mudar para workbook.createSheet(“NotaTituloMei”, 0);

#6

Boa tarde amigo, versão 3.17 do POI está gerando a planilha porem agora esta vindo sem dados

image
image.png1361×349 12 KB

#7

resolvi pessoal, o problema agora é quando eu coloco uma data que não tem relatório(exemplo: 02/02/2019), e ele gera o relatorio mas não abre da um erro,

quero que quando não a dados para gerar gere a planilha com o cabeçalho e abra…

quando nao a dados gera a planilha ams na hora de abrir da este erro:

image
image.png807×363 8.5 KB

#8

CODIGO ATUAL:

private void adicionarCabecalho(WritableSheet planilha, ExcelExportUtils exportUtils) throws RowsExceededException, WriteException {
int row = 0;
int nColumn = 0;
exportUtils.adicionarCelula(nColumn++, row, “Número Nota”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Fornecedor”, true, planilha, 30, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Nº PIS”, true, planilha, 25, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Unidade”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Data de Emissão”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Data de Inclusão”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Data de Vencimento”, true, planilha, 15, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Valor da NF”, true, planilha, 20, Alignment.CENTRE);
exportUtils.adicionarCelula(nColumn++, row, “Valor do INSS 20%”, true, planilha, 20, Alignment.CENTRE);
}

private void adicionarLinhaPlanilha(WritableSheet planilha, ExcelExportUtils exportUtils,
                                    NotaTituloMei notaTituloMei) throws RowsExceededException, WriteException {
    int numeroColuna = 0;
    exportUtils.adicionarCelula(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getNumeroNota(), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getDigitalizacaoNf().getFornecedorNf().getNome(), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getDigitalizacaoNf().getFornecedorNf().getPis(), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getDigitalizacaoNf().getUnidadeOrganizacional().getNomeFantasia(), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, CalendarToString.obterDataEHoraCalendar(notaTituloMei.getDataEmissao()), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, CalendarToString.obterDataEHoraCalendar(notaTituloMei.getDataInclusao()), false, planilha);
    exportUtils.adicionarCelula(numeroColuna++, linha, CalendarToString.obterDataCalendar(notaTituloMei.getDataVencimento()), false, planilha);
    exportUtils.adicionarCelulaNumeralDinheiro(numeroColuna++, linha, notaTituloMei.getNotaDigitalizacaoNf().getValorNota(), false, planilha);
    exportUtils.adicionarCelulaNumeralDinheiro(numeroColuna++, linha, notaTituloMei.getValorNota(), false, planilha);


    linha++;
}

private void ajustarLarguraColunas(WritableSheet planilha) {
    for (int x = 0; x < planilha.getColumns(); x++) {
        CellView cell = planilha.getColumnView(x);
        cell.setAutosize(true);
        planilha.setColumnView(x, cell);
    }
}

public void gerarRelatorio() {

    List<NotaTituloMei> notaTituloMeiList = tituloMeiHome.buscaListaNotaTituloByFiltro(getDataInicioEmissao(),
            getDataFimEmissao(), getDataInicioInclusao(), getDataFimInclusao(), getDataInicioVencimento(), getDataFimVencimento(), getListaUnidadesFiltro());

    ExcelExportUtils exportUtils = new ExcelExportUtils();
    ByteArrayOutputStream outputStream;
    try {
        outputStream = new ByteArrayOutputStream();
        WritableWorkbook workbook = jxl.Workbook.createWorkbook(outputStream);

        if (notaTituloMeiList != null && !notaTituloMeiList.isEmpty()) {
            montaPlanilha(notaTituloMeiList, exportUtils, workbook);

            workbook.write();
        }
        workbook.close();

        InputStream inputStream = new ByteArrayInputStream(outputStream.toByteArray());
        String fileName = "RelatórioTituloMei.xls";
        relatorioExcel = new DefaultStreamedContent(inputStream, "application/vnd.ms-excel", fileName);
    } catch (Exception e) {
        e.printStackTrace();
    }

}

private void montaPlanilha(List<NotaTituloMei> notaTituloMeiList, ExcelExportUtils exportUtils, WritableWorkbook workbook) throws RowsExceededException, WriteException {
    WritableSheet planilha = workbook.createSheet("NotaTituloMei", 1);

    linha = 1;

    SheetSettings settings = planilha.getSettings();
    settings.setVerticalFreeze(1);

    adicionarCabecalho(planilha, exportUtils);
    if (notaTituloMeiList !=null || !notaTituloMeiList.isEmpty()){
        int diffDias;
        for (NotaTituloMei notaTituloMei : notaTituloMeiList) {
            if (notaTituloMei.getDataEmissao() != null) {
                diffDias = Uteis.getDiferencaEmDias(notaTituloMei.getDataEmissao(), notaTituloMei.getDataVencimento());
                System.out.println(diffDias);
                if (diffDias!=0) {
                    adicionarLinhaPlanilha(planilha, exportUtils, notaTituloMei);
                }else if (notaTituloMeiList != null || notaTituloMeiList == null){
                    adicionarCabecalho(planilha,exportUtils);
                }
            }
        }
    }


    ajustarLarguraColunas(planilha);

}