954,113 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Password protect SpreadsheetML

I am using XSL to transform the XML.I am generating a Excel sheet using XML/XSLT. I want to password protect the sheet. If a user try to modify any cell then it ask for password?

<?xml version ="1.0" encoding ="utf-8" ?>

TBC - Rate CalculatorTBC v1.0ClusterMinimum Effective DateRouteMinimum Expiration DateUser IDMail AddressTarget Effective DateDate & TimeTarget Expiration DateContract BAS ratesTarget BAS ratesBusiness AddressMinimum BAS ratesEditable fieldsMars Line > 30 days oldcolumns titled "!"Line is OKcolumns titled "!" ?Target BAS > Contract BAScolumns titled "!" !Line is inconsistent orTarget BAS < Minimum BASTarget AuthorityReceiptReceipt Country Cluster has authority to set Targets. Delivery Country Cluster has read access. DeliveryDelivery Country Cluster has authority to set Targets. Receipt Country Cluster has read access.RecExclReceipt Exclusively. Receipt Country Cluster has authority to set Targets. Delivery Country Cluster has no access.DelExclDelivery Exclusively. Delivery Country Cluster has authority to set Targets. Receipt Country Cluster has no access.Exchange Rates (USD)CurrencyCodeRateQuotation Date-->
-->


How to password protect the sheet in Excel sheet genearted using XML/XSLT?

Many Thanks

anshuman444
Newbie Poster
1 post since Oct 2009
Reputation Points: 10
Solved Threads: 0
 

Has this problem been solved? I am trying to do the same thing in ColdFusion using XML. Your help would be much appreciated.

WenCounty
Newbie Poster
3 posts since Mar 2008
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: