Parse Excel to CDT

Hi,
Could you please see if these articles help you?
forum.appian.com/.../10 digit number converting to
forum.appian.com/.../number showing as exponential

Are you using tointeger()? Please review forum.appian.com/.../Casting.html

Sally, Actually that column is a text type and when we are parsing the value Ex: 1420660768 is changed to 1.420661e+09

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.

I would like to add my experiences here, since I just ran into the same issue. In most of my excel templates I use a hidden sheet that replicates the first sheet where we can control column formatting, as user pasted text may be auto-formatted by Excel. I run macros on save to move values only from the first user-facing sheet to a hidden second sheet with defined formats, the excel import then utilizes sheet #2. Only down side so far is that users have to click the 'Enable Macros' button before saving their file prior to upload. For this notation issue, I modified the macros to add a "^" character to the beginning of the text, which is parsed out in the workflow via expression rule, before saving to the primary CDT. Works great!