.xml files combined into excell rows and back again.

Dpalkon

New Member
Joined
Dec 4, 2019
Messages
9
Office Version
  1. 365
Platform
  1. Windows
Man you saved me so much time in the past converting .txt files into a single excel sheet I was hoping you could help me again. I have machine recipe's that are in .xml format that I'd like to get only portions of the .xml file put into excel so I can modify it and then take the modified data and re make the .xml file in the same format as the original. below I have copied 1 of over a thousand actual recipe's that I would love to get into excel and then after making changes to the data re make the .xml file the same way. so using below as the data that I need to convert I have shown below that the way I would want the data to appear in 1 row of excell data.


THIS IS THE .XML FILE DATA. THE NAME OF THE FILE WILL NEED TO BE THE FIRST COLUMN IN THE ROW OF EXCELL DATA
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="recipe.xsl"?>
<TAGLIST>
<TAG>
<NAME>hmi_Spin_at_Dip</NAME>
<VALUE>1</VALUE>
</TAG>
<TAG>
<NAME>hmi_Hopper_Lower</NAME>
<VALUE>1</VALUE>
</TAG>
<TAG>
<NAME>hmi_Double_Cycle</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Double_Dip</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Numb_Dump</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Batch_Weight</NAME>
<VALUE>150</VALUE>
</TAG>
<TAG>
<NAME>hmi_Dip_Speed</NAME>
<VALUE>10</VALUE>
</TAG>
<TAG>
<NAME>hmi_Spin_Speed</NAME>
<VALUE>400</VALUE>
</TAG>
<TAG>
<NAME>hmi_Dip_Time</NAME>
<VALUE>10</VALUE>
</TAG>
<TAG>
<NAME>hmi_Spin_Time</NAME>
<VALUE>30</VALUE>
</TAG>
<TAG>
<NAME>hmi_Number_of_Spins</NAME>
<VALUE>3</VALUE>
</TAG>
<TAG>
<NAME>hmi_InVibe_Speed</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Conveyor_Speed</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Customer_Name</NAME>
<VALUE>INFASTECH</VALUE>
</TAG>
<TAG>
<NAME>hmi_Part_Description</NAME>
<VALUE>M8</VALUE>
</TAG>
<TAG>
<NAME>Recipe_Top_Coat_Type</NAME>
<VALUE>TNT-12</VALUE>
</TAG>
</TAGLIST>



AN EXAMPLE OF HOW THIS RECIPE ABOVE WOULD BE PUT INTO EXCELL WOULD BE BELOW: THE FILE NAME IN COLUMN A THEN THE DATA BETWEEN <VALUE> ????</VALUE> IN COLUMNS AFTER THAT. THEN i WOULD NEED TO CHANGE SOME OF THE DATA A RE-CREATE ALL THE NEW XML FILES USING THE DATA FROM EACH ROW IN THE EXCELL FILE. DOES THIS MAKE SENSE?

FILENAME , 1,1,0,0,0,150,10,400,10,30,3,0,0,INFASTECH,M8,TNT-12


IF YOU COULD HELP ME i WOULD BE SO APPRECIATIVE.

Thanks, David
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,223,248
Messages
6,171,021
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top