Hi, is there an option to configure the standard XLSX-Output?
If you choose xlsx as output, then you get blue headers and all columns with same width.
If you choose Datatable in browser and then push the Excel-button you get an excel with black headers, auto-width,...
Is there a chance to configure the format, or at least take always just one of these?
yes, but that's what i'm trying to avoid. just add the query as new report and set an standard xls output as result, without having to create a template for each single report.
But it's just a layout topic, perhaps i try to change the code on my own.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I hope i can formulate this as a feature request:
Now the xlsx-output of a report looks like this: see xlsx.png - all cols have the same width, and no autofilter.
Would it at least be possible, to add AutoFilter and AutoWidth, so it would look like xlsx_new.png? It would also be ok, if i have to activate it using the options (to not break existing reports).
I've seen in the source, that you set AutoWidth and afterwards the AutoFilter. Can you do the AutoFilter first? I don't know if there is a difference in java, but when you do it in excel in this way, the filter will overlap the header (if the header is longer than the values).
If i do "autoWidth" it in excel after AutoFilter, the filter-icon will be after the header.
and one additional bug: If the parameter are shown AND AutoFilter is set, the autofilter is shown in the first row instead of the 3rd (or depending on the params) line in excel - see screenshot
Changing the order of autofilter and autowidth code doesn't seem to have any effect, but the just released 6.1 version may have some extra accommodation for the column width size.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, is there an option to configure the standard XLSX-Output?
If you choose xlsx as output, then you get blue headers and all columns with same width.
If you choose Datatable in browser and then push the Excel-button you get an excel with black headers, auto-width,...
Is there a chance to configure the format, or at least take always just one of these?
Thanks,
Gerd
Hi,
It's currently not possible to configure the look of the xlsx output.
Jxls output as your choice.
You can decorate excel file as template.
Hope this help.
yes, but that's what i'm trying to avoid. just add the query as new report and set an standard xls output as result, without having to create a template for each single report.
But it's just a layout topic, perhaps i try to change the code on my own.
I hope i can formulate this as a feature request:
Now the xlsx-output of a report looks like this: see xlsx.png - all cols have the same width, and no autofilter.
Would it at least be possible, to add AutoFilter and AutoWidth, so it would look like xlsx_new.png? It would also be ok, if i have to activate it using the options (to not break existing reports).
Thanks
Gerd
Just a note that auto width can make the excel generation much slower, especially for larger reports.
https://sourceforge.net/p/art/discussion/352129/thread/96424228/
Thanks, it works great. Only one thing:
I've seen in the source, that you set AutoWidth and afterwards the AutoFilter. Can you do the AutoFilter first? I don't know if there is a difference in java, but when you do it in excel in this way, the filter will overlap the header (if the header is longer than the values).
If i do "autoWidth" it in excel after AutoFilter, the filter-icon will be after the header.
and one additional bug: If the parameter are shown AND AutoFilter is set, the autofilter is shown in the first row instead of the 3rd (or depending on the params) line in excel - see screenshot
Last edit: Gerd S 2022-06-30
I think the parameter rows were not considered, but should be fine without show parameters?
without show parameters, the headerline is in the first row and file looks ok. Can we disable "show parameters" somehow? (without JSP-edit)
There's no option to hide show parameters.
Changing the order of autofilter and autowidth code doesn't seem to have any effect, but the just released 6.1 version may have some extra accommodation for the column width size.
It would be nice to have a fixed first row!
Yes, good idea. But let's say "fixed header row", because of parameteroutput, title row, ... the header can be some lines below.
There'll be a fixedHeader excel option for this in the next release.
Can I use excel option in the top left corner of the HtmlDataTable report results page?
That's this excel
No. That is provided/controlled by a different library.