Click to See Complete Forum and Search --> : Reading xml file


rdeep
April 28th, 2005, 12:25 PM
How can i extract data from a node from all the files in a directory and store it in an excel sheet. I want to use .net language to do so.

I know how to load one xml document and using select single node to find the node and extract data from it. But how can i do it for all the files in that directory?
Also, i need to open an excel file , create 2 columns headers in excel sheet and store the values in them.???
thanks

g_gili
April 28th, 2005, 01:48 PM
You can try to add an activex control(exel) and to put you data in those colums.
Try to search in the forum how can put data in you exel activex control.

cilu
April 29th, 2005, 12:00 PM
See this article (http://www.codeguru.com/Csharp/.NET/cpp_managed/windowsservices/article.php/c9665/) about using DirectoryInfo and FileInfo to search a directory for files.