The SAS Output Delivery System and reporting techniques

Cell protection using ExcelXP tagset

Reply
SAS Employee
Posts: 21

Cell protection using ExcelXP tagset

Hello everyone,

Does anyone know if it is possible to protect certain columns/cells when using the ExcelXP tagset?

For example, I am proc printing SASHELP.CLASS and would like to protect the NAME column from changes.

Thanks,
Eyal
SAS Super FREQ
Posts: 8,743

Re: Cell protection using ExcelXP tagset

Hi:
I believe that TAGSETS.EXCELXP gives you ways to hide or freeze particular columns, but does not provide a method for protecting columns. I think this is because the method of protecting columns happens from an Excel drop down box that may not have an XML or Spreadsheet Markup Language tag that is "not" produce-able by TAGSETS.EXCELXP.

You may want to check with Tech Support whether this might be possible at all with other tagsets, such as TAGSETS.TABLEEDITOR or not.

cynthia
Valued Guide
Posts: 2,175

Re: Cell protection using ExcelXP tagset

if it's not there yet, I think it might be introduced to the tagset "real soon now" ;-)
See the developers paper "Paper 031-2010 ODS ExcelXP: Tag Attr Is It! Using and Understanding the TAGATTR= Style Attribute with the ExcelXP Tagset" at
http://support.sas.com/resources/papers/proceedings10/031-2010.pdf"

many of the snippets of generated XML show [/pre]
Ask a Question
Discussion stats
  • 2 replies
  • 304 views
  • 0 likes
  • 3 in conversation