Добрый день!
Есть задача сохранить на выходе вид страничного режима в файле .xlsx. Нужен для печати последующей. Подскажите пожалуйста какой элемент в файле Sheet отвечает за это и где можно поковыряться с настройками для корректного отражения?
имеющийся код сейчас выглядит так:
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.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions" xmlns:rs="http://ReportService">
<xsl:include href="xlsx_templates.xslt"/>
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" exclude-result-prefixes="#all"/>
<xsl:template match="/" name="WorkBook">
<xsl:variable name="filename" select="concat('s2-', format-dateTime(current-dateTime(), '[Y01].[M01].[D01].[H01].[m01].[s01].[f001]'), '.xml')"/>
<xsl:variable name="excelLetters" as="xs:string*">
<xsl:call-template name="col_alphabet_names">
<xsl:with-param name="count" select="$s2_table_title_col_offset + 1"/>
<xsl:with-param name="max" select="$s2_maxcol"/>
</xsl:call-template>
</xsl:variable>
<xsl:variable name="datacontext" select="."/>
<xsl:result-document href="{$filename}">
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing" xmlns:x14="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">
<sheetPr>
<pageSetUpPr fitToPage="1"/>
</sheetPr>
<dimension ref="A1:{$excelLetters[last()]}{$s2_maxrow}"/>
<sheetViews>
<sheetView tabSelected="1" view="pageBreakPreview" zoomScale="70" zoomScaleNormal="100" zoomScaleSheetLayoutView="70" workbookViewId="0">
<selection activeCell="BF6" sqref="BF6"/>
</sheetView>
</sheetViews>
<sheetFormatPr defaultColWidth="11.7109375" defaultRowHeight="12.75" x14ac:dyDescent="0.2"/>
<cols>
<col min="1" max="1" width="5.42578125" customWidth="1"/>
<!--подписи под листом - 66 ячеек-->
<col min="2" max="{max(($s2_maxcol, 66))}" width="19" customWidth="1"/>
</cols>
<sheetData>
<row r="1" spans="1:{$s2_maxcol}" x14ac:dyDescent="0.2">
<c r="A1" s="25" t="inlineStr">
<!--Договор №-->
<is>
<t>
Договор № <xsl:value-of select="((//LogicDeviceProperties/LDP[@LDP.Code = 'AgrNo'])[1])"/>
</t>
</is>
</c>
<c r="B1" s="26"/>
<c r="C1" s="26"/>
</row>
<row r="2" spans="1:{$s2_maxcol}" ht="2.1" customHeight="1" x14ac:dyDescent="0.2">
<!--Скрытая строка-->
<xsl:for-each select="$s2_table_title_col_offset + 1 to $s2_maxcol">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<c r="{$rowletter}2" s="26"/>
</xsl:for-each>
</row>
<row r="3" spans="1:{$s2_maxcol}" x14ac:dyDescent="0.2">
<c r="A3" s="73" t="inlineStr">
<is>
<t>№ п.п.</t>
</is>
</c>
<c r="B3" s="73"/>
<xsl:for-each select="$s2_table_title_col_offset + 1 to $s2_maxcol">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<c r="{$rowletter}3" s="3">
<v>
<xsl:value-of select="position()"/>
</v>
</c>
</xsl:for-each>
</row>
<row r="4" spans="1:{$s2_maxcol}" ht="229.5" x14ac:dyDescent="0.2">
<c r="A4" s="73" t="inlineStr">
<is>
<t>Наименование питающей линии, питающего центра (принадлежность сетей) точки поставки</t>
</is>
</c>
<c r="B4" s="73"/>
<xsl:for-each select="$datacontext//LogicDevice">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<c r="{$rowletter}4" s="24" t="inlineStr">
<is>
<t>
<xsl:value-of select=".//LogicDeviceProperties/LDP[@LDP.Code='AccountPoint']"/>
</t>
</is>
</c>
</xsl:for-each>
</row>
<row r="5" spans="1:{$s2_maxcol}" ht="191.25" x14ac:dyDescent="0.2">
<c r="A5" s="73" t="inlineStr">
<is>
<t>Наименование энергопринимающего устройства (объекта), объекта электросетевого хозяйства, адрес</t>
</is>
</c>
<c r="B5" s="73"/>
<xsl:for-each select="$datacontext//LogicDevice">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<!--№ БС-->
<c r="{$rowletter}5" s="24" t="inlineStr">
<is>
<t>
<xsl:value-of select="./LogicObjectProperties/LOP[@LOP.Code='TP']"/>
</t>
</is>
</c>
</xsl:for-each>
</row>
<row r="6" spans="1:{$s2_maxcol}" s="46" customFormat="1" ht="25.5" x14ac:dyDescent="0.2">
<c r="A6" s="76" t="inlineStr">
<is>
<t>Место установки прибора учета, кВ</t>
</is>
</c>
<c r="B6" s="76"/>
<!--Место установки прибора учета - -->
<xsl:for-each select="$datacontext//LogicDevice">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<c r="{$rowletter}6" s="45" t="inlineStr">
<is>
<t>
<xsl:value-of select="./LogicDeviceProperties/LDP[@LDP.Code='NSK']"/>
</t>
</is>
</c>
</xsl:for-each>
</row>
<row r="7" spans="1:{$s2_maxcol}" ht="38.25" x14ac:dyDescent="0.2">
<c r="A7" s="73" t="inlineStr">
<is>
<t>Тип электросчетчика</t>
</is>
</c>
<c r="B7" s="73"/>
<xsl:for-each select="$datacontext//LogicDevice">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<c r="{$rowletter}7" s="45" t="inlineStr">
<is>
<t>
<xsl:value-of select=".//LogicDeviceProperties/LDP[@LDP.Code='LogicDeviceName']"/>
</t>
</is>
</c>
</xsl:for-each>
</row>
<row r="8" spans="1:{$s2_maxcol}" x14ac:dyDescent="0.2">
<c r="A8" s="73" t="inlineStr">
<is>
<t>Номер электросчетчика</t>
</is>
</c>
<c r="B8" s="73"/>
<xsl:for-each select="$datacontext//LogicDevice">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<c r="{$rowletter}8" s="65" t="inlineStr">
<is>
<t>
<xsl:value-of select=".//LogicDeviceProperties/LDP[@LDP.Code='CountNo']"/>
</t>
</is>
</c>
</xsl:for-each>
</row>
<row r="9" spans="1:{$s2_maxcol}" ht="37.5" customHeight="1" x14ac:dyDescent="0.2">
<c r="A9" s="70" t="inlineStr">
<is>
<t>Показания прибора учета на конец расчетного периода</t>
</is>
</c>
<c r="B9" s="70"/>
<xsl:for-each select="$datacontext//LogicDevice">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<xsl:variable name="endap" select=".//EndAp[1]"/>
<c r="{$rowletter}9" s="24" t="inlineStr">
<v>
<xsl:value-of select="$endap"/>
</v>
</c>
</xsl:for-each>
</row>
<row r="10" spans="1:{$s2_maxcol}" x14ac:dyDescent="0.2">
<c r="A10" s="77" t="inlineStr">
<is>
<t>Сумма</t>
</is>
</c>
<c r="B10" s="77"/>
<xsl:for-each select="$s2_table_title_col_offset + 1 to $s2_maxcol">
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<c r="{$rowletter}10" s="22">
<f>SUM(<xsl:value-of select="$rowletter"/>11:<xsl:value-of select="$rowletter"/>
<xsl:value-of select="$s2_maxrow"/>)</f>
</c>
</xsl:for-each>
</row>
<xsl:for-each select="1 to $days_in_month">
<!--день-->
<xsl:variable name="day_position" select="current()"/>
<xsl:for-each select="1 to 24">
<!--час-->
<xsl:variable name="hour_position" select="current()"/>
<!--строка в документе-->
<xsl:variable name="doc_position" select="24 * ($day_position - 1) + $hour_position + $s2_table_title_row_offset"/>
<row r="{$doc_position}" spans="1:{$s2_maxcol}" x14ac:dyDescent="0.2">
<xsl:choose>
<xsl:when test="$hour_position=1">
<!--вертикальная ячейка с датой-->
<c r="A{$doc_position}" s="74" t="s">
<v>
<xsl:value-of select="$day_position + $s2_sst_day_offset"/>
</v>
</c>
</xsl:when>
<xsl:otherwise>
<c r="A{$doc_position}" s="75"/>
</xsl:otherwise>
</xsl:choose>
<c r="B{$doc_position}" s="7" t="s">
<v>
<xsl:value-of select="$hour_position + $s2_sst_hour_offset"/>
</v>
</c>
<xsl:for-each select="$datacontext//LogicDevice">
<!--точка учёта-->
<xsl:variable name="ld_position" select="position()"/>
<xsl:variable name="rowletter" select="$excelLetters[$ld_position]"/>
<xsl:variable name="ref_position" select="concat($rowletter, fn:string($doc_position - $sh_row_offset_diff))"/>
<c r="{$rowletter}{$doc_position}" s="23" t="str">
<f>IF(HierCubeGrid!<xsl:value-of select="$ref_position"/><>"",HierCubeGrid!<xsl:value-of select="$ref_position"/>,"")</f>
</c>
</xsl:for-each>
</row>
</xsl:for-each>
</xsl:for-each>
<row r="{$s2_emptyrow}" spans="1:72" ht="35.25" customHeight="1" x14ac:dyDescent="0.2">
</row>
<row r="{$s2_fiorow}" spans="1:72" s="27" customFormat="1" ht="44.25" customHeight="1" x14ac:dyDescent="0.2">
<c r="C{$s2_fiorow}" s="80" t="inlineStr">
<!--Наименование компании и должность первого лица - значение -->
<is>
<t>
<xsl:value-of select="((//LogicDeviceProperties/LDP[@LDP.Code = 'NameCompany'])[1])"/>
</t>
</is>
</c>
<c r="D{$s2_fiorow}" s="80"/>
<c r="E{$s2_fiorow}" s="80">
</c>
<c r="F{$s2_fiorow}" s="79" t="s">
<!--черта-->
<v>28</v>
</c>
<c r="G{$s2_fiorow}" s="79"/>
<c r="H{$s2_fiorow}" s="79"/>
<c r="I{$s2_fiorow}" s="80" t="inlineStr">
<is>
<t>
<xsl:value-of select="((//LogicDeviceProperties/LDP[@LDP.Code = 'NameFirstPerson'])[1])"/>
</t>
</is>
</c>
<c r="J{$s2_fiorow}" s="80"/>
<c r="K{$s2_fiorow}" s="80"/>
<c r="L{$s2_fiorow}" s="41"/>
<c r="M{$s2_fiorow}" s="80" t="inlineStr">
<f>C<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="N{$s2_fiorow}" s="80"/>
<c r="O{$s2_fiorow}" s="42"/>
<c r="P{$s2_fiorow}" s="79" t="s">
<v>28</v>
</c>
<c r="Q{$s2_fiorow}" s="79"/>
<c r="R{$s2_fiorow}" s="80" t="inlineStr">
<f>I<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="S{$s2_fiorow}" s="80"/>
<c r="T{$s2_fiorow}" s="44"/>
<c r="U{$s2_fiorow}" s="42"/>
<c r="V{$s2_fiorow}" s="42"/>
<c r="W{$s2_fiorow}" s="82" t="inlineStr">
<f>M<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="X{$s2_fiorow}" s="82"/>
<c r="Y{$s2_fiorow}" s="82"/>
<c r="Z{$s2_fiorow}" s="82"/>
<c r="AA{$s2_fiorow}" s="79" t="s">
<v>28</v>
</c>
<c r="AB{$s2_fiorow}" s="79"/>
<c r="AC{$s2_fiorow}" s="79"/>
<c r="AD{$s2_fiorow}" s="82" t="inlineStr">
<f>R<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="AE{$s2_fiorow}" s="82"/>
<c r="AF{$s2_fiorow}" s="82"/>
<c r="AG{$s2_fiorow}" s="82" t="inlineStr">
<f>W<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="AH{$s2_fiorow}" s="82"/>
<c r="AI{$s2_fiorow}" s="82"/>
<c r="AJ{$s2_fiorow}" s="82"/>
<c r="AK{$s2_fiorow}" s="79" t="s">
<v>28</v>
</c>
<c r="AL{$s2_fiorow}" s="79"/>
<c r="AM{$s2_fiorow}" s="79"/>
<c r="AN{$s2_fiorow}" s="82" t="inlineStr">
<f>AD<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="AO{$s2_fiorow}" s="82"/>
<c r="AP{$s2_fiorow}" s="82"/>
<c r="AQ{$s2_fiorow}" s="82" t="inlineStr">
<f>AG<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="AR{$s2_fiorow}" s="82"/>
<c r="AS{$s2_fiorow}" s="82"/>
<c r="AT{$s2_fiorow}" s="82"/>
<c r="AU{$s2_fiorow}" s="79" t="s">
<v>28</v>
</c>
<c r="AV{$s2_fiorow}" s="79"/>
<c r="AW{$s2_fiorow}" s="79"/>
<c r="AX{$s2_fiorow}" s="82" t="inlineStr">
<f>AN<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="AY{$s2_fiorow}" s="82"/>
<c r="AZ{$s2_fiorow}" s="82"/>
<c r="BA{$s2_fiorow}" s="82" t="inlineStr">
<f>AQ<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="BB{$s2_fiorow}" s="82"/>
<c r="BC{$s2_fiorow}" s="82"/>
<c r="BD{$s2_fiorow}" s="82"/>
<c r="BE{$s2_fiorow}" s="79" t="s">
<v>28</v>
</c>
<c r="BF{$s2_fiorow}" s="79"/>
<c r="BG{$s2_fiorow}" s="79"/>
<c r="BH{$s2_fiorow}" s="82" t="inlineStr">
<f>AX<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="BI{$s2_fiorow}" s="82"/>
<c r="BJ{$s2_fiorow}" s="82"/>
<c r="BK{$s2_fiorow}" s="82" t="inlineStr">
<f>BA<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="BL{$s2_fiorow}" s="82"/>
<c r="BM{$s2_fiorow}" s="82"/>
<c r="BN{$s2_fiorow}" s="82"/>
<c r="BO{$s2_fiorow}" s="79" t="s">
<v>28</v>
</c>
<c r="BP{$s2_fiorow}" s="79"/>
<c r="BQ{$s2_fiorow}" s="79"/>
<c r="BR{$s2_fiorow}" s="82" t="inlineStr">
<f>BH<xsl:value-of select="$s2_fiorow"/>
</f>
</c>
<c r="BS{$s2_fiorow}" s="82"/>
<c r="BT{$s2_fiorow}" s="82"/>
</row>
<row r="757" spans="1:72" x14ac:dyDescent="0.2">
<c r="B757" s="36"/>
<c r="C757" s="78" t="s">
<v>27</v>
</c>
<c r="D757" s="78"/>
<c r="E757" s="78"/>
<c r="G757" s="28" t="s">
<v>29</v>
</c>
<c r="I757" s="78" t="s">
<v>30</v>
</c>
<c r="J757" s="78"/>
<c r="K757" s="78"/>
<c r="L757" s="28"/>
<c r="M757" s="81" t="s">
<v>27</v>
</c>
<c r="N757" s="81"/>
<c r="O757" s="43"/>
<c r="P757" s="81" t="s">
<v>29</v>
</c>
<c r="Q757" s="81"/>
<c r="R757" s="81" t="s">
<v>30</v>
</c>
<c r="S757" s="81"/>
<c r="U757" s="43"/>
<c r="V757" s="43"/>
<c r="W757" s="81" t="s">
<v>27</v>
</c>
<c r="X757" s="81"/>
<c r="Y757" s="81"/>
<c r="Z757" s="81"/>
<c r="AA757" s="34"/>
<c r="AB757" s="35" t="s">
<v>29</v>
</c>
<c r="AC757" s="61"/>
<c r="AD757" s="81" t="s">
<v>30</v>
</c>
<c r="AE757" s="81"/>
<c r="AF757" s="81"/>
<c r="AG757" s="81" t="s">
<v>27</v>
</c>
<c r="AH757" s="81"/>
<c r="AI757" s="81"/>
<c r="AJ757" s="81"/>
<c r="AK757" s="34"/>
<c r="AL757" s="35" t="s">
<v>29</v>
</c>
<c r="AM757" s="34"/>
<c r="AN757" s="81" t="s">
<v>30</v>
</c>
<c r="AO757" s="81"/>
<c r="AP757" s="81"/>
<c r="AQ757" s="81" t="s">
<v>27</v>
</c>
<c r="AR757" s="81"/>
<c r="AS757" s="81"/>
<c r="AT757" s="81"/>
<c r="AU757" s="34"/>
<c r="AV757" s="35" t="s">
<v>29</v>
</c>
<c r="AW757" s="34"/>
<c r="AX757" s="81" t="s">
<v>30</v>
</c>
<c r="AY757" s="81"/>
<c r="AZ757" s="81"/>
<c r="BA757" s="81" t="s">
<v>27</v>
</c>
<c r="BB757" s="81"/>
<c r="BC757" s="81"/>
<c r="BD757" s="81"/>
<c r="BE757" s="34"/>
<c r="BF757" s="35" t="s">
<v>29</v>
</c>
<c r="BG757" s="34"/>
<c r="BH757" s="81" t="s">
<v>30</v>
</c>
<c r="BI757" s="81"/>
<c r="BJ757" s="81"/>
<c r="BK757" s="81" t="s">
<v>27</v>
</c>
<c r="BL757" s="81"/>
<c r="BM757" s="81"/>
<c r="BN757" s="81"/>
<c r="BO757" s="34"/>
<c r="BP757" s="35" t="s">
<v>29</v>
</c>
<c r="BQ757" s="34"/>
<c r="BR757" s="81" t="s">
<v>30</v>
</c>
<c r="BS757" s="81"/>
<c r="BT757" s="81"/>
</row>
</sheetData>
<sheetProtection sheet="1" formatCells="0" formatColumns="0" formatRows="0" insertColumns="0" insertRows="0" insertHyperlinks="0" deleteColumns="0" deleteRows="0" sort="0" autoFilter="0" pivotTables="0"/>
<mergeCells>
<mergeCell ref="BA757:BD757"/>
<mergeCell ref="BR{$s2_fiorow}:BT{$s2_fiorow}"/>
<mergeCell ref="BK757:BN757"/>
<mergeCell ref="BR757:BT757"/>
<mergeCell ref="BO{$s2_fiorow}:BQ{$s2_fiorow}"/>
<mergeCell ref="BH757:BJ757"/>
<mergeCell ref="BA{$s2_fiorow}:BD{$s2_fiorow}"/>
<mergeCell ref="BK{$s2_fiorow}:BN{$s2_fiorow}"/>
<mergeCell ref="BH{$s2_fiorow}:BJ{$s2_fiorow}"/>
<mergeCell ref="BE{$s2_fiorow}:BG{$s2_fiorow}"/>
<mergeCell ref="AK{$s2_fiorow}:AM{$s2_fiorow}"/>
<mergeCell ref="AU{$s2_fiorow}:AW{$s2_fiorow}"/>
<mergeCell ref="AQ{$s2_fiorow}:AT{$s2_fiorow}"/>
<mergeCell ref="AX757:AZ757"/>
<mergeCell ref="AX{$s2_fiorow}:AZ{$s2_fiorow}"/>
<mergeCell ref="AD757:AF757"/>
<mergeCell ref="AN757:AP757"/>
<mergeCell ref="AQ757:AT757"/>
<mergeCell ref="AG757:AJ757"/>
<mergeCell ref="W757:Z757"/>
<mergeCell ref="A683:A706"/>
<mergeCell ref="AG{$s2_fiorow}:AJ{$s2_fiorow}"/>
<mergeCell ref="AN{$s2_fiorow}:AP{$s2_fiorow}"/>
<mergeCell ref="AA{$s2_fiorow}:AC{$s2_fiorow}"/>
<mergeCell ref="C{$s2_fiorow}:E{$s2_fiorow}"/>
<mergeCell ref="M{$s2_fiorow}:N{$s2_fiorow}"/>
<mergeCell ref="W{$s2_fiorow}:Z{$s2_fiorow}"/>
<mergeCell ref="AD{$s2_fiorow}:AF{$s2_fiorow}"/>
<mergeCell ref="R757:S757"/>
<mergeCell ref="C757:E757"/>
<mergeCell ref="F{$s2_fiorow}:H{$s2_fiorow}"/>
<mergeCell ref="R{$s2_fiorow}:S{$s2_fiorow}"/>
<mergeCell ref="I{$s2_fiorow}:K{$s2_fiorow}"/>
<mergeCell ref="M757:N757"/>
<mergeCell ref="P{$s2_fiorow}:Q{$s2_fiorow}"/>
<mergeCell ref="P757:Q757"/>
<mergeCell ref="I757:K757"/>
<mergeCell ref="A731:A754"/>
<mergeCell ref="A299:A322"/>
<mergeCell ref="A467:A490"/>
<mergeCell ref="A539:A562"/>
<mergeCell ref="A563:A586"/>
<mergeCell ref="A635:A658"/>
<mergeCell ref="A587:A610"/>
<mergeCell ref="A611:A634"/>
<mergeCell ref="A707:A730"/>
<mergeCell ref="A659:A682"/>
<mergeCell ref="A107:A130"/>
<mergeCell ref="A515:A538"/>
<mergeCell ref="A251:A274"/>
<mergeCell ref="A275:A298"/>
<mergeCell ref="A203:A226"/>
<mergeCell ref="A227:A250"/>
<mergeCell ref="A491:A514"/>
<mergeCell ref="A179:A202"/>
<mergeCell ref="A3:B3"/>
<mergeCell ref="A11:A34"/>
<mergeCell ref="A35:A58"/>
<mergeCell ref="A59:A82"/>
<mergeCell ref="A5:B5"/>
<mergeCell ref="A4:B4"/>
<mergeCell ref="A6:B6"/>
<mergeCell ref="A10:B10"/>
<mergeCell ref="A7:B7"/>
<mergeCell ref="A8:B8"/>
<mergeCell ref="A9:B9"/>
<mergeCell ref="A443:A466"/>
<mergeCell ref="A347:A370"/>
<mergeCell ref="A419:A442"/>
<mergeCell ref="A155:A178"/>
<mergeCell ref="A131:A154"/>
<mergeCell ref="A83:A106"/>
<mergeCell ref="A323:A346"/>
<mergeCell ref="A371:A394"/>
<mergeCell ref="A395:A418"/>
</mergeCells>
<pageMargins left="0.11811023622047245" right="0.11811023622047245" top="0.55118110236220474" bottom="0.78740157480314965" header="0.31496062992125984" footer="0.11811023622047245"/>
<pageSetup paperSize="9" scale="70" fitToHeight="0" orientation="portrait" r:id="rId1"/>
<headerFooter>
<oddHeader>&C&"Arial,полужирный"Акт снятия показаний и почасового расхода электрической энергии коммерческих приборов учета.&R&8страница &P из &N</oddHeader>
<oddFooter xml:space="preserve">&LПредставитель сетевой компании:
______________________________________________
______________________________________________&RПредставитель потребителя:
<xsl:value-of select="((//LogicDeviceProperties/LDP[@LDP.Code = 'ConsumerRepresentative'])[1])"/>
</oddFooter>
</headerFooter>
</worksheet>
</xsl:result-document>
</xsl:template>
</xsl:stylesheet>