How to Read a particular Data from XML file and Write it to an Existing Excel Sheet using c# -


i have xml file, have values good, , bad, tag quality. want read xml file , print ones bad, in excel sheet existing. can me please. xml file looks same below. in text want write entire hydr. instrument id, hydr.quality" bad values in hydr.quality element.

<hydr.instrument id="abr"> <hydr.quality>good</hydr.quality> <hydr.value>0</hydr.value> </hydr.instrument> <hydr.instrument id="abr_dummy"> <hydr.quality>bad</hydr.quality> <hydr.value>0</hydr.value> </hydr.instrument> <hydr.instrument id="abr_loop_jp"> <hydr.quality>good</hydr.quality> <hydr.value>15.208 kg/cm2g</hydr.value> </hydr.instrument> <hydr.instrument id="abr_mov_12"> <hydr.quality>good</hydr.quality> <hydr.value>0</hydr.value> </hydr.instrument>

basically need use 2 libraries answer want:

  1. first need load xml file, suggest using linq library, can start here

  2. then, need write filtered xml elements excel, suggest use aspose library, can start learning here

using these 2 libraries, can achieve want.


Comments

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

c# - how to use buttonedit in devexpress gridcontrol -

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -