StampIT
asked on
asked on Import XML file into Excel
Attached is a XML file and an Excel spreadsheet after I have imported this XML into it. Is it possible to rearrange the resulting spreadsheet so that the columns are Session#, SourceHost, SourcePath, StartTime, etc with the corressponding values listed by session #? Can this be done via the XML import process into Excel Or is VBA code necessary? Either way I would appreciate assistance. The current format is not manageable. Thanks.
BackUpJob1349.xml
Book3.xlsx
BackUpJob1349.xml
Book3.xlsx
Visual Basic ClassicMicrosoft Excel
Last Comment
StampIT
Bruce Cadiz
StampIT,
Here's a different approach by replacing your XML tags with HTML then opening in Excel.
Note: It will open the XML file and replace listed text string / tags with HTML tags then open in Excel. Seemed like the simplest approach since your XML was similarly structured to an HTML table.
Bruce ee-Q26615394.xls
Here's a different approach by replacing your XML tags with HTML then opening in Excel.
Note: It will open the XML file and replace listed text string / tags with HTML tags then open in Excel. Seemed like the simplest approach since your XML was similarly structured to an HTML table.
Bruce ee-Q26615394.xls
ASKER
StampIT
Thanks for the replies. Both of these are way over my head. I thought there might be a simpler way of performing this task.
Bruce: I ran your code with the file I had but it resulted in data in the first row in a language I did not understand. I probably did something wrong.
If I can I should probably withdraw the question.
Bruce: I ran your code with the file I had but it resulted in data in the first row in a language I did not understand. I probably did something wrong.
If I can I should probably withdraw the question.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
gbanik
StampIT as I mentioned in my comment, there might not be a simpler way. But actually less difficult than u are thinking. This method is a tried and tested way and u can definitely give it a try.
I am confident about the direction.
I am confident about the direction.
Bruce Cadiz
StampIT,
Here is your sample XML file and I've modified the Excel file to save the output in the same directory. It should do exactly what you have asked.
Save them to a folder that you have read/write access to. Then open the Excel file and hit the button to Select the XML File. You are running Windows aren't you? What version of Excel do you have?
Bruce ee-Example.zip
Here is your sample XML file and I've modified the Excel file to save the output in the same directory. It should do exactly what you have asked.
Save them to a folder that you have read/write access to. Then open the Excel file and hit the button to Select the XML File. You are running Windows aren't you? What version of Excel do you have?
Bruce ee-Example.zip
ASKER
StampIT
Bruce,
I am running Windows Vista and Excel 2007. Thanks
I am running Windows Vista and Excel 2007. Thanks
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
StampIT
Works exactly how I want it to.
Bruce Cadiz
StampIT,
Thanks. I believe the suggestions by gbanik regarding the XML parser is something you should look at. While as he stated it may seem complicated, if you were to eventually incorporate it, you would have more functionality / flexibility in the long run, especially if your XML data structures change in the future.
Bruce
Thanks. I believe the suggestions by gbanik regarding the XML parser is something you should look at. While as he stated it may seem complicated, if you were to eventually incorporate it, you would have more functionality / flexibility in the long run, especially if your XML data structures change in the future.
Bruce
ASKER
StampIT
Bruce,
Thanks. I will keep that in mind.
Thanks. I will keep that in mind.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Add it as reference in your project
http://msdn.microsoft.com/en-us/library/ms763701(VS.85).aspx
Check this to parse your data
http://msdn.microsoft.com/en-us/library/aa163921(office.10).aspx