Excel and column stretch

[3rwin]

I'm trying to make a JasperReport in iReport that will exclusively be used to export to MS Excel.

 

How can i make the report stretch every column to fit the data (width)?

 

I just want to drop every column on the report without having to change the width for every one of them. I understand this would be a problem for a PDF export with the page width and all, but this is an Excel only report.

 

Thank you.

[3rwin]

Anyone ? Help would be really appreciated.

[yogeshnagle]

Deal All

It's very easy to design such reports with excel sheet.

I sending a xml file along with an excel sheet. If you go though it. you can easily get rid of such problem.

with best regard

Yogesh Nagle.

[file name=Reports.zip size=5639]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Reports.zip[/file]

[3rwin]

It's very easy to design such reports with excel sheet. I sending a xml file along with an excel sheet. If you go though it. you can easily get rid of such problem.

 

Yogesh,

 

Thanks for the help. But after looking at the xml i noticed that you made the width of your fields wide enough to contain the data. Correct me if i'm wrong. My intention was to let the columns stretch automatically.

[yogeshnagle]

Hye.

Dear there is no way to let stretch it automaticlly.

but you can stretch it down after taking enough width.

I just show that way.....

step1:- First go the text field property.

step2:- then select "Text Field" tab and select stretch with overflow.

step3:- now select "Common" tab. There select Print when detail overflows and from stretch type select relative to tallest object.

thanks

wiht best regard

Yogesh Nagle.

[madhukiran]

All this is for vertical stretch.. jasper does not have an option yet for horizontal stretch of the columns/ dynamic width.. the workaround of having maximum size is not an exact solution for this

[ivit]

I am using the following in case of XLS reports:

- add custom property to the report:
net.sf.jasperreports.print.keep.full.text = true (to prevent data truncating)
net.sf.jasperreports.export.xls.detect.cell.type = true (to enable later other data manupulation within the XLS)
net.sf.jasperreports.export.xls.white.page.background = false (I dont like white color) :-)
 

Basicaly, just design the average column width and the net.sf.jasperreports.print.keep.full.text will take care that no data is lost.