How to retrieve Excel table range without opening the file?

Help Activities
,
1

Hello, I would like to retrieve the range of a table from an Excel file, save it in a data table, but without opening the Excel file.

2

Hi,

Can you elaborate your requirement? If it means reading data without opening Excel application, ReadRange(Workbook) activity may help you.

Regards,

1 Like
3

Yes, but does the modern version exist? I only found the classic version. In the modern version, the file always opens. I wish to work on the data table that I would extract from Excel.

4

Hi,

Workbook activities also exist in recent version. Can you check under System-File-Workbook in Activities panel?

image
image425Ă—543 17.8 KB

Regards,

5

Yes, that is the “Classic” version. I was wondering if there was a modern version available. It seems there isn’t…

The image shows the UiPath Studio interface with a drop-down menu displaying various Excel-related activities under the "App Integration" section, highlighting the "Read Range" activity. (Captioned by AI)
The image shows the UiPath Studio interface with a drop-down menu displaying various Excel-related activities under the "App Integration" section, highlighting the "Read Range" activity. (Captioned by AI)613Ă—729 24.6 KB

6

Nope. ReadRangeWorkbook activity is neither modern nor classic. Can you search it by ReadRange? ReadRangeWorkbook activity can be found.

Regards,

1 Like
7

Yes. now i have the Data Table. Thank you very much.

1 Like
8

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