Column width in excel export

(3 posts) (2 voices)
  1. Deepak, Member


    I am unable to set column widths when i use the below command,
    select 'dbr.export.options', 'colwidths',8,30,30,10,10,11,10,10,10,10,10,10,10,10,10,10,10,10,10,30,10,10,30,10;

    There are 3 worksheets in my excel export i have defined "select 'dbr.export.options', 'colwidths'" for all 3 worksheets as the columns and size vary, yet myDBR does not apply the column width specified in the command.
    SELECT '', 'Launch Asset Summary';
    SELECT '', 'Launch Asset Detail';
    SELECT '', 'TOP Asset Summary';

    select 'dbr.export.options', 'colwidths',8,30,30,10,10,11,10,10,10,10,10,10,10,10,10,10,10,10,10,30,10,10,30,10;
    select 'dbr.export.options','worksheet','Launch Asset Summary';

    SELECT '';

    select 'dbr.export.options','colwidths',8,10,10,10,30,30,10,10,10,10,10,10,10,10,10,10,10,30,30,30,30,30,30,10,30,10,10,10,10,30,10,10,10,10,10,10,10,10,10,10;
    select 'dbr.export.options','worksheet','Launch Asset Detail';

    SELECT '';

    select 'dbr.export.options', 'colwidths',8,10,10,30,30,10,10,10,30,30,30,30,30,10,10;
    select 'dbr.export.options','worksheet','TOP Asset Summary';

    SELECT '';

  2. myDBR Team, Key Master

    Place the 'colwidths'-option after the 'worksheet'-option as the 'worksheet' option causes new worksheet to be created.

    myDBR Team

  3. Deepak, Member

    That worked.

    Thank you


You must log in to post.