1. 

   jdluth, Member

   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.
2. 

   myDBR Team, Key Master

   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).

   --
   myDBR Team

Reply

You must log in to post.