I would like to find some statistic of data from multiple XML files using Excel 2007. I want to import all the files in a folder and sub- folder into one EXCEL spreadsheet. Each XML file has the identical structure, but different data. I want to define the XML map in Excel, and import data for each file, with each file's data being on a new row. By the way, it seems that excel does not allow to import many files at once.
Bookmarks