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?