Parsing data from an Excel file

Certified Lead Developer
When using readexcelsheet() to parse data from an excel spreadsheet we're experiencing a strange issue. We notice that ".0" is automatically added to text that is numeric. For example, "2290" is parsed as "2290.0" in Appian.

The data is copy pasted as values. The formatting of the cell is set to Text.

Has anyone experienced this issue? If so, do you have a workaround?

OriginalPostID-270062

  Discussion posts and replies are publicly visible

  • 0
    Certified Lead Developer
    @angadc i agree with @martinc872, although we can work in another approach too, if the excel file (which you are trying to parse) is also generated by you, then first of all prepare an excel template which will have cell formatting as Integer rather than Decimal for the wanted field, then use this Template to be overwrite by the Smart Service(which fills the data into the Excel Template), then try parsing that data to excel, so i expect that the cell will return only integer values. also while holding the value, also try capturing the integer cell values into integer variable only

    Note: This solution will be applicable, only if you are the one who is responsible to generate the Excel File Template
  • 0
    Certified Lead Developer
    Unfortunately we're not creating the excel spreadsheet.