Seeking any guidance or thoughts on achieving a generic parser from Excel (.xls) to XML that could be globally used within our environment.
The notion is the Excel worksheet (single sheet can be a limitation) is used as input. The header row (row 1) is read and used to construct the tags, then the remaining data is processed into the target as XML using the tags from the header to encapsulate the data.
Thanks in advance