When we try to import a date with the fomat yyyy-MM-DD , the cell contains a text , not a date. When we look your example for the importxml you can see the date is not formated correctly. If I import the same xml file using the import action in excel, the date is correctly formated.
The workbook has a schema associated and the type of the element in the schema is xsd:date.
The value must be imported in the correct format because it is used after in excel formula.
You will find attached the zip , with the schema, the excel file and the xml file I try to import. The excel is already mapped to the schema.Test.zip (10.5 KB)
The import of the xml work well with excel import feature and the date format are applied correcty. The importxml import the date but with a wrong format and excel doesn’t understand the field as a date. When we observe the part corresponding to the sheet generated with exportxml and the save methods, the structure is completly different than when we use the import action provided by MS.
Do you garanty the macro, formula in the sheet are working after? The same xml data imported using the import feature provided by MS in Excel and the importxml and save provided by aspose don’t drive the same result for the document obtained. We would use this feature to isolate the data from the excel sheet, but we would garanty the type remains the same and the logic of the workbook continue to work.