<?xml version="1.0" encoding="UTF-8"?><metadata xml:lang="en">
<Esri>
<CreaDate>20170801</CreaDate>
<CreaTime>10273000</CreaTime>
<ArcGISFormat>1.0</ArcGISFormat>
<SyncOnce>TRUE</SyncOnce>
<ModDate>20170801</ModDate>
<ModTime>162041</ModTime>
</Esri>
<tool displayname="ExcelAnalyze" name="ExcelAnalyze" toolboxalias="">
<arcToolboxHelpPath>withheld</arcToolboxHelpPath>
<parameters>
<param datatype="String" direction="Input" displayname="excelFile" expression="excelFile" name="excelFile" type="Required"/>
<param datatype="String" direction="Input" displayname="validateWorkspace" expression="validateWorkspace" name="validateWorkspace" type="Required"/>
</parameters>
<summary>&lt;DIV STYLE="text-align:Left;"&gt;&lt;DIV&gt;&lt;P&gt;&lt;SPAN&gt;This function returns information about an excel file.
The function is used by the Analyze and Publish operations in on-premise Portal.
For each sheet in the excel file it will return the sheet name, id, and the list of fields.
The result is a json with this syntax:
{ "sheets" : [ &lt;sheet1&gt;, &lt;sheet2&gt;,...]}
where each sheet is an object like the following:
{ "name" : &lt;name&gt;, "id": &lt;id&gt;, "fields": [ {"name": &lt;fname&gt;, "type": &lt;ftype&gt;, "length": &lt;theLength&gt; },  ]}&lt;/SPAN&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;</summary>
</tool>
<dataIdInfo>
<idCitation>
<resTitle>ExcelAnalyze</resTitle>
</idCitation>
</dataIdInfo>
<distInfo>
<distributor>
<distorFormat>
<formatName>ArcToolbox Tool</formatName>
</distorFormat>
</distributor>
</distInfo>
</metadata>
