Hi David,
It sounds like you're trying to map repeating rows in Excel using XML. Here's a step-by-step guide to help you out:
- Open your Excel file and make sure you have the [Developer] tab visible. If not, go to [File] [Options] [Customize Ribbon] and check the box next to [Developer].
- Click on the [Developer] tab and select [XML Source] from the [XML] group.
- In the [XML Source] pane, click on [XML Maps] and then [Add].
- Browse to your XML file and select it. Excel will display a list of elements in the XML file.
- Select the element you want to map and click on [OK].
- Excel will ask you where you want to map the XML element. Click and drag a range of contiguous cells to map the element to.
- Click on [OK] to close the [Map XML Elements] dialog box.
- Excel will display a blue border around the first row of the mapped range. To map the remaining rows, click on the [Repeat] button in the [XML Tools] group on the [Developer] tab.
- Excel will display a dialog box asking you how many rows you want to repeat. Enter the number of rows you want to repeat and click on [OK].
- Excel will now display the blue border around all the rows you've mapped.
- Save your Excel file and export it to XML.
That should do it! Let me know if you have any questions or if there's anything else I can help you with.
Best regards,
[Your Name]