Доброго времени суток.
Есть xslt шаблон
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
<?xml version="1.0" encoding="utf-8" ?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
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="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:ms="urn:schemas-microsoft-com:xslt"
>
<xsl:output version="1.0" encoding="utf-8" standalone="yes" method="xml" omit-xml-declaration="no" />
<xsl:decimal-format grouping-separator=" " decimal-separator="," name="rus-money"/>
<xsl:variable name="DateFormat" select="'dd.MM.yyyy'" />
<xsl:template match="/Report">
<xsl:processing-instruction name="mso-application">
<xsl:text>progid="Excel.Sheet"</xsl:text>
</xsl:processing-instruction>
<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">
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight> 13890 </WindowHeight>
<WindowWidth> 18975 </WindowWidth>
<WindowTopX> 120 </WindowTopX>
<WindowTopY> 60 </WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font ss:FontName="Arial Cyr" x:CharSet="204"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s21">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Font ss:FontName="Arial Cyr" x:CharSet="204" ss:Bold="1"/>
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="s22">
<Font ss:FontName="Arial Cyr" x:CharSet="204" ss:Bold="1"/>
<Interior/>
</Style>
</Styles>
<Worksheet ss:Name="Товары">
<Table ss:ExpandedColumnCount="14" x:FullColumns="1"
x:FullRows="1">
<Row>
<Cell ss:MergeAcross="6">
<Data ss:Type="String">Компания1</Data>
</Cell>
<Cell ss:MergeAcross="6">
<Data ss:Type="String">Компания2</Data>
</Cell>
</Row>
</Table>
</WorkSheet>
Нужно размножить Лист с Товарами несколько раз, подскажите как это сделать?
