Hello Henk,
Unfortunately Autofit height does not work in Excel. It is in fact, set, but has no effect.
The heights are calculated by the tagset based on the content of the cells and their widths.
If there is a width set on a cell the tagset will honor that width and adjust the heights accordingly.
The column widths are calculated based on the width given by the procedure, the font size and the length of the header for that column.
I would expect the column widths to match the widths of the actual data, If you want them to be narrower there are a few ways to do that. The cellwidth style attribute takes several different units of measure, points is most common. Setting that on a style over ride will allow you to control the column width.
Are the columns too wide for you or are they too narrow?
Which version of the tagset are you using? That can make a big difference.
The current version is 1.86 and is available at
http://support.sas.com/rnd/base/ods/odsmarkup/