Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
12 replies
Subscribers
7 subscribers
Views
10150 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Parsing data from an Excel file
angadc
Certified Lead Developer
over 7 years ago
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
aloks0189
Certified Lead Developer
over 7 years ago
@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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
angadc
Certified Lead Developer
over 7 years ago
Unfortunately we're not creating the excel spreadsheet.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<