Trouble with fields order of imported XML files

  • Thread starter Francesco Sblendorio
  • Start date
F

Francesco Sblendorio

I've imported the XML file reported at the bottom of this post.
It has 4 field in this order: NOME, COGNOME, INDIRIZZO, CITTA.

Importing this file into Excel, the fields order is altered into:CITTA,
COGNOME, INDIRIZZO, NOME. It seems alphabetical order.

How can I avoid this effect?
Thanks in advance again.

--XML FILE-------------------

<?xml version="1.0"?>
<MODULE1>
<RIGA>
<NOME>Francesco</NOME>
<COGNOME>Sblendorio</COGNOME>
<INDIRIZZO>32</INDIRIZZO>
<CITTA>Bitonto</CITTA>
</RIGA>
<RIGA>
<NOME>Gurzo</NOME>
<COGNOME>Gurzi</COGNOME>
<INDIRIZZO>45</INDIRIZZO>
<CITTA>Borneo Meridionale</CITTA>
</RIGA>
<RIGA>
<NOME>Cico</NOME>
<COGNOME>Polmone</COGNOME>
<INDIRIZZO>77</INDIRIZZO>
<CITTA>Bari</CITTA>
</RIGA>
<RIGA>
<NOME>Lippo</NOME>
<COGNOME>Tippo</COGNOME>
<INDIRIZZO>433</INDIRIZZO>
<CITTA>Ritonto</CITTA>
</RIGA>
<RIGA>
<NOME>Peppino</NOME>
<COGNOME>Puzzone</COGNOME>
<INDIRIZZO>2222</INDIRIZZO>
<CITTA>Jappone</CITTA>
</RIGA>
</MODULE1>
 
Top