How to read the excel which could not open manually?

Help Studio
, ,
1

I have an excel that excel could not open manually.

But I need to read that excel from UI Path.

Can any one help me regarding this.

2

Hi @Vanitha_VS

Use Read range workbook activity

or

image
image1170×699 25.1 KB

Hope it helps!!

3

@Vanitha_VS
use this activity for read excel
image

4

Hi @Vanitha_VS

UiPath has the ability to open Excel files in read-only mode. This might allow you to read the data from the file even if it cannot be opened manually.

Read Range activity → Workbook → Options → IsReadOnly (Check this option)

Enabling the “IsReadOnly” option might help UiPath to read the data without attempting to modify the file.