ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trouble with fields order of imported XML files (https://www.excelbanter.com/excel-programming/299263-trouble-fields-order-imported-xml-files.html)

Francesco Sblendorio

Trouble with fields order of imported XML files
 
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
<NOMEFrancesco</NOME
<COGNOMESblendorio</COGNOME
<INDIRIZZO32</INDIRIZZO
<CITTABitonto</CITTA
</RIGA
<RIGA
<NOMEGurzo</NOME
<COGNOMEGurzi</COGNOME
<INDIRIZZO45</INDIRIZZO
<CITTABorneo Meridionale</CITTA
</RIGA
<RIGA
<NOMECico</NOME
<COGNOMEPolmone</COGNOME
<INDIRIZZO77</INDIRIZZO
<CITTABari</CITTA
</RIGA
<RIGA
<NOMELippo</NOME
<COGNOMETippo</COGNOME
<INDIRIZZO433</INDIRIZZO
<CITTARitonto</CITTA
</RIGA
<RIGA
<NOMEPeppino</NOME
<COGNOMEPuzzone</COGNOME
<INDIRIZZO2222</INDIRIZZO
<CITTAJappone</CITTA
</RIGA
</MODULE1






All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com