XML Import in Excel

[omar_85]

Hi all,

When we import an xml file to Excel file, the data is shown in the Excel in a formatted way and with Filter on. Is there any way to avoid that formatting and filter.

The problem with this formatting is, even if I apply a formatting to the formatted column it doesn't get affected until I edit the cell individually.

I have a date column in my xml, when imported it is taken in Excel as a text field. Then if I apply formatting to that column and change it to different date format, it doesn't get affected until I edit each cell individually.

I don't want the data to be formatted and I don't need the filter applied. Is there any way to solve this??? Anything with XMLMap or anyway??

I will be using VBA.

Thanks in advance.

 

[uknowme99]

perhaps import as text?

 

[omar_85]

No sir, If I import it as text it just shows it in a single cell. I need the XML imported as different columns and rows, but doesn't need the filter be applied.

Still looking for a solution.