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
7 replies
Subscribers
5 subscribers
Views
3695 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
I am currently using "Read Excel Spreadsheet to CDT" Plug-in to read v
samuelr
over 10 years ago
I am currently using "Read Excel Spreadsheet to CDT" Plug-in to read values from Excel. However, when I have a row in excel that needs to be read in as text and the field is defined as text in the cdt, the plug-in formats the data using a numerical protocol when the data is read in. Meaning if you have data in a cell as 456000000, it will not appear this way when its read in, even though everything is defined as text. It will instead read in 4.56e8, which is a problem when you get rounding and the values become distorted. This happens for columns with mixed data as well. I was wondering if there is a way to get the plug-in to read the data as it is stored in excel, without distortion, and without making any changes the excel file like putting ' before the data....
OriginalPostID-75135
OriginalPostID-75135
Discussion posts and replies are publicly visible
Parents
0
nikhilh0001
over 10 years ago
Hi Elizabeth,
we are facing similar issue and was not resolved even after trying out the above mentioned points. I have created a sample application and attached it alongwith the excel on the thread link given by you in the above post.
Could you please let us know what can be done?
Thanks
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
nikhilh0001
over 10 years ago
Hi Elizabeth,
we are facing similar issue and was not resolved even after trying out the above mentioned points. I have created a sample application and attached it alongwith the excel on the thread link given by you in the above post.
Could you please let us know what can be done?
Thanks
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data