Empty columns in Excel

Marinus · Post by **Marinus** » Mon Sep 07, 2009 7:48 am

When I export my report to Excel (only data) I get some empty columns between the filled columns.
I thought there was a way to deal with this problem. But I don't remember it! :emb:
How can I get rid of these emty columns in Excel?

Brendan · Post by **Brendan** » Mon Sep 07, 2009 6:03 pm

You need to make sure there are no gaps in your columns either in the header or databand. If there's spaces between the text components then those spaces will appear as empty columns in the excel output.
Using the Dock property can sometimes help to avoid this.