Create fields by uploading the excel files

AFAIK when you import data from an Excel document it can only extract the current value of an individual cell, not dynamically query the type of data in a cell. Are the Excel files you want to import not predictable in their content and layout? (if they're not how will you write any logic to validate, process or store that data?)

thank you stewart for your reply,I got it

But I have one issue that is when I am constructing my CDT getting the null values can you please suggest me how to remove null from the current item and should get the mapping key for that

a!localVariables(
  local!row:readexcelimportfile(
    ri!documentId,
    0,
    1,
    5
  ),
  
  local!surveyOptionsData:
  a!forEach(
    items: local!row.result.values,
    expression: a!forEach(
      items: fv!item[4],
    expression:
    a!forEach(
      items: split(fv!item,"|"),
    expression: a!localVariables(
      local!check: 
      if(
      a!isNullOrEmpty(fv!item),
      0,
      fv!item),
    'type!{urn:com:appian:types:DSC}DSC_surveyFieldOption'(
      optionName:local!check,
     mappingKey:fv!itemCount,
      sortInfo: fv!index
    )
    )
      
    
   
)
  ),
  ),
  local!surveyOptionsData


)