Read Excel file Time

[isbsrobot2]

Hello All,
I have an excel file with 473 columns and 1 lakh+ rows, so in excel application scope, read range workbook and Excel process scope to read the data it’s taking around 30-40 min of time. Is there any other possible way to read the data in least time. Please help me in sorting this issue.

[lrtetala (Lakshman Reddy)]

Hi @isbsrobot2

UiPath Community 2023.10 Release - Studio & StudioX

Studio & StudioX This topic goes in-depth about the improvements in Studio & StudioX. To read about other products, please navigate to the main topic here. Autogenerated variables for Windows projects It is now possible to consume activity outputs without manually creating variables on Windows projects on both Studio and StudioX. The functionality had been introduced on the 2023.4 release on Cross Platform projects and it’s now available on the Windows framework. Autogenerated variables shoul…

[Palaniyappan (Forum Leader)]

If that’s the case then I would recommend to host the data in a database instead of an excel file
Then it becomes very easy to query out the data we need

Or

Treat excel file as a database and extract the data from it
Refer this for more details

Using Excel As Database

How to connect with Excel as a database ? Perform the details mentioned in the Step by step guide, for connecting Excel as a database Open Excel file (Note - Excel file must remain open) In UiPath Studio Drag and drop Connect / Execute (Non) query activity Click Configure connection Open Connection Wizard Select Microsoft ODBC Data Source Use Connection String Click Build Go to Machine Data Source Click New Click Next Microsoft Excel Driver(.xls) Next Finish Give Some Data Source Name and Desc…

Session 3-Connect Excel As Database with UiPath | Excel As DB Automation UiPath

Or finally you can try with marketplace component

Read Extra Large SpreadSheets - RPA Component | UiPath Marketplace | Overview

Hope this helps

Cheers @isbsrobot2