Boss let me change a function, in an excel click "export XML" button, can derive an XML file, but the XML file inside the third line is wrong, need to put the third line "& lt; A000000 & gt;" Changed to "& lt; A000000 xsi: type="A000000Nd2018Ywbd & gt;" " , I got a long time didn't also out, seek help from a great god

Below is a screenshot

CodePudding user response:

Replace with the replace function doesn't work?

CodePudding user response:

Elder brother, zha replace? I'm not quite understand, is in the second image to replace?

CodePudding user response:

Reads the XML content, replacement, and then save;
Replacement method like this:
StrContent=replace (strContent, "& lt; A000000 & gt;" , "& lt; A000000Nd2018Ywbd A000000 xsi: type="" "" & gt;" )