I am using Parse Excel Spreadsheet to CDT smart node(To upload excel data in to

sivam over 9 years ago

I am using Parse Excel Spreadsheet to CDT smart node(To upload excel data in to DB), in the excel having a column "ID". In this ID column I am passing numbers length 9. While reading in the process model using Parse Excel Spreadsheet to CDT smart node, the numbers are converting to exponential value if the number length is more than 7.

Example: 12345678 (Excel column value) ---- 1.234568e+07 (process variable value)

Thanks.

Discussion posts and replies are publicly visible

0 youyongz over 9 years ago

This is Excel issue. Try format cell in Excel to remove the exponential format.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sumeet Khare over 9 years ago

when you are reading that excel, convert it to decimal and then it will work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 siddharthm over 9 years ago

Hi Sivam. Even we were facing this issue . I believe this expression will help you in retaining the excel column value - fixed(todecimal(ri!value),0,true).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel