Ad:

XML, XSLT and XPATH Discussion Thread
Unsolved
Views: 1595

Oct 25th, 2009

-1

Password protect SpreadsheetML

Expand Post »

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



<ss

tyles>

<ss

tyle ss:ID="targets_title_bold">
<ss

rotection ss

rotected="1"/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss

tyle>

<ss

tyle ss:ID="targets_title_bold_color">
<ss

rotection ss

rotected="1"/>
<Interior ss:Color="#C0C0C0" ss

attern="Solid"/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss

tyle>

<ss

tyle ss:ID="black_right">
<ss

rotection ss

rotected="1"/>
<Interior ss:Color="#C0C0C0" ss

attern="Solid"/>
<Font x:CharSet="1" ss

ize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss

tyle>

<ss

tyle ss:ID="black_left">
<ss

rotection ss

rotected="1"/>
<Interior ss:Color="#C0C0C0" ss

attern="Solid"/>
<Font x:CharSet="1" ss

ize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss

tyle>

<Style ss:ID="s28">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:ReadingOrder="LeftToRight" ss:WrapText="1"/>
<Font x:CharSet="1" ss

ize="10" ss:Color="#808080" ss:Underline="Single"/>
<Interior ss:Color="#FFFFFF" ss

attern="Solid"/>
</Style>

<Style ss:ID="BoldColumn">
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
</Style>

<Style ss:ID="s29">
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#C0C0C0" ss

attern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="s30">
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="green">
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#99CC00" ss

attern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="green_right">
<ss

rotection/>
<Font x:CharSet="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#99CC00" ss

attern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="blue">
<ss

rotection/>
<Font x:CharSet="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ss

attern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="blue_left">
<ss

rotection ss

rotected="0"/>
<Font x:CharSet="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ss

attern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="blue_right">
<NumberFormat ss:Format="#,##0"/>
<ss

rotection ss

rotected="0"/>
<Font x:CharSet="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ss

attern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="yellow">
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#FFFF00" ss

attern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="yellow_right">
<ss

rotection/>
<NumberFormat ss:Format="0" />
<Font x:CharSet="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#FFFF00" ss

attern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="red">
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#FF0000" ss

attern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="red_right">
<NumberFormat ss:Format="0"/>
<ss

rotection/>
<Font x:CharSet="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#FF0000" ss

attern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="pink">
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Interior ss:Color="#FF5FFE" ss

attern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="allign_right">
<ss

rotection/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>

</Style>

<Style ss:ID="allign_left">
<ss

rotection/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>

<Style ss:ID="bold">
<ss

rotection/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
</Style>

<Style ss:ID="Bold_Left">
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
</Style>

<Style ss:ID="Bold_Right">
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</Style>

<ss

tyle ss:ID="target_minimum_effective" >
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="minimum_effective_date" >
<ss

rotection/>
<ss:Borders>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="target_minimum_expiration" >
<ss

rotection/>
<Font x:CharSet="1" ss:Bold="1" ss

ize="10" ss:Color="#000000"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="minimum_expiration_date" >
<ss

rotection/>
<ss:Borders>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="target_expiration_date" >
<ss

rotection ss

rotected="0"/>
<Interior ss:Color="#AEFFFF" ss

attern="Solid"/>
<ss:Borders>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="target_effective_date" >
<ss

rotection ss

rotected="0"/>
<Interior ss:Color="#AEFFFF" ss

attern="Solid"/>
<ss:Borders>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="business_address">
<ss

rotection/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="business_address_value">
<ss

rotection ss

rotected="0"/>
<Interior ss:Color="#AEFFFF" ss

attern="Solid"/>
<ss:Borders>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="blank">
<ss

rotection/>
</ss

tyle>

<Style ss:ID="targets_white_number_right">
<ss

rotection ss

rotected="1"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<NumberFormat ss:Format="0" />
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<Style ss:ID="format_string">
<ss

rotection ss

rotected="1"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<NumberFormat ss:Format="#,##0"/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>

<ss

tyle ss:ID="border">
<ss

rotection/>
<ss:Borders>
<ss:Border ss

osition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</ss

tyle>

<ss

tyle ss:ID="red_error">
<ss

rotection ss

rotected="1"/>
<Interior ss:Color="#FF0000" ss

attern="Solid"/>
<ss:Borders>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="green_error">
<ss

rotection ss

rotected="1"/>
<Interior ss:Color="#00F200" ss

attern="Solid"/>
<ss:Borders>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss

tyle>

<ss

tyle ss:ID="yellow_error">
<ss

rotection ss

rotected="1"/>
<Interior ss:Color="#FFFF00" ss

attern="Solid"/>
<ss:Borders>
<ss:Border ss

osition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ss

osition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</ss

tyle>

</ss

tyles>

<ss:Worksheet ss

rotected="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

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</ss:Row>



<ss:Row>

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</ss:Row>



<Row ss:Index="3">

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="4">

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="5">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="6">

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="7">

<Cell ss

tyleID="s29">
<Data ss:Type="String">Date & Time</Data>
</Cell>

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="8">

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

tyleID="blank">
</Cell>

</Row>


<Row ss:Index="9">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="10">

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="11">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

</Row>



<Row ss:Index="12">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="13">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="14">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="15">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="16">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</Row>


<Row ss:Index="17">

<Cell ss

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

<Cell ss

tyleID="blank">
<Data ss:Type="String">Target BAS < Minimum BAS</Data>
</Cell>

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

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

<Cell ss

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

</Row>



<Row ss:Index="18">

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

tyleID="blank">
</Cell>

</Row>



<Row ss:Index="19">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="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>



<Row ss:Index="20">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="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>



<Row ss:Index="21">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="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>



<Row ss:Index="22">

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="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>



<Row ss:Index="23">

<Cell ss

tyleID="blank">
</Cell>

<Cell ss

tyleID="blank">
</Cell>

</Row>


<Row ss:Index="24">

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

</Row>



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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

tyleID="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

tyleID="targets_title_bold">
<ss

ata ss:Type="String">Receipt</ss

ata>
</ss:Cell>

<ss:Cell ss

tyleID="targets_title_bold">
<ss

ata ss:Type="String">Delivery</ss

ata>
</ss:Cell>

<ss:Cell ss

tyleID="targets_title_bold">
<ss

ata ss:Type="String">Cur</ss

ata>
</ss:Cell>

<ss:Cell ss

tyleID="targets_title_bold">
<ss

ata ss:Type="String">Cont</ss

ata>
</ss:Cell>

<ss:Cell ss

tyleID="targets_title_bold">
<ss

ata ss:Type="String">Cont</ss

ata>
</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

rotected="1" ss:Name="Targets">

<ss:Table>



<!--<xsl:if test="name > 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

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss

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

<Cell ss