1. 

   Deepak, Member

   Hi,

   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.
   [code]
   SELECT 'dbr.tab', 'Launch Asset Summary';
   SELECT 'dbr.tab', 'Launch Asset Detail';
   SELECT 'dbr.tab', '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 'dbr.tab.next';

   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 'dbr.tab.next';

   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 'dbr.tab.close';
   [code]
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

Reply

You must log in to post.