-1

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" ?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:user="urn:my-scripts"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" >

<xsl:template match="/">
<ss:Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">

<!--<x:ExcelWorkbook>

<WindowHeight>5400</WindowHeight>

<WindowWidth>6534</WindowWidth>

<WindowTopX>120</WindowTopX>

<WindowTopY>30</WindowTopY>

<ProtectStructure>False</ProtectStructure>

<ProtectWindows>False</ProtectWindows>

</x:ExcelWorkbook>-->

<ss:Styles>

<ss:Style ss:ID="targets_title_bold">
<ss:Protection ss:Protected="1"/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss:Style>

<ss:Style ss:ID="targets_title_bold_color">
<ss:Protection ss:Protected="1"/>
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss:Style>

<ss:Style ss:ID="black_right">
<ss:Protection ss:Protected="1"/>
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
<Font x:CharSet="1" ss:Size="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss:Style>

<ss:Style ss:ID="black_left">
<ss:Protection ss:Protected="1"/>
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
<Font x:CharSet="1" ss:Size="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss:Style>

<Style ss:ID="s28">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:ReadingOrder="LeftToRight" ss:WrapText="1"/>
<Font x:CharSet="1" ss:Size="10" ss:Color="#808080" ss:Underline="Single"/>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>

<Style ss:ID="BoldColumn">
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
</Style>

<Style ss:ID="s29">
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="s30">
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="green">
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#99CC00" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="green_right">
<ss:Protection/>
<Font x:CharSet="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#99CC00" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>


<Style ss:ID="blue">
<ss:Protection/>
<Font x:CharSet="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="blue_left">
<ss:Protection ss:Protected="0"/>
<Font x:CharSet="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="blue_right">
<NumberFormat ss:Format="#,##0"/>
<ss:Protection ss:Protected="0"/>
<Font x:CharSet="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>


<Style ss:ID="yellow">
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>


<Style ss:ID="yellow_right">
<ss:Protection/>
<NumberFormat ss:Format="0" />
<Font x:CharSet="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="red">
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#FF0000" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="red_right">
<NumberFormat ss:Format="0"/>
<ss:Protection/>
<Font x:CharSet="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#FF0000" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>


<Style ss:ID="pink">
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Interior ss:Color="#FF5FFE" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="allign_right">
<ss:Protection/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>

</Style>

<Style ss:ID="allign_left">
<ss:Protection/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="bold">
<ss:Protection/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
</Style>

<Style ss:ID="Bold_Left">
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
</Style>

<Style ss:ID="Bold_Right">
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</Style>

<ss:Style ss:ID="target_minimum_effective" >
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="minimum_effective_date" >
<ss:Protection/>
<ss:Borders>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="target_minimum_expiration" >
<ss:Protection/>
<Font x:CharSet="1" ss:Bold="1" ss:Size="10" ss:Color="#000000"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="minimum_expiration_date" >
<ss:Protection/>
<ss:Borders>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="target_expiration_date" >
<ss:Protection ss:Protected="0"/>
<Interior ss:Color="#AEFFFF" ss:Pattern="Solid"/>
<ss:Borders>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="target_effective_date" >
<ss:Protection ss:Protected="0"/>
<Interior ss:Color="#AEFFFF" ss:Pattern="Solid"/>
<ss:Borders>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="business_address">
<ss:Protection/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="business_address_value">
<ss:Protection ss:Protected="0"/>
<Interior ss:Color="#AEFFFF" ss:Pattern="Solid"/>
<ss:Borders>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="blank">
<ss:Protection/>
</ss:Style>

<Style ss:ID="targets_white_number_right">
<ss:Protection ss:Protected="1"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<NumberFormat ss:Format="0" />
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="format_string">
<ss:Protection ss:Protected="1"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<NumberFormat ss:Format="#,##0"/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<ss:Style ss:ID="border">
<ss:Protection/>
<ss:Borders>
<ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss:Style>


<ss:Style ss:ID="red_error">
<ss:Protection ss:Protected="1"/>
<Interior ss:Color="#FF0000" ss:Pattern="Solid"/>
<ss:Borders>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="green_error">
<ss:Protection ss:Protected="1"/>
<Interior ss:Color="#00F200" ss:Pattern="Solid"/>
<ss:Borders>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss:Style>

<ss:Style ss:ID="yellow_error">
<ss:Protection ss:Protected="1"/>
<Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
<ss:Borders>
<ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss:Style>


</ss:Styles>

<ss:Worksheet ss:Protected="1" ss:Name="General">
<ss:Table>

<ss:Column ss:AutoFitWidth="0" ss:Width="127.284" />
<ss:Column ss:AutoFitWidth="0" ss:Width="146.700" />

<ss:Column ss:AutoFitWidth="0" ss:Width="48.20" />
<ss:Column ss:AutoFitWidth="0" ss:Width="128.79" />
<ss:Column ss:AutoFitWidth="0" ss:Width="81.337" />

<ss:Column ss:AutoFitWidth="0" ss:Width="48.20" />

<ss:Column ss:AutoFitWidth="0" ss:Width="48.20" />
<ss:Column ss:AutoFitWidth="0" ss:Width="48.20" />

<ss:Row>


<Cell ss:StyleID="s29">
<Data ss:Type="String">TBC - Rate Calculator</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">TBC v1.0</Data>
</Cell>


</ss:Row>

<!--///////////////// 2nd Row ///////////////////////////////-->


<ss:Row>


<Cell ss:StyleID="s29">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/cluster_id"/></Data>
</Cell>

</ss:Row>

<!--'//////////////////////////// 3rd Row ////////////////////////////////////////////////////-->

<Row ss:Index="3">


<Cell ss:StyleID="s29">
<Data ss:Type="String">Cluster</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/cluster_name"/></Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="target_minimum_effective">
<Data ss:Type="String">Minimum Effective Date</Data>
</Cell>

<Cell ss:StyleID="minimum_effective_date">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/minimum_effective_date"/></Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/template_id"/></Data>
</Cell>


</Row>

<!--'//////////////////////////////////////4th Row ///////////////////////////////////////-->

<Row ss:Index="4">


<Cell ss:StyleID="s29">
<Data ss:Type="String">Route</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/routes"/></Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="target_minimum_expiration" >
<Data ss:Type="String">Minimum Expiration Date</Data>
</Cell>

<Cell ss:StyleID="minimum_expiration_date">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/minimum_expiration_date"/></Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/main_id"/></Data>
</Cell>


</Row>

<!--'//////////////////////////////////////5th Row ////////////////////////////////////////////////////-->

<Row ss:Index="5">


<Cell ss:StyleID="s29">
<Data ss:Type="String">User ID</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/userid"/></Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

</Row>


<!--'//////////////////////////////////////6th Row ////////////////////////////////////////////////////-->

<Row ss:Index="6">


<Cell ss:StyleID="s29">
<Data ss:Type="String">Mail Address</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/mailaddress"/></Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="target_minimum_effective">
<Data ss:Type="String">Target Effective Date</Data>
</Cell>

<Cell ss:StyleID="target_effective_date">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/target_effective_date"/></Data>
</Cell>


</Row>


<!--'//////////////////////////////////////7th Row ////////////////////////////////////////////////////-->


<Row ss:Index="7">


<Cell ss:StyleID="s29">
<Data ss:Type="String">Date &amp; Time</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/datetime"/></Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="target_minimum_expiration">
<Data ss:Type="String">Target Expiration Date</Data>
</Cell>

<Cell ss:StyleID="target_expiration_date">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/target_expiration_date"/></Data>
</Cell>


</Row>


<!--'//////////////////////////////////////8th Row ////////////////////////////////////////////////////-->

<Row ss:Index="8">

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

</Row>


<!--'//////////////////////////////////////9th Row ////////////////////////////////////////////////////-->
<Row ss:Index="9">


<Cell ss:StyleID="green">
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Contract BAS rates</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>


</Row>

<!--'//////////////////////////////////////10th Row ////////////////////////////////////////////////////-->

<Row ss:Index="10">


<Cell ss:StyleID="yellow">
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Target BAS rates</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="business_address" >
<Data ss:Type="String">Business Address</Data>
</Cell>


<Cell ss:StyleID="business_address_value" ss:MergeAcross="10">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/business_address"/></Data>
</Cell>


</Row>

<!--'//////////////////////////////////////11th Row ////////////////////////////////////////////////////-->

<Row ss:Index="11">


<Cell ss:StyleID="red">
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Minimum BAS rates</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>


</Row>

<!--'//////////////////////////////////////12th Row ////////////////////////////////////////////////////-->

<Row ss:Index="12">


<Cell ss:StyleID="blue" >
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Editable fields</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>


<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

</Row>


<!--'//////////////////////////////////////13th Row ///////////////////////////////////////////////////-->

<Row ss:Index="13">


<Cell ss:StyleID="pink" >
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Mars Line > 30 days old</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

</Row>

<!--'//////////////////////////////////////14th Row ///////////////////////////////////////////////////-->

<Row ss:Index="14">


<Cell ss:StyleID="green" >
<Data ss:Type="String">columns titled "!"</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Line is OK</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

</Row>

<!--'//////////////////////////////////////15th Row ///////////////////////////////////////////////////-->

<Row ss:Index="15">


<Cell ss:StyleID="yellow" >
<Data ss:Type="String">columns titled "!" ?</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Target BAS > Contract BAS</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

</Row>

<!--'//////////////////////////////////////16th Row ///////////////////////////////////////////////////-->

<Row ss:Index="16">


<Cell ss:StyleID="red" >
<Data ss:Type="String">columns titled "!" !</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Line is inconsistent or</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

</Row>
<!--'//////////////////////////////////////17th Row //////////////////////////////////////////////////-->

<Row ss:Index="17">


<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Target BAS &lt; Minimum BAS</Data>
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>

</Row>


<!--'//////////////////////////////////////18th Row ////////////////////////////////////////////////////-->

<Row ss:Index="18">

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>


</Row>


<!--'//////////////////////////////////////19th Row ///////////////////////////////////////////////////-->

<Row ss:Index="19">


<Cell ss:StyleID="BoldColumn">
<Data ss:Type="String">Target Authority</Data>
</Cell>

<Cell ss:StyleID="blank">
<Data ss:Type="String">Receipt</Data>
</Cell>

<Cell ss:StyleID="blank" ss:MergeAcross="12">
<Data ss:Type="String">Receipt Country Cluster has authority to set Targets. Delivery Country Cluster has read access. </Data>
</Cell>

</Row>

<!--'//////////////////////////////////////20th Row ///////////////////////////////////////////////////-->

<Row ss:Index="20">


<Cell ss:StyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">Delivery</Data>
</Cell>

<Cell ss:StyleID="blank" ss:MergeAcross="12">
<Data ss:Type="String">Delivery Country Cluster has authority to set Targets. Receipt Country Cluster has read access.</Data>
</Cell>

</Row>

<!--'//////////////////////////////////////21th Row ///////////////////////////////////////////////////-->

<Row ss:Index="21">


<Cell ss:StyleID="BoldColumn">
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">RecExcl</Data>
</Cell>

<Cell ss:StyleID="blank" ss:MergeAcross="12">
<Data ss:Type="String">Receipt Exclusively. Receipt Country Cluster has authority to set Targets. Delivery Country Cluster has no access.</Data>
</Cell>

</Row>

<!--'//////////////////////////////////////22th Row ///////////////////////////////////////////////////-->

<Row ss:Index="22">


<Cell ss:StyleID="BoldColumn">
<Data ss:Type="String">
</Data>
</Cell>


<Cell ss:StyleID="blank">
<Data ss:Type="String">DelExcl</Data>
</Cell>

<Cell ss:StyleID="blank" ss:MergeAcross="12">
<Data ss:Type="String">Delivery Exclusively. Delivery Country Cluster has authority to set Targets. Receipt Country Cluster has no access.</Data>
</Cell>

</Row>

<!--'//////////////////////////////////////23th Row //////////////////////////////////////////////////-->

<Row ss:Index="23">

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

<Cell ss:StyleID="blank">
</Cell>

</Row>

<!--'//////////////////////////////////////24th Row //////////////////////////////////////////////////-->
<Row ss:Index="24">

<Cell ss:StyleID="Bold_Left">
<Data ss:Type="String">Exchange Rates (USD)</Data>
</Cell>

<Cell ss:StyleID="Bold_Left">
<Data ss:Type="String">Currency</Data>
</Cell>

<Cell ss:StyleID="Bold_Left">
<Data ss:Type="String">Code</Data>
</Cell>

<Cell ss:StyleID="Bold_Right">
<Data ss:Type="String">Rate</Data>
</Cell>

<Cell ss:StyleID="Bold_Right">
<Data ss:Type="String">Quotation Date</Data>
</Cell>


</Row>


<!--'//////////////////////////////////////,25,26,27,28,29,30,31 Row //////////////////////////////////////////////////-->

<xsl:for-each select="NewDataSet/Exchanges">
<Row>

<Cell ss:StyleID="Bold_Left">
<Data ss:Type="String">
</Data>
</Cell>

<Cell ss:StyleID="allign_left">
<Data ss:Type="String"><xsl:value-of select="currency"/></Data>
</Cell>


<Cell ss:StyleID="allign_left">
<Data ss:Type="String"><xsl:value-of select="code"/></Data>
</Cell>

<Cell ss:StyleID="allign_right">
<Data ss:Type="String"><xsl:value-of select="rate"/></Data>
</Cell>

<Cell ss:StyleID="allign_right">
<Data ss:Type="String"><xsl:value-of select="quotation_date"/></Data>
</Cell>

</Row>


</xsl:for-each>


<!--<xsl:for-each select="NewDataSet/Exchanges">

<ss:Row>

<ss:Cell ss:StyleID="targets_title_bold">
<ss:Data ss:Type="String">Receipt</ss:Data>
</ss:Cell>

<ss:Cell ss:StyleID="targets_title_bold">
<ss:Data ss:Type="String">Delivery</ss:Data>
</ss:Cell>

<ss:Cell ss:StyleID="targets_title_bold">
<ss:Data ss:Type="String">Cur</ss:Data>
</ss:Cell>

<ss:Cell ss:StyleID="targets_title_bold">
<ss:Data ss:Type="String">Cont</ss:Data>
</ss:Cell>

<ss:Cell ss:StyleID="targets_title_bold">
<ss:Data ss:Type="String">Cont</ss:Data>
</ss:Cell>

<ss:Cell>
<Data ss:Type="String">
<xsl:value-of select="name"/>
</Data>
</ss:Cell>

</ss:Row>

</xsl:for-each>-->


</ss:Table>

</ss:Worksheet >
<ss:Worksheet ss:Protected="1" ss:Name="Targets">

<ss:Table>

<!--<xsl:for-each select="NewDataSet/column">-->

<!--<xsl:if test="name &gt; 10">

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />
<ss:Column ss:AutoFitWidth="0" ss:Width="23.00" />
<ss:Column ss:AutoFitWidth="0" ss:Width="38.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />
<ss:Column ss:AutoFitWidth="0" ss:Width="23.00" />
<ss:Column ss:AutoFitWidth="0" ss:Width="38.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="26.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="29.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="27.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="50" />

<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />


<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />

<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />


<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />


<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />

<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />

<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="331.1" />

<ss:Column ss:AutoFitWidth="0" ss:Width="150" />
<ss:Column ss:AutoFitWidth="0" ss:Width="200" />

<ss:Column ss:AutoFitWidth="0" ss:Width="150" />
<ss:Column ss:AutoFitWidth="0" ss:Width="200" />

<ss:Column ss:AutoFitWidth="0" ss:Width="54.5" />

<ss:Column ss:AutoFitWidth="0" ss:Width="74.11" />

<ss:Column ss:AutoFitWidth="0" ss:Width="31.4" />

<ss:Column ss:AutoFitWidth="0" ss:Width="35.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="31.4" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />

<ss:Column ss:AutoFitWidth="0" ss:Width="44.7" />

<ss:Row>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Group</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CC</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Code</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Group</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CC</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Code</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Size</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Type</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Authority</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">in BAS currency as per BAS in MARS contract</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Country</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Port</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Country</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Port</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Date</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Line Nbr</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">qa</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String"> </Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Target of Minimum</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Target of Contract</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Target of Minimum</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Target of Contract</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>

</ss:Row>

</xsl:if>-->

<!--<xsl:if test="name &lt; 10">

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />
<ss:Column ss:AutoFitWidth="0" ss:Width="23.00" />
<ss:Column ss:AutoFitWidth="0" ss:Width="38.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />
<ss:Column ss:AutoFitWidth="0" ss:Width="23.00" />
<ss:Column ss:AutoFitWidth="0" ss:Width="38.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="26.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="29.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="27.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="50" />

<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />


<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />

<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />


<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />


<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />

<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="49.145" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />
<ss:Column ss:AutoFitWidth="0" ss:Width="37" />

<ss:Column ss:AutoFitWidth="0" ss:Width="7.69" />

<ss:Column ss:AutoFitWidth="0" ss:Width="331.1" />

<ss:Column ss:AutoFitWidth="0" ss:Width="150" />
<ss:Column ss:AutoFitWidth="0" ss:Width="200" />

<ss:Column ss:AutoFitWidth="0" ss:Width="150" />
<ss:Column ss:AutoFitWidth="0" ss:Width="200" />

<ss:Column ss:AutoFitWidth="0" ss:Width="54.5" />

<ss:Column ss:AutoFitWidth="0" ss:Width="74.11" />

<ss:Column ss:AutoFitWidth="0" ss:Width="31.4" />

<ss:Column ss:AutoFitWidth="0" ss:Width="35.00" />

<ss:Column ss:AutoFitWidth="0" ss:Width="31.4" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />

<ss:Column ss:AutoFitWidth="0" ss:Width="65" />

<ss:Column ss:AutoFitWidth="0" ss:Width="44.7" />

<ss:Row>
-->

<!--targets_title_bold--><!--
<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Group</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CC</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Code</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Group</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CC</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Code</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Size</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Type</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Authority</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>


<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">in BAS currency as per BAS in MARS contract</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Country</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Port</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Country</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Port</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Date</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold_color">
<Data ss:Type="String">Line Nbr</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">qa</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String"> </Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Target of Minimum</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Target of Contract</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Target of Minimum</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String">Target of Contract</Data>
</Cell>

<Cell ss:StyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>

</ss:Row>

</xsl:if>-->

<!--</xsl:for-each>-->

<xsl:apply-templates />

</ss:Table>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<AllowFilter/>
</WorksheetOptions>
<AutoFilter x:Range="R2C1:R2C63"
xmlns="urn:schemas-microsoft-com:office:excel">
</AutoFilter>

<x:AutoFilter x:Range="R1C1:R1C60">
<x:AutoFilterColumn x:Hiden="false" x:Index="1" x:Type="All">
</x:AutoFilterColumn>
</x:AutoFilter>-->
</ss:Worksheet >

</ss:Workbook >

</xsl:template>

<xsl:template match="NewDataSet">

<xsl:apply-templates />

</xsl:template>


<xsl:template match="Table1">
</xsl:template>-->


</xsl:stylesheet>


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

Many Thanks

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by WenCounty
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.