CSV file opening in Excel - cell auto adjustment using JasperReports

[Sham Phadtale]

I am using JaperReport for creating reports. I am exporting them to CSV format.
I am opening it in Microsoft Excel. As data length is more than Excel cell length, data is get hide behind next column.
I want to make sure - as per data length cell length should get increase.

I read about DynamicJasper, but for this change it is not possible to me to change all reports and create new with DynamicJasper.

Please help me if any know how can I do this programaticaly using JasperReport.

[Rob Spoor]

You can't specify in a CSV file how Excel will open it. If you need to specify a predefined size for a column you'll have to export the data as an Excel file.

[Sham Phadtale]

Thanks Rob!

Please can you tell me how can I specify a predefined size for a column to export the data as an Excel file using japser report?

[Rob Spoor]

Not really. I haven't used JasperReports, and have only used Apache POI and JExcelAPI for reading Excel files, not writing them.