Excel cannot import all XML Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-3438725%22%20slang%3D%22en-US%22%3EExcel%20cannot%20import%20all%20XML%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3438725%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20have%20imported%20a%20XML%20file%20through%20the%20developer%20tools%20but%20I%20can't%20import%20all%20the%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20I%20want%20to%20import%20the%20text%20from%20the%20cell%204.3.%20...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22a.jpg%22%20style%3D%22width%3A%20455px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22a.jpg%22%20style%3D%22width%3A%20455px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F375779i9038718635581315%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22a.jpg%22%20alt%3D%22a.jpg%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...%20I%20can't%20find%20it%20in%20the%20XML-Source.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22b.jpg%22%20style%3D%22width%3A%20369px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22b.jpg%22%20style%3D%22width%3A%20369px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F375776i2ABD16A7B301162E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22b.jpg%22%20alt%3D%22b.jpg%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIt%20looks%20like%20I%20can't%20import%20the%20text%20of%20a%20cell%2C%20if%20it%20has%20other%20child%20cells%20under%20(e.g.%20I%20can%20import%20I-4.3.1.%20but%20not%20I-4.3)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20solve%20this%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMartin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3438725%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hello! I have imported a XML file through the developer tools but I can't import all the cells.

 

For example, if I want to import the text from the cell 4.3. ...

a.jpg

 

... I can't find it in the XML-Source.

 

b.jpg

It looks like I can't import the text of a cell, if it has other child cells under (e.g. I can import I-4.3.1. but not I-4.3)

 

Is there anyway to solve this problem?

 

Thank you in advance!

 

 

Martin

0 Replies