X
xargon
Hi everyone,
I have a question about the HTML/XML format of Excel 2000 when you sav
a workbook as a web page.
I have a requirement where I generate the HTML/XML structur
programatically and save it in seperate files (one .htm file for eac
worksheet). Everything works fine. However, I was trying to cra
everything in one single file and experimenting with various options.
For example, I have the following xml structure that creates the tw
sheets.
Code
-------------------
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>9210</x:WindowHeight>
<x:WindowWidth>15195</x:WindowWidth>
<x:WindowTopX>0</x:WindowTopX>
<x:WindowTopY>60</x:WindowTopY>
<xrotectStructure>False</xrotectStructure>
<xrotectWindows>False</xrotectWindows>
</x:ExcelWorkbook>
</xml>
-------------------
Now, I wanna insert data into these tables. However, I run into troubl
as it always adds data to the first sheet. Is there a tag that wil
tell which sheet the table belonds to.
Example,
Code
-------------------
<table x:str border=0 cellpadding=0 cellspacing=0 width=64 style='border-collapse:
collapse;table-layout:fixed;width:48pt'>
<col width=64 style='width:48pt'>
<tr height=17 style='height:12.75pt'>
<td height=17 width=64 style='height:12.75pt;width:48pt'>ddd</td>
</tr>
</table>
-------------------
How to tell this table that it belongs to Sheet 2
Anyone, has any ideas about this? I would really appreciate some help.
Sincerely,
Panka
I have a question about the HTML/XML format of Excel 2000 when you sav
a workbook as a web page.
I have a requirement where I generate the HTML/XML structur
programatically and save it in seperate files (one .htm file for eac
worksheet). Everything works fine. However, I was trying to cra
everything in one single file and experimenting with various options.
For example, I have the following xml structure that creates the tw
sheets.
Code
-------------------
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>9210</x:WindowHeight>
<x:WindowWidth>15195</x:WindowWidth>
<x:WindowTopX>0</x:WindowTopX>
<x:WindowTopY>60</x:WindowTopY>
<xrotectStructure>False</xrotectStructure>
<xrotectWindows>False</xrotectWindows>
</x:ExcelWorkbook>
</xml>
-------------------
Now, I wanna insert data into these tables. However, I run into troubl
as it always adds data to the first sheet. Is there a tag that wil
tell which sheet the table belonds to.
Example,
Code
-------------------
<table x:str border=0 cellpadding=0 cellspacing=0 width=64 style='border-collapse:
collapse;table-layout:fixed;width:48pt'>
<col width=64 style='width:48pt'>
<tr height=17 style='height:12.75pt'>
<td height=17 width=64 style='height:12.75pt;width:48pt'>ddd</td>
</tr>
</table>
-------------------
How to tell this table that it belongs to Sheet 2
Anyone, has any ideas about this? I would really appreciate some help.
Sincerely,
Panka