<?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>20220304</ModDate>
        <ModTime>164534</ModTime>
    </Esri>
    <tool displayname="ExcelAnalyze" name="ExcelAnalyze" toolboxalias="">
        <arcToolboxHelpPath>withheld</arcToolboxHelpPath>
        <parameters>
            <param datatype="String" direction="Input" displayname="Input Excel File" expression="excelFile" name="excelFile" type="Required"/>
            <param datatype="String" direction="Input" displayname="Validation Workspace" 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>
