XMLSS href attribute

P

Pete Hodgson

Hi,

First off, I'm not sure which is the right newgroup to post XMLSS
questions to. If anyone has any feedback on that, I'd appreciate it.

Now, my question. I'm looking at exporting data as an Excel spreadsheet,
using the XMLSS format. To dip my toe in the water I created an excel
workbook that contains a sample of how I want the exported data to look,
then saved it as XML to see what kind of output I should be generating.

The resulting XML looks fairly painless, but I'm now wondering what
different formats are available for the ss:HRef attribute. I need my
output to contain cross-worksheet hyperlinks, and the XMLSS that Excel
generates look something like this:

<-----------SNIP---------------->
....
....
<Cell ss:StyleID="s20" ss:HRef="#Trajectory_Data_1!A611:D811"
x:HRefScreenTip="Trajectory 3"><Data ss:Type="String">Trajectory
3</Data></Cell>
....
....
<-----------SNIP---------------->

so it seems that Excel uses a format of
#SheetName!TopLeftCell:BottomRightCell

Can anyone tell me if there are any alternate ways to specify the
hyperlink target. Specifically, I'd prefer not to hardcode cell
locations into my XML, since that would involve manually calculating the
locations (since my output is XML I'm not actually specifying cell
locations for the section of the sheet that I want to link to).

Is there a way of assigning an ID to a table, and then specifying that
table as the target of the hyperlink in the HRef attribute? For example:

<-----------SNIP---------------->
....
....
<Worksheet ss:Name="Index">
...
<Table ...>
<Row ...>
<Cell ss:Href="#Data!trajectory1" ...>
...
</Cell>
</Row>
...
</Table>
</Worksheet>
....
....
<Worksheet ss:Name="Data">
...
<Table ss:ID="trajectory1" ...>
...
</Table>
...
</Worksheet>
....
....
<-----------SNIP---------------->

I hope that gives an idea of what I'm thinking of. Am I making any sense
at all? ;)

TIA,

Pete Hodgson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top