Indexing to Lis of text String

Hi All,

I am trying to use indexing for type " List of Text String " but the output i am getting not the expected output i am adding the screenshots here for reference.

Thanks In advance,

SSP

  Discussion posts and replies are publicly visible

Parents Reply
  • 0
    Certified Senior Developer
    in reply to sivasuryap0002

    a!localVariables(
      local!uploadedFile,
      local!exceldata,
      a!sectionLayout(
        contents: {
          a!textField(
            value:local!uploadedFile,
            saveInto: {
              local!uploadedFile,
              a!save(
                local!exceldata,
                index(
                  readexcelsheet(
                    excelDocument:todocument(57745), /*57745 is the document id. Please replace it with yours*/
                    sheetNumber:0,
                    startRow: 0
                  ),
                  "result",
                  {}
                )
              )
            }
          ),
          a!gridField(
            label: "Excel Data :",
            emptyGridMessage: "Please Upload a File with Values",
            data: remove(local!exceldata, 1),
            columns: a!forEach(
              items: local!excelData[1].values,
                expression: a!gridColumn(label: fv!item, value: index(fv!row.values,fv!index,{}))
            ),
            showWhen: not(a!isNullOrEmpty(local!uploadedFile))
          )
    
        }
      )
    )

    Please refer the above code

Children
No Data