XML-Excel

[skydive]

Hi,

I am new to XMl so excuse me if this is a stupid question.

I am creating a web based timesheet system where users can download their timesheet in XML format so they can edit it offline in MS-Excel. The user will then be able to upload the XML file and the system will update the database accordingly by looping through the nodes and checking the DBKEY which is the primary key for the individual entries.

Below is a few lines of XML that my program creates. Here is the problem, the user (in this example) was on holidays so the user should enter 8 hours into each cell. Rather than doing this manually the user enters 8 hours into the first cell and copies and pastes this cell into the others. The problem with this is that the DBKEY also gets copied.

Has anyone any ideas about how to do this?

<Row>
<Cell>
<Data ss:Type=&quot;String&quot;>800</Data>
</Cell>
<Cell>
<Data ss:Type=&quot;String&quot;>Holiday</Data>
</Cell>
<Cell ss:StyleID=&quot;s26&quot;>
<Data ss:Type=&quot;Number&quot; DBKEY=&quot;355242&quot;>0</Data>
</Cell>
<Cell ss:StyleID=&quot;s26&quot;>
<Data ss:Type=&quot;Number&quot; DBKEY=&quot;355243&quot;>0</Data>
</Cell>
<Cell ss:StyleID=&quot;s27&quot;>
<Data ss:Type=&quot;Number&quot; DBKEY=&quot;355244&quot;>0</Data>
...etc...


Thanks
Skydive! Blue Skies! Soft Landings!!

 

[skydive]

I solved it (in case anyone has a similar problem)
I created a new worksheet in the same workbook and created it in exactly the same manner as the first worksheet (except that it is hidden). This 2nd worksheet contains the database codes so I loop through both list of nodes at the same time.
Not perfect but it works. Blue Skies! Soft Landings!!