topic Re: excel tagset option? in ODS and Base Reporting

excel tagset option?

anu — Thu, 16 May 2013 20:00:22 GMT

Hi Everyone - I'm generating files by customer using excelxp tagset and the requirement is that they should be read-only. Is there an option that can be used with excelxp tagset to create a READ_ONLY excel file?Any suggestion is appreciated.

Thanks,

Anu.

Re: excel tagset option?

Chevell_sas — Thu, 16 May 2013 21:22:33 GMT

Hello Anu,

Unfortunately, XML Spreadsheet specificationwhich the ExcelXP tagset follows does not include this functionality of READ_ONLY files, therefore it is not added with the tagset.

SIncerely,

Chevell

Re: excel tagset option?

anu — Fri, 17 May 2013 13:13:22 GMT

Thanks Chevell. Is there any other way of creating READ ONLY files?

Re: excel tagset option?

Chevell_sas — Fri, 17 May 2013 14:41:19 GMT

Anu,

We can post process the file using DDE or VBScript if you are on windows. Send me an email or open a tracking entry with Technical Support and I can put together a sample.

Chevell.

Re: excel tagset option?

anu — Tue, 21 May 2013 13:24:48 GMT

Chevell - The process was created and tested in windows which we no longer use. Going forward we will be using SAS on Unix Server. What details will you need from me?

Thanks,

Anu.

Re: excel tagset option?

Chevell_sas — Wed, 22 May 2013 13:28:03 GMT

Anu, this process that I mentioned as far as post processing the files will not work on Windows but not Unix unfortunately.

Re: excel tagset option?

PaulLee — Thu, 23 May 2013 13:37:26 GMT

Another way to post process the file is by running an X command using SAS after file creation to "chmod" the file?