Setting the Excel column width

You can set the width of each column for the exported Excel file in JReport Designer. To do this:

1. Select the node that represents the report in the Report Inspector.
2. In the Properties panel, set the Column Width List property as required.

   Type the width for the columns in turn, using a semicolon (;) to separate each value. If you don't want to specify the width for a certain column, omit the value. JReport will then use the default value (8) for the column.

   For example, the value list 12;15;;20 makes the first column width 12, the second 15, the third 8, which is the default value, and the fourth 20.

3. Click File > Export To > Excel.
4. In the Export to Excel dialog, select Column Format.
5. Set the other options as required.
6. Click OK to start exporting.