Robot change format cells in excel on hashtags

Help StudioX
,
1

Hi , my robot copies data from excel and pastes it into the application, but instead of a string of numbers that are in a table, the robot changes them to hashtags. Do you know what the problem can be?

2

Can you show your excel file?

3

@sullivanne

Try to read the data into datatable

Then convert to string as you need and check

Also generally we see that when the data in excel is skewed in column or when there are formulae in cells…better to copy with preserving format or use backdata

Cheers

4

Hi, @sullivanne

First, if you are using a workbook. Change it to Excel application. Or change the Excel application scope to workbook.

Second way, use excel format cells activity or copy use value.

I hope it will be help to you :slight_smile: