[Home] [By Thread] [By Date] [Recent Entries]
Hello, I'm hoping that someone can point me in the right direction. I have the following need: I have been sent an MS Excel file that I have been asked to transform in the following way... <Table> <Row> <Cell><Data>Level 1</Data></Cell> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> </Row> <Row> <Cell/> <Cell><Data>Level 2</Data></Cell> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> <Cell/> </Row> ..+5000 Rows </Table To a nested structure which is based on the position of the <Data> tag.
..etc </Level> </Table> The nesting goes both up and down levels so I'm assuming recusion is the way to go but the level of existing nesting has me wracking my brains (when you don't do much of this it is a daunting task...). Thanks in advance, Luke.
|

Cart



