Retain leading zeroes in ExcelXP

[deleted_user]

Hi,

I've retained leading zeroes for Excel output via ODS HTML using

... htmlstyle='vnd.ms-excel.numberformat:@' ...

Is there a similar TAGATTR attribute for ExcelXP?

[Eric_SAS]

you can use

tagattr="format: @"

When you do that, the type will also be changed from number, to string.

This only works in the latest versions of the tagset. The newest version will be available later today. it's worth waiting for because it fixes a couple of bugs reported by Jack earlier this week.

[deleted_user]

Thanks, Eric. I'll look for that update.

[Eric_SAS]

The new tagset is now on the web...

http://support.sas.com/rnd/base/topics/odsmarkup/excltags.tpl

[deleted_user]

> The new tagset is now on the web...
>
> http://support.sas.com/rnd/base/topics/odsmarkup/exclt
> gs.tpl

This URL doesn't work - it goes to a 404 page( SAS page that says "We're sorry. We couldn't find your document"). You need to add a final l to the link to get there (the Forum software is truncating it - I tried to post a corrected link and Preview showed that mine was truncated, too).

Steve Raimi