Reset column width in PROC REPORT with tagsets.ExcelXP

[JackHamilton]

I'm using the ExcelXP tagset, version (SAS 9.1.3, v1.86, 04/15/08)
.
I am creating a workbook with several tabs.

The first tab has only one column, and I set the width with the ABSOLUTE_COLUMN_WIDTH tagset option. This works.

For all the subsequent tabs, I want the first column to be a particular width, but all of the remaining columns to have their widths automatically calculated by the tagset. Is there a way to specify that?

Also, is there a simple formula for converting the column width shown in Excel (after I autofit the columns) to the width value needed by the tagset?

[Eric_SAS]

You can use a style over ride to set the cell width for that column.

define var1 /style={cellwidth='12pt'};

Excel uses points so you should be able to use the size directly without any
conversion.