 |  |  |  |  |  |  |  |
Password protect SpreadsheetML
Please support our XML, XSLT and XPATH advertiser: Intel Parallel Studio Home
 |
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
tyles>
<sstyle ss:ID="targets_title_bold">
<ss
rotection ssrotected="1"/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</sstyle>
<sstyle ss:ID="targets_title_bold_color">
<ssrotection ssrotected="1"/>
<Interior ss:Color="#C0C0C0" ssattern="Solid"/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</sstyle>
<sstyle ss:ID="black_right">
<ssrotection ssrotected="1"/>
<Interior ss:Color="#C0C0C0" ssattern="Solid"/>
<Font x:CharSet="1" ssize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</sstyle>
<sstyle ss:ID="black_left">
<ssrotection ssrotected="1"/>
<Interior ss:Color="#C0C0C0" ssattern="Solid"/>
<Font x:CharSet="1" ssize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</sstyle>
<Style ss:ID="s28">
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:ReadingOrder="LeftToRight" ss:WrapText="1"/>
<Font x:CharSet="1" ssize="10" ss:Color="#808080" ss:Underline="Single"/>
<Interior ss:Color="#FFFFFF" ssattern="Solid"/>
</Style>
<Style ss:ID="BoldColumn">
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
</Style>
<Style ss:ID="s29">
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#C0C0C0" ssattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="s30">
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="green">
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#99CC00" ssattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="green_right">
<ssrotection/>
<Font x:CharSet="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#99CC00" ssattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>
<Style ss:ID="blue">
<ssrotection/>
<Font x:CharSet="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ssattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="blue_left">
<ssrotection ssrotected="0"/>
<Font x:CharSet="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ssattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>
<Style ss:ID="blue_right">
<NumberFormat ss:Format="#,##0"/>
<ssrotection ssrotected="0"/>
<Font x:CharSet="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#AEFFFF" ssattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>
<Style ss:ID="yellow">
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#FFFF00" ssattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="yellow_right">
<ssrotection/>
<NumberFormat ss:Format="0" />
<Font x:CharSet="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#FFFF00" ssattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>
<Style ss:ID="red">
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#FF0000" ssattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="red_right">
<NumberFormat ss:Format="0"/>
<ssrotection/>
<Font x:CharSet="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#FF0000" ssattern="Solid"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>
<Style ss:ID="pink">
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Interior ss:Color="#FF5FFE" ssattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="allign_right">
<ssrotection/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="allign_left">
<ssrotection/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="bold">
<ssrotection/>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
</Style>
<Style ss:ID="Bold_Left">
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
</Style>
<Style ss:ID="Bold_Right">
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</Style>
<sstyle ss:ID="target_minimum_effective" >
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="minimum_effective_date" >
<ssrotection/>
<ss:Borders>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="target_minimum_expiration" >
<ssrotection/>
<Font x:CharSet="1" ss:Bold="1" ssize="10" ss:Color="#000000"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="minimum_expiration_date" >
<ssrotection/>
<ss:Borders>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="target_expiration_date" >
<ssrotection ssrotected="0"/>
<Interior ss:Color="#AEFFFF" ssattern="Solid"/>
<ss:Borders>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="target_effective_date" >
<ssrotection ssrotected="0"/>
<Interior ss:Color="#AEFFFF" ssattern="Solid"/>
<ss:Borders>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="business_address">
<ssrotection/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="business_address_value">
<ssrotection ssrotected="0"/>
<Interior ss:Color="#AEFFFF" ssattern="Solid"/>
<ss:Borders>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="blank">
<ssrotection/>
</sstyle>
<Style ss:ID="targets_white_number_right">
<ssrotection ssrotected="1"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<NumberFormat ss:Format="0" />
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>
<Style ss:ID="format_string">
<ssrotection ssrotected="1"/>
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<NumberFormat ss:Format="#,##0"/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</Style>
<sstyle ss:ID="border">
<ssrotection/>
<ss:Borders>
<ss:Border ssosition="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</ss:Borders>
</sstyle>
<sstyle ss:ID="red_error">
<ssrotection ssrotected="1"/>
<Interior ss:Color="#FF0000" ssattern="Solid"/>
<ss:Borders>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="green_error">
<ssrotection ssrotected="1"/>
<Interior ss:Color="#00F200" ssattern="Solid"/>
<ss:Borders>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</sstyle>
<sstyle ss:ID="yellow_error">
<ssrotection ssrotected="1"/>
<Interior ss:Color="#FFFF00" ssattern="Solid"/>
<ss:Borders>
<ss:Border ssosition="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
<ss:Border ssosition="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
</ss:Borders>
<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
</sstyle>
</sstyles>
<ss:Worksheet ssrotected="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 sstyleID="s29">
<Data ss:Type="String">TBC - Rate Calculator</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">TBC v1.0</Data>
</Cell>
</ss:Row>
<!--///////////////// 2nd Row ///////////////////////////////-->
<ss:Row>
<Cell sstyleID="s29">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/cluster_id"/></Data>
</Cell>
</ss:Row>
<!--'//////////////////////////// 3rd Row ////////////////////////////////////////////////////-->
<Row ss:Index="3">
<Cell sstyleID="s29">
<Data ss:Type="String">Cluster</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/cluster_name"/></Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="target_minimum_effective">
<Data ss:Type="String">Minimum Effective Date</Data>
</Cell>
<Cell sstyleID="minimum_effective_date">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/minimum_effective_date"/></Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/template_id"/></Data>
</Cell>
</Row>
<!--'//////////////////////////////////////4th Row ///////////////////////////////////////-->
<Row ss:Index="4">
<Cell sstyleID="s29">
<Data ss:Type="String">Route</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/routes"/></Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="target_minimum_expiration" >
<Data ss:Type="String">Minimum Expiration Date</Data>
</Cell>
<Cell sstyleID="minimum_expiration_date">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/minimum_expiration_date"/></Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/main_id"/></Data>
</Cell>
</Row>
<!--'//////////////////////////////////////5th Row ////////////////////////////////////////////////////-->
<Row ss:Index="5">
<Cell sstyleID="s29">
<Data ss:Type="String">User ID</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/userid"/></Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////6th Row ////////////////////////////////////////////////////-->
<Row ss:Index="6">
<Cell sstyleID="s29">
<Data ss:Type="String">Mail Address</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/mailaddress"/></Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="target_minimum_effective">
<Data ss:Type="String">Target Effective Date</Data>
</Cell>
<Cell sstyleID="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 sstyleID="s29">
<Data ss:Type="String">Date & Time</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String"><xsl:value-of select="NewDataSet/General/datetime"/></Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="target_minimum_expiration">
<Data ss:Type="String">Target Expiration Date</Data>
</Cell>
<Cell sstyleID="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 sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
</Row>
<!--'//////////////////////////////////////9th Row ////////////////////////////////////////////////////-->
<Row ss:Index="9">
<Cell sstyleID="green">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Contract BAS rates</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////10th Row ////////////////////////////////////////////////////-->
<Row ss:Index="10">
<Cell sstyleID="yellow">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Target BAS rates</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="business_address" >
<Data ss:Type="String">Business Address</Data>
</Cell>
<Cell sstyleID="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 sstyleID="red">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Minimum BAS rates</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
</Row>
<!--'//////////////////////////////////////12th Row ////////////////////////////////////////////////////-->
<Row ss:Index="12">
<Cell sstyleID="blue" >
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Editable fields</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////13th Row ///////////////////////////////////////////////////-->
<Row ss:Index="13">
<Cell sstyleID="pink" >
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Mars Line > 30 days old</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////14th Row ///////////////////////////////////////////////////-->
<Row ss:Index="14">
<Cell sstyleID="green" >
<Data ss:Type="String">columns titled "!"</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Line is OK</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////15th Row ///////////////////////////////////////////////////-->
<Row ss:Index="15">
<Cell sstyleID="yellow" >
<Data ss:Type="String">columns titled "!" ?</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Target BAS > Contract BAS</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////16th Row ///////////////////////////////////////////////////-->
<Row ss:Index="16">
<Cell sstyleID="red" >
<Data ss:Type="String">columns titled "!" !</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Line is inconsistent or</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////17th Row //////////////////////////////////////////////////-->
<Row ss:Index="17">
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Target BAS < Minimum BAS</Data>
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////18th Row ////////////////////////////////////////////////////-->
<Row ss:Index="18">
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
</Row>
<!--'//////////////////////////////////////19th Row ///////////////////////////////////////////////////-->
<Row ss:Index="19">
<Cell sstyleID="BoldColumn">
<Data ss:Type="String">Target Authority</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Receipt</Data>
</Cell>
<Cell sstyleID="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 sstyleID="blank">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">Delivery</Data>
</Cell>
<Cell sstyleID="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 sstyleID="BoldColumn">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">RecExcl</Data>
</Cell>
<Cell sstyleID="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 sstyleID="BoldColumn">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="blank">
<Data ss:Type="String">DelExcl</Data>
</Cell>
<Cell sstyleID="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 sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
<Cell sstyleID="blank">
</Cell>
</Row>
<!--'//////////////////////////////////////24th Row //////////////////////////////////////////////////-->
<Row ss:Index="24">
<Cell sstyleID="Bold_Left">
<Data ss:Type="String">Exchange Rates (USD)</Data>
</Cell>
<Cell sstyleID="Bold_Left">
<Data ss:Type="String">Currency</Data>
</Cell>
<Cell sstyleID="Bold_Left">
<Data ss:Type="String">Code</Data>
</Cell>
<Cell sstyleID="Bold_Right">
<Data ss:Type="String">Rate</Data>
</Cell>
<Cell sstyleID="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 sstyleID="Bold_Left">
<Data ss:Type="String">
</Data>
</Cell>
<Cell sstyleID="allign_left">
<Data ss:Type="String"><xsl:value-of select="currency"/></Data>
</Cell>
<Cell sstyleID="allign_left">
<Data ss:Type="String"><xsl:value-of select="code"/></Data>
</Cell>
<Cell sstyleID="allign_right">
<Data ss:Type="String"><xsl:value-of select="rate"/></Data>
</Cell>
<Cell sstyleID="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 sstyleID="targets_title_bold">
<ss
ata ss:Type="String">Receipt</ssata>
</ss:Cell>
<ss:Cell sstyleID="targets_title_bold">
<ssata ss:Type="String">Delivery</ssata>
</ss:Cell>
<ss:Cell sstyleID="targets_title_bold">
<ssata ss:Type="String">Cur</ssata>
</ss:Cell>
<ss:Cell sstyleID="targets_title_bold">
<ssata ss:Type="String">Cont</ssata>
</ss:Cell>
<ss:Cell sstyleID="targets_title_bold">
<ssata ss:Type="String">Cont</ssata>
</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 ssrotected="1" ss:Name="Targets">
<ss:Table>
<!--<xsl:for-each select="NewDataSet/column">-->
<!--<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 sstyleID="targets_title_bold">
<Data ss:Type="String">Group</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CC</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Code</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Group</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CC</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Code</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Size</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Type</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Authority</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">in BAS currency as per BAS in MARS contract</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Country</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Port</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Country</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Port</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Date</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Line Nbr</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">qa</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String"> </Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Target of Minimum</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Target of Contract</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Target of Minimum</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Target of Contract</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>
</ss:Row>
</xsl:if>-->
<!--<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>
-->
<!--targets_title_bold--><!--
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Group</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CC</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Code</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Group</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CC</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Code</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Size</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Type</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Authority</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Reven</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">BAS OPA DPA IHE IHI</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">CYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OMarg</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">OYield</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">!</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">in BAS currency as per BAS in MARS contract</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Country</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Port</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Country</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Port</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Date</Data>
</Cell>
<Cell sstyleID="targets_title_bold_color">
<Data ss:Type="String">Line Nbr</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">qa</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String"> </Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String"></Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Target of Minimum</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Target of Contract</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Target of Minimum</Data>
</Cell>
<Cell sstyleID="targets_title_bold">
<Data ss:Type="String">Target of Contract</Data>
</Cell>
<Cell sstyleID="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
<?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
tyles><ss
tyle ss:ID="targets_title_bold"><ss
rotection ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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 ssrotected="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"></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>
<Cell ss
tyleID="blank"><Data ss:Type="String">TBC v1.0</Data>
</Cell>
</ss:Row>
<!--///////////////// 2nd 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"></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>
<Cell ss
tyleID="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
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">
</Data>
</Cell>
<Cell ss
tyleID="blank"><Data ss:Type="String"><xsl:value-of select="NewDataSet/General/template_id"/></Data>
</Cell>
</Row>
<!--'//////////////////////////////////////4th 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">
</Data>
</Cell>
<Cell ss
tyleID="blank"><Data ss:Type="String"><xsl:value-of select="NewDataSet/General/main_id"/></Data>
</Cell>
</Row>
<!--'//////////////////////////////////////5th 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"></Cell>
<Cell ss
tyleID="blank"></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>
<!--'//////////////////////////////////////6th 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>
<!--'//////////////////////////////////////7th 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>
<!--'//////////////////////////////////////8th Row ////////////////////////////////////////////////////-->
<Row ss:Index="8">
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
</Row>
<!--'//////////////////////////////////////9th 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"></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>
<Cell ss
tyleID="blank"><Data ss:Type="String">
</Data>
</Cell>
</Row>
<!--'//////////////////////////////////////10th 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>
<!--'//////////////////////////////////////11th 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"></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>
<Cell ss
tyleID="blank"></Cell>
</Row>
<!--'//////////////////////////////////////12th 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"></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>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></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>
<!--'//////////////////////////////////////13th 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"></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>
<!--'//////////////////////////////////////14th 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"></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>
<!--'//////////////////////////////////////15th 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"></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>
<!--'//////////////////////////////////////16th 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"></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>
<!--'//////////////////////////////////////17th 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"></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>
<!--'//////////////////////////////////////18th Row ////////////////////////////////////////////////////-->
<Row ss:Index="18">
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
</Row>
<!--'//////////////////////////////////////19th 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>
<!--'//////////////////////////////////////20th 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>
<!--'//////////////////////////////////////21th 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>
<!--'//////////////////////////////////////22th 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>
<!--'//////////////////////////////////////23th Row //////////////////////////////////////////////////-->
<Row ss:Index="23">
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
<Cell ss
tyleID="blank"></Cell>
</Row>
<!--'//////////////////////////////////////24th 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>
<!--'//////////////////////////////////////,25,26,27,28,29,30,31 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</ssata></ss:Cell>
<ss:Cell ss
tyleID="targets_title_bold"><ss
ata ss:Type="String">Delivery</ssata></ss:Cell>
<ss:Cell ss
tyleID="targets_title_bold"><ss
ata ss:Type="String">Cur</ssata></ss:Cell>
<ss:Cell ss
tyleID="targets_title_bold"><ss
ata ss:Type="String">Cont</ssata></ss:Cell>
<ss:Cell ss
tyleID="targets_title_bold"><ss
ata ss:Type="String">Cont</ssata></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:for-each select="NewDataSet/column">-->
<!--<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
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
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
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
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
tyleID="targets_title_bold"><Data ss:Type="String">!</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">in BAS currency as per BAS in MARS contract</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Country</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Port</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Country</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Port</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Date</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Line Nbr</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">qa</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String"> </Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String"></Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">Target of Minimum</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">Target of Contract</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">Target of Minimum</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">Target of Contract</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String"></Data>
</Cell>
</ss:Row>
</xsl:if>-->
<!--<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>
-->
<!--targets_title_bold--><!--
<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
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
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
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
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
tyleID="targets_title_bold"><Data ss:Type="String">!</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">in BAS currency as per BAS in MARS contract</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Country</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Port</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Country</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Port</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Date</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold_color"><Data ss:Type="String">Line Nbr</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">qa</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String"> </Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String"></Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">Target of Minimum</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">Target of Contract</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">Target of Minimum</Data>
</Cell>
<Cell ss
tyleID="targets_title_bold"><Data ss:Type="String">Target of Contract</Data>
</Cell>
<Cell ss
tyleID="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
|
Similar Threads
- Password protect with cookie (JavaScript / DHTML / AJAX)
- How to password protect a file folder (Windows NT / 2000 / XP)
- Password Protect without .htaccess (IT Professionals' Lounge)
- Password protect code (JavaScript / DHTML / AJAX)
- How do I password protect folders? (Windows NT / 2000 / XP)
- password protect folder on a network (Network Security)
Other Threads in the XML, XSLT and XPATH Forum
- Previous Thread: Following XSLT Logic Not Working
- Next Thread: Variable not working as expected?
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest XML, XSLT and XPATH Posts
- Today's Posts
- Unanswered Threads
