adjust column widths

[JamBar]

I'm having trouble getting the column widths to adjust.  I just want them to extend to the largest column width.

Proc Export;

ods tagsets.excelxp file='c:\temp\table1.xml' style=sasweb

    options(embedded_titles='yes'

   Autofit_width='yes');

proc print data=work.table1 nooks; 

   title "Title";

run;

ods _all_ close;

Thanks for any help you can provide.

[RW9]

TBH I don't like using guessing methods so I avoid the autofit, and set widths in my code.  This avoids dissapointment in the output when data changes.

ods tagsets.excelxp file='c:\temp\table1.xml' style=sasweb options(embedded_titles='yes');

proc report data=work.table1 nowd;

  title "Title";

   columns a b c;

     define a / style(column)=[cellwidth=3cm];

...

run;

ods _all_ close;

To add, you don't need to supply exact measurements, you can use percentages, but I find if your data is one character in first run, then you get a cell with 200 it really messes your outputs up, so I like fixed output structure.

[JamBar]

That seemed to do the trick.  Thank you!