Parsing data from an Excel file

angadc

Certified Lead Developer

over 8 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?

Discussion posts and replies are publicly visible

Parents

0 martinc8721 over 8 years ago

you could use the function toInteger() in order to display your data
load(
local!numbersFromExcel_txt: {
"2290.0",
"101.0"
},
apply(
fn!tointeger(
_
),
local!numbersFromExcel_txt
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 martinc8721 over 8 years ago

you could use the function toInteger() in order to display your data
load(
local!numbersFromExcel_txt: {
"2290.0",
"101.0"
},
apply(
fn!tointeger(
_
),
local!numbersFromExcel_txt
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data