I have succesfully added a map to my excel workbook.My problem is when trying to map the fields i need.
It seems that excel tryes to find a pattern but dosent find it in my excel file.
Here is some of the xml that i want to obtain as exported from the html. The structure is repetitive. I can't be able to map my workbook (see atachement) on that. Can it be done? Have any tips ?
Thanks in advance.
- <meniu>
- <week>
- <day>
<name>luni</name>
<date>13.05.2008</date>
- <food>
- <menu>
<title>SALATA DE CRUDITATI CU PIEPT DE PUI</title>
<weight>300g</weight>
</menu>
- <menu>
<title>CIORBA DE PUI CA LA RADAUTI</title>
<Gramaj>60/340g</Gramaj>
</menu>
- <menu>
<title>RULOURI DE PUI CATALANE</title>
<Gramaj>100/200g</Gramaj>
</menu>
- <menu>
<title>FRIPTURA DE PORC CA LA PRAGA</title>
<weight>100/200g</weight>
</menu>
- <menu>
<title>SALATA VERDE CU SOS DE LAMAIE</title>
<weight>200g</weight>
</menu>
- <menu>
<title>CROISSANT CU CIOCOLATA</title>
<weight>100g</weight>
</menu>
</food>
</day>
- <day>
<name>Marti</name>
<date>14.05.2008</date>
- <food>
[...]
</week>
- <variante>
- <offer>
<title>Varianta 1</title>
<description>4 feluri 4b3b2n</description>
<price1>123</price1>
<price2>125</price2>
</offer>
- <offer>
<title>Varianta 2</title>
<description>4 feluri 4b3b2n</description>
<price1>123</price1>
<price2>125</price2>
</offer>
- <offer>
<title>Varianta 3</title>
<description>4 feluri 4b3b2n</description>
<price1>123</price1>
<price2>125</price2>
</offer>
</variante>
</meniu>
I have also attached the xls. file.
Bookmarks