I've got a spreadsheet with the contents of a config file with a little over 500 rows and columns A-J. Each new row has all the attributes(settings) that are needed for 1 computer's config file. I've successfully mapped row 2 (row 1 is my headers) and exported it to an .xml file. Works great! But, I need to make a .xml for each row in my spreadsheet. Is this possible? I keep having to delete my xml maps and remap for every row, then export and that is not very efficient. I don't want all 500 rows in a single .xml file, I need one for each row. I've been reading much of the afternoon to see if it's possible with no luck. I have attached my Excel sheet with the output (that is correct in every way, and only for row 2). It would be even better if Excel could auto-name the .xml files based on what ComputerName they're for. Can anyone 'show me the way', as I may be doing this several times with other information as well. Thank you for any help you could lend.....
Bookmarks