Excel Format and Precision

Help Studio
, ,
1

Hi,

I am getting a downloaded file, which is corrupt in xls version. Unfortunately I can’t save it as any version. The file has data in Sceintific format and looses precision(eg 000 are missing from the from the cell)

The Team performs manually by opening a new excel - CTRL+0
Browse select file open click on Yes
Import wizard delimit > next> tab and other option select Pipe (l) > next> select all table as text> finish.

How can I perform this in UiPath?
Note Read range looses precision in this case

2

Usually, we can do it using the modern Excel file activities to achieve this.

If you have sample file please share it.

3

I tried using Morden activities but the precision is not maintained. Unfortunately I can’t share the file with you due policy Restrictions.

4

The actual extension is CSV format?

5

No it is xls, but it can be read as an csv or text.

6

Hi @Ritwik_Srivastava ,

While reading the data using read range have use , preserve format option ??

Regards
Sandy

7

Yes, did try that as well, but the data is not preserved when referred from Local panel

8

Can you tell me the extension of the file?

9

The extension is xls

10

The issues is Resolved.

Used Read csv and selected Tab as Delimiter, after that saved it to Datatable. From this Precision and format both are preserved. Note this is performed using the latest version CSV activity.

Then used a file that has Text as columns already reserved and performed write range.

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.