Всем привет народ! Есть код котороый создает SPREADSHEET с 2 листами, вопрос следующий:
как добавить данные во 2 лист?
пробовал ссылаться на 2 лист так x:worksheet="b2" не катит
<table x:str border=0 cellpadding=0 cellspacing=0 width=1037
style='border-collapse:collapse;table-layout:fixed;width:781pt' x:worksheet="b2">
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.
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 10">
<link rel=File-List href="alex_9.files/filelist.xml">
<link rel=Edit-Time-Data href="alex_9.files/editdata.mso">
<link rel=OLE-Object-Data href="alex_9.files/oledata.mso">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:LastAuthor>alex</o:LastAuthor>
<o:Created> 2004 - 08 -06T12: 01 :24Z</o:Created>
<o:LastSaved> 2004 - 08 -06T12: 04 :48Z</o:LastSaved>
<o:Version> 10 . 4219 </o:Version>
</o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\,";
mso-displayed-thousand-separator:" ";}
@page
{margin:.98in .79in .98in .79in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate: 0 ;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size: 10 .0pt;
font-weight: 400 ;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset: 204 ;
border:none;
mso-protection:locked visible;
mso-style-name:Обычный;
mso-style-id: 0 ;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size: 10 .0pt;
font-weight: 400 ;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset: 204 ;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate: 0 ;}
.xRED
{mso-style-parent:style0;
color:RED;}
.xl24
{mso-style-parent:style0;
mso-number-format:"dd\/mm\/yy\;\@";}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>b1</x:Name>
<x:WorksheetOptions>
<x:ActiveSheet> 0 </x:ActiveSheet>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>b2</x:Name>
<x:WorksheetOptions>
<x:ActiveSheet> 0 </x:ActiveSheet>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight> 9345 </x:WindowHeight>
<x:WindowWidth> 15180 </x:WindowWidth>
<x:WindowTopX> 120 </x:WindowTopX>
<x:WindowTopY> 45 </x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple>
<table x:str border= 0 cellpadding= 0 cellspacing= 0 width= 1037
style='border-collapse:collapse;table-layout:fixed;width:781pt' x:worksheet="b2">
<col width= 426 style='mso-width-source:userset;mso-width-alt:15550;width:321pt'>
<col width= 12 style='mso-width-source:userset;mso-width-alt:436;width:9pt'>
<col width= 12 style='mso-width-source:userset;mso-width-alt:436;width:9pt'>
<col width= 145 style='mso-width-source:userset;mso-width-alt:5303;width:109pt'>
<col width= 285 style='mso-width-source:userset;mso-width-alt:10427;width:215pt'>
<col width= 12 style='mso-width-source:userset;mso-width-alt:436;width:9pt'>
<col width= 145 style='mso-width-source:userset;mso-width-alt:5303;width:109pt'>
<TR HEIGHT= 17 STYLE='HEIGHT:12.75PT'>
<td height= 17 colspan= 1 width= 145 style='height:12,75pt;width:109pt;color:blue;font-weight:700;border:.5pt solid windowtext;vertical-align:middle;white-space:normal;background:#FFFF99;mso-pattern:auto none;'>Привет мир</td>
<td height= 17 colspan= 1 width= 145 style='height:12,75pt;width:109pt;'></td>
<td height= 17 colspan= 1 width= 145 style='height:12,75pt;width:109pt;'></td>
<td height= 17 colspan= 1 width= 145 style='height:12,75pt;width:109pt;'></td>
<td height= 17 colspan= 1 width= 145 style='height:12,75pt;width:109pt;'></td>
<td height= 17 colspan= 1 width= 145 style='height:12,75pt;width:109pt;'></td>
<td height= 17 colspan= 1 width= 145 style='height:12,75pt;width:109pt;'></td>
</tr>
Заранее большое спасибо!
