Invalid file format exporting to Excel

[Pablo S]

Hi Xavier, I'm trying to run the Excel export function in Pivot4J. I'm using Play for Scala at the server side and Angular in the browser. The problem is that the file is generated with an invalid format. First, I want to rule out that I'm doing something wrong when generating the file, am I missing something? Code below, option == 0 means to generate HTML, else generates Excel.

Thanks

Pablo 

            val model = new PivotModelImpl(dataSource)

            model.setMdx(mdx)

            model.initialize

            val renderer = new TableRenderer

            renderer.setShowDimensionTitle(true) 

            renderer.setShowParentMembers(true) 

            renderer.setHideSpans(true)

            

            if (option == 0 ) { // HTML

                val sw = new StringWriter

                renderer.render(model, new HtmlRenderCallback(sw)) 

                sw.flush

                sw.close

                sw.toString

            }

            else {  // Excel

                val out = new ByteArrayOutputStream

                val exporter = new ExcelExporter(out)

                exporter.setFormat(Format.HSSF)

                renderer.render(model, exporter)

                renderer.setRenderSlicer(true)

        renderer.setShowSlicerMembersInline(false)

                out.flush

                out.close

                out

            }

[Pablo S]

Found it, specifying the right format exporter.setFormat(Format.SXSSF) for XLSX solved the problem.