X
xargon
I am working on generating the HTML/XML format of Office 2000 by hand
Everything works fine. However, there is one nagging problem that I a
still not able to solve.
Excel 2000 stores the data in multiple HTML file for every sheet in th
workbook. What I am trying to do is to store all the data in one HTM
file. I tried setting anchors to specific points in the HTMl file
However, it renders everything in the same first sheet.
For example,
Code
-------------------
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetSource a HRef="#here"/>
<x:WorksheetOptions>
<x:Selected/>
<xanes>
<xane>
<x:Number>3</x:Number>
<x:ActiveRow>15</x:ActiveRow>
<x:ActiveCol>7</x:ActiveCol>
</xane>
</xanes>
<xrotectContents>False</xrotectContents>
<xrotectObjects>False</xrotectObjects>
<xrotectScenarios>False</xrotectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetSource a HRef="#there"/>
<x:WorksheetOptions>
<xrotectContents>False</xrotectContents>
<xrotectObjects>False</xrotectObjects>
<xrotectScenarios>False</xrotectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
</x:ExcelWorkbook>
</xml>
and then I have say,
<body link=blue vlink=purple>
<a name = "here" id = "here">
<table....></table></a>
and similarly,
<a name = "here" id = "there">
<table....></table></a>
</body>...
-------------------
However, this does not work. Excel renders everything (contents of bot
anchor tags) on the first sheet. Is there any way to tell excel t
render different sheets based on different anchor tags in the same HTM
document.
Thanks for any help you might give me.
Sincerely,
Xargo
Everything works fine. However, there is one nagging problem that I a
still not able to solve.
Excel 2000 stores the data in multiple HTML file for every sheet in th
workbook. What I am trying to do is to store all the data in one HTM
file. I tried setting anchors to specific points in the HTMl file
However, it renders everything in the same first sheet.
For example,
Code
-------------------
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetSource a HRef="#here"/>
<x:WorksheetOptions>
<x:Selected/>
<xanes>
<xane>
<x:Number>3</x:Number>
<x:ActiveRow>15</x:ActiveRow>
<x:ActiveCol>7</x:ActiveCol>
</xane>
</xanes>
<xrotectContents>False</xrotectContents>
<xrotectObjects>False</xrotectObjects>
<xrotectScenarios>False</xrotectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetSource a HRef="#there"/>
<x:WorksheetOptions>
<xrotectContents>False</xrotectContents>
<xrotectObjects>False</xrotectObjects>
<xrotectScenarios>False</xrotectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
</x:ExcelWorkbook>
</xml>
and then I have say,
<body link=blue vlink=purple>
<a name = "here" id = "here">
<table....></table></a>
and similarly,
<a name = "here" id = "there">
<table....></table></a>
</body>...
-------------------
However, this does not work. Excel renders everything (contents of bot
anchor tags) on the first sheet. Is there any way to tell excel t
render different sheets based on different anchor tags in the same HTM
document.
Thanks for any help you might give me.
Sincerely,
Xargo