topic RE: Fix Truncated excel columns in Product Forum

Fix Truncated excel columns

DavidOku — Mon, 25 Jul 2022 11:27:00 GMT

Hello after reading an excel into a collection I have values truncated like 7.22512E+11 as seen in the image below. please how do i use blue prism to fix this column

------------------------------
David Oku
------------------------------

RE: Fix Truncated excel columns

ewilson — Tue, 26 Jul 2022 01:03:00 GMT

Hello @DavidOku,

Are you saying the values are truncated in the Excel spreadsheet or in the Blue Prism Collection? And I assume by truncated you're referring to the scientific notation (ex. E+11) used in some cases?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Fix Truncated excel columns

DavidOku — Tue, 26 Jul 2022 08:05:00 GMT

Hello Eric,

Yes exactly

Thank you

------------------------------
David Oku
------------------------------

RE: Fix Truncated excel columns

Tejaskumar_Darji — Tue, 26 Jul 2022 11:39:00 GMT

Hello David,

You can use Format Cell action from MS Excel VBO and update cell format to Custom format.

Then perform a save action on excel and then try to Get the Worksheet as a collection.

This should resolve your issue.

Try and let us know how it goes.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: Fix Truncated excel columns

michaeloneil — Tue, 26 Jul 2022 11:41:00 GMT

Hi David

I think for this you would need to select the range in the worksheet and format it to either text or number. In scientific format the range will be taken as text into the collection as it appears in the worksheet. If you format the cells to text or number it should show the full number list before you get the range as a collection.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------