Excel Export Row Height - Example

Good day! Can you provide an example of how I can set the export row height for an excel document? I have an export with some long cell values and I don't want to expand the width or word wrap and expand the row height.

Excel export, by default, resizes the columns by the content (AutoFit column + rows). If you have a very long text you will get equally long column. If you set the column width (either using dbr.colstyle or dbr.export.options+colwidths the column width will be fixed and the AutoFit will be rows only.

So if you have two columns (id + long text) you can either use:

select 'dbr.export.options', 'colwidths', 10, 70;

or

select 'dbr.colstyle', 'd', '[width:220px]';

The difference is that the former applies only to Excel export and the latter for all visible outputs (HTML, Excel & PDF).