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 Row Height - Example(2 posts) (2 voices)
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;
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).
You must log in to post.