Showing excel data to editable grid

Certified Associate Developer

Hi,

I am working on an editable grid which shows excel data. I am fetching excel data from excel using "readexcelsheetpaging()" function. Now i want to map data to editable fields and i tried to do fv!item.fieldName but it is not working.

a!localVariables(
  /*local!studentData:excelreadcellsbyname(ri!excelFile,{1},{"A1","B1","C1"}),*/
  /*local!studentData:excelreadcellsbynumber(ri!excelFile,{1},{1,2,3},{2,3,4,5}),*/
  local!studentData:readexcelsheetpaging(ri!excelFile,0,a!pagingInfo(2,10)),
  local!gridDataType: 'type!{urn:com:appian:SD}SD_Student_Data'(),
a!formLayout(
  label: "Student Details",
  contents: {
    a!sectionLayout(
      contents: {
        a!gridLayout(
          label: "Editable Grid",
          labelPosition: "ABOVE",
          headerCells: {
            /*a!gridLayoutHeaderCell(label: "ID"),*/
            a!gridLayoutHeaderCell(label: "First Name"),
            a!gridLayoutHeaderCell(label: "Last Name"),
            a!gridLayoutHeaderCell(label: "Email Id")
            /*a!gridLayoutHeaderCell(label: "")*/
          },
          columnConfigs: {
            /*a!gridLayoutColumnConfig(width: "ICON"),*/
            a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
            a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
            a!gridLayoutColumnConfig(width: "DISTRIBUTE")
            /*a!gridLayosutColumnConfig(width: "ICON")*/
          },
          rows: {
            a!forEach(
              items: local!studentData,
              expression: a!gridRowLayout(
                contents: {
                  a!textField(
                    value: fv!item.,
                    saveinto: fv!item
                  ),
                  a!textField(
                    value: fv!item,
                    saveinto: fv!item
                  ),
                  a!textField(
                    value: fv!item,
                    saveinto: fv!item
                  ),
                }
              )
            )
          },
          selectionSaveInto: {},
          addRowLink: a!dynamicLink(
            label: "Add Student",
            saveInto: {
              a!save(local!studentData,append(local!studentData,local!gridDataType))
            }
          ),
          validations: {},
          shadeAlternateRows: true
        )
      }
    )
  },
  buttons: a!buttonLayout(
    primaryButtons: {
      a!buttonWidget(
        label: "Submit",
        saveInto: {
          a!startProcessLink(
            processModel: cons!SD_ADDSTUDENTCONST,
            processParameters: {
              
            }
          )
        },
        submit: true,
        style: "PRIMARY"
      )
    },
    secondaryButtons: {
      a!buttonWidget(
        label: "Cancel",
        value: true,
        saveInto: ri!cancel,
        submit: true,
        style: "NORMAL",
        validate: false
      )
    }
  )
)
)

  Discussion posts and replies are publicly visible

Parents Reply Children