how to call parameters in excelshet to asp.net/xml?
-
hi I have created an excel sheet and saved in the application under wwwroot i like to know how i can pick up certain details like age or name from sheet and displayed in the webpage (using asp.net & C#).is there any external tool required for this?Since i am using file explorer where drive, folders, files,excelsheet appear.I tried to use xml file but was able to call of the entire file not certain parameters from xml. anyone could tell how i can proceed this problem sasi
-
hi I have created an excel sheet and saved in the application under wwwroot i like to know how i can pick up certain details like age or name from sheet and displayed in the webpage (using asp.net & C#).is there any external tool required for this?Since i am using file explorer where drive, folders, files,excelsheet appear.I tried to use xml file but was able to call of the entire file not certain parameters from xml. anyone could tell how i can proceed this problem sasi
sasire18 wrote:
i like to know how i can pick up certain details like age or name from sheet
Have a look into these articles, once you have these details in a dataset, reading values should be easy. Excel_Connectivity[^] Excel_Application_in_C[^]
sasire18 wrote:
I tried to use xml file but was able to call of the entire file not certain parameters from xml.
It is possible to read individual elements and attribute from a xml file. Easiest way is to use
Dataset ds=new dataset(); ds.ReadXml("xmlpath");Another method is to use XpathNavigator, Xpath queries with XmlDocument.