Всем привет народ! Есть код котороый создает 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"> | Код | <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>
|
Заранее большое спасибо!
|