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

Parents

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

Reply

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

Children

No Data