Work on unstructured data

Dear Team,

I want to automate SAP process but excel data is not in structured format.

Can we automate this type of process using UiPath tool.



First you must have to structure this data in some way. There are a lot of ways to read an excel file and get the information.

We have:
Read Range
Read Cell
OLEDB (SQL Query to Read Excel)

You can search for specific words in excel file to find the value that you need too.

Anyway, first you have to know what you need and then work in some way that you’ll retrieve this information to use it.