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
5 replies
Subscribers
5 subscribers
Views
5064 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Parse Excel to CDT
jegadeeswaran
over 7 years ago
Please advice on below issue :
--> when I do parse excel to cdt of column having number which of 10 digit Ex: 1420660768 in Excel is converted to 1.420661e+09. Please let me know any way to fix this one. I don't want to append "Appostrophe" infront of number as business used case is to create excel from other System DB and Upload it in Appian.
OriginalPostID-239024
Discussion posts and replies are publicly visible
Parents
0
Tim
Certified Lead Developer
over 7 years ago
I think you would need to modify the plugin to fix this issue. If the cell value is a number the java library used will return it as such even if the column is formatted as text in the Excel spreadsheet. It then runs into Appian's inability to handle large numbers so you get the exponential notation. I have had this issue recently myself but fortunatelty was able to get the source system to prefix the values with a fixed character which I then removed in process.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Tim
Certified Lead Developer
over 7 years ago
I think you would need to modify the plugin to fix this issue. If the cell value is a number the java library used will return it as such even if the column is formatted as text in the Excel spreadsheet. It then runs into Appian's inability to handle large numbers so you get the exponential notation. I have had this issue recently myself but fortunatelty was able to get the source system to prefix the values with a fixed character which I then removed in process.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data