The SAS Output Delivery System and reporting techniques

Retain leading zeroes in ExcelXP

Reply
N/A
Posts: 0

Retain leading zeroes in ExcelXP

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?
SAS Employee
Posts: 95

Re: Retain leading zeroes in ExcelXP

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.
N/A
Posts: 0

Re: Retain leading zeroes in ExcelXP

Thanks, Eric. I'll look for that update.
SAS Employee
Posts: 95

Re: Retain leading zeroes in ExcelXP

N/A
Posts: 0

Re: Retain leading zeroes in ExcelXP

> 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
Ask a Question
Discussion stats
  • 4 replies
  • 185 views
  • 0 likes
  • 2 in conversation