Excel Export Row Height - Example

(2 posts) (2 voices)
  • Started 2 months ago by jdluth
  • Latest reply from myDBR Team

Tags:

No tags yet.

  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.

    Posted 2 months ago #
  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

    Posted 2 months ago #

Reply

You must log in to post.