B
babba
i'm trying to import data in excel 2003 trought xmlimport feature.
es.
Workbook.XmlMaps("xxxx_mapping").Import("xxx.xml", True)
The data are imported but the format of some cells are not correct.
For example decimal number mapped in the schema of the worksheet are
signed from excel like text end not number.
i've tryed to apply correct format via code (...
Application.Selection.NumberFormat = "#,##0.00"...) but without
positive result.
have you some ideas? it's a bug of excel or it's my fault?
thks
es.
Workbook.XmlMaps("xxxx_mapping").Import("xxx.xml", True)
The data are imported but the format of some cells are not correct.
For example decimal number mapped in the schema of the worksheet are
signed from excel like text end not number.
i've tryed to apply correct format via code (...
Application.Selection.NumberFormat = "#,##0.00"...) but without
positive result.
have you some ideas? it's a bug of excel or it's my fault?
thks