How to get plain tabular Excel/CSV format?

[2005 IR Help]

By: zephyr - zephyr_zhao

How to get plain tabular Excel/CSV format?

2004-10-11 08:21

Though Jasper supports exporting excel/csv format, I just need a plain excel or csv. That means no recurring report header, no need of picture, just regular but neat tabular data sheet.

 

Do I need to modify the sorce code?

 

 

 

 

By: zephyr - zephyr_zhao

RE: How to get plain tabular Excel/CSV format?

2004-10-12 02:58

Thank you for your reply.

 

I looked the "nopagebreak" sample.

But it's not exactly what I need.

the example is "over formatted"

I only want to get the most "plain" format like a data table

 

 

 

 

By: Henrik Bentel - hbentel

RE: How to get plain tabular Excel/CSV format

2004-10-13 17:02

I had the same "problem". My solution was to always pass in a parameter named exportType, which would be set to html,csv,xls or pdf.

Then I used a printWhen expression in the sections (bands or individual fields) that I didn't want to print ;

new Boolean( ! ( $P{exportType}.equalsIgnoreCase("csv") || $P{exportType}.equalsIgnoreCase("xls") ) )

 

So for CSV or Excel I usually leave everything out that isn't "pure data"

 

 

 

 

By: zephyr - zephyr_zhao

RE: How to get plain tabular Excel/CSV format?

2004-10-13 20:46

Hi hbentel,

 

It'a smart idea!

 

I'll try it tonight!

 

Thank you

 

 

 

 

By: Teodor Danciu - teodord

RE: How to get plain tabular Excel/CSV format

2004-10-11 12:48

 

Hi,

 

There is this "nopagebreak" sample provided.

Maybe it helps.

 

Teodor

 

 

 

 

 

By: zephyr - zephyr_zhao

RE: How to get plain tabular Excel/CSV format

2004-10-18 17:42

It's nice but still one blank row exists on page break.

 

How can I remove the blank row (height is 0) in Excel that happends at the place of page-break?

 

 

 

 

By: zephyr - zephyr_zhao

RE: How to get plain tabular Excel/CSV format?

2004-10-25 07:14

Any response? please..