Hi:
Having a hard time to get the .xls file data to a dataset:
Here is what I have done so far:
DataSet dst = new DataSet();
string sXPath = "response/result/Leads/row/FL";
XmlDocument doc = new XmlDocument();
doc.Load(HttpContext.Current.Server.MapPath("leadsXLM.xml"));
XmlNode root = doc.DocumentElement;
My .xml file example:
<?xml version="1.0" encoding="UTF-8" ?>
<response uri="/crm/private/xml/Leads/getRecords">
<result>
<Leads>
<row no="1">
<FL val="LEADID">258013000000072025</FL>
<FL val="SMOWNERID">258013000000034003</FL>
<FL val="Company"><![CDATA[abc]]></FL>
</row>
<row no="2">
<FL val=" ...
Go to the complete details ...