ReportServer Forum

zitot

Member

Registered: 2024-10-12

jxls template: how to dynamically grow row to fit cell?

Hi,

I want to know if there is way to variable row height in a jxls template, that is, if i have long string like `aaaaaaaaaaaaaassssssssssssssssdddddddddddddffffffffffff` and column width is small, then i want that row to grow in height as it wraps word

I enable word wrap in the template, then run the report, but that doesn't change the row height dynamically to grow with cell content. Every row height is the same.

I think maybe with Apache POI it would be possible, but I am thinking i don't have the ability to run scripts, as I cannot upload files (I can still create a script report, there's just nothing to use in it?)

Last edited by zitot (2024-12-03 01:13:02)

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: jxls template: how to dynamically grow row to fit cell?

Hi zitot,

If you are using ReportServer Enterprise or the Enterprise Evaluation version, you have the ability to write scripts.

Regarding your specific requirement for dynamic row heights, you are correct that Apache POI can handle this. JXLS itself does not natively support dynamic row height adjustment, but you can use Apache POI for post-processing to achieve this. With Apache POI, you can programmatically enable word wrapping and adjust row heights dynamically based on cell content.

If you are unable to upload files, this might be due to your permissions. Please consult with your administrator to review your permissions. You can find detailed information in the Admin Guide, specifically in Chapter 3: User and Permission Management.

For scripting guidance within ReportServer, refer to the following resources:

Script Guide
Script Tutorial

If you have the necessary permissions and access to scripting, you should be able to integrate Apache POI to implement this functionality.

Regards,
Eduardo