Bulk conversion of XML files to Excel

Two questions...

First, is there a way to search unopened XML files for specific data?

Second - We have software which allows for HIPAA archiving to XML files.  One file is created for each day.  Is there a way to convert more than one of these XML documents (a batch of them) at a time to Excel?  Names of the files could remain the same once converted to Excel.  We have a very large volume to convert.
klitton7Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gertone (Geert Bormans)Information ArchitectCommented:
Any XPath aware tool could do that for you.
I usually use XQuery from an XML IDE such as Oxygen (www.oxygenxml.com) to browse a set of XML files for information
I often use commandline XSLT (using Saxon from saxonica) to generate html reports from a series of XML files

I very often need to make excel reports from series of XML dumps
My prefered way is to run an XSLT process in batch on each file, creating Spreadsheet XML with xls extension,
it opens as if it is a genuine excel file

Answers to both questions imply some XSLT or XQuery background, we can help you with that

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
klitton7Author Commented:
Geert.  Your answers are encouraging - Thanks for your response.  I have no XSLT or XQuery background.  I am interested in the help you are offering.  What do you have in mind?
Gertone (Geert Bormans)Information ArchitectCommented:
Let 's start with the bulk process

If you send an example XML report and the info you would like to see in the excel, I will do a quick transform and explain to you how to set it up
klitton7Author Commented:
These XML files contain sensitive information..  ss#s, etc.,  I was going to try to replace with 0's, but can't see how to do that before sending to you. Any ideas?
Gertone (Geert Bormans)Information ArchitectCommented:
I think there is a trusted place for files.
But if you dont trust it that far, you can email me an example file (see profile for email)
I will sign an nda if you need that, but you can assume i dont share your data, dont look at the details and delete as soon as task is done. Will,post the solution here for future reference and being in line with ee policy
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
XML

From novice to tech pro — start learning today.