Reading Excel as truncated / rounded values

[PriyankaTailor]

Hi, I'm using Get Worksheet as Collection in the Excel VBO. When the data comes through it's not the true value, it takes the value to only 2 decimals (as is seen in the raw excel format). Other than formatting the existing .xlsx file, is there a way to draw in the raw data as a full value rather than truncated / rounded? Thanks, Pri

[HarikrishnaMura]

Hi Priyanka, I am not sure if this might help, But before your u use Get Worksheet, i suggest you format the cells using Format cell action. So you would not need to manually go in and change the format. Then use the Get Worksheet to import. Thanks, Hari

[PriyankaTailor]

Thank you for the response - has anyone out the successfully modified the code / created something that draws out the value?