The Excel worksheet contains data

1st Column

Part Name
Left Mount Bracket
Left Mount Bolts
Front Cover
WaterPump
Bolts

2nd Column


No. of Bolts
3
3
3

3rd Column

Bolt Size (mm)
M12
M12
M12


4th Column

Pretension Load(KN)
63.8
63.8
63.8

Added Developer option , then import a XML File and Mapped the XML element for Part Name,Bolt Size,No of Bolts,Pretension Load.


when mapping PartName, BoltSize ,No of Bolts,Pretension Load ,its selecting the cell only it has values.

so when verify map for Export it show as
" A mapped elements relationship with other elements cannot be preserved"

As a result,Export option not working.

Problem is,
when mapping Part Name its selects all cells,is there any possible to select the cells by the user wants while mapping....

Kindly waiting for Reply