Hi All, Im looking the way how to get the last row used in a excel without using a data table as the excel file is big and will take a lot of resources. is there a way to use excel api from UiPath? Im looking to use a VBA Macro like this endRowIndex=Sheets(“Sheet1”).Range(“B65525”).End(xlUp).Row …

Hi @Nguyen_Van_Luong1 This will solved the current situation. Thank you @mahmoud.zaky , @Anil_G , @vrdabberu , @rikulsilva , @sasi_poosarla , and all who help me on this procedure. [Screenshot 2023-12-26 153513] [Solution1] Recap: Excel Application Scope Read Range var1 = UiPath.Excel.Helpers.E…

getLast rowIndex from Excel file

Help Studio

Nguyen_Van_Luong1 (Nguyen Van Luong) December 25, 2023, 11:30am 7

Hi @Mauricio_Gomez ,
You can use it

regards,

Topic		Replies	Views
How to find lastrow in excel using UIpath or SQL query Learn	13	1378	February 16, 2020
Get last row without read range activity Studio uiautomation , activities , studio	14	1884	April 28, 2023
How to find last line of a column Studio excel , activities , studio	5	261	December 22, 2023
Get last row activity problem Studio excel , studio , question	4	504	December 25, 2023
How to Find the End Row of Specific Column (F) in Excel using UiPath Help	6	4513	January 26, 2019

Most Active Users - Yesterday
Yoichi
Raja.G
mkt.scott4
More details...

getLast rowIndex from Excel file

Related Topics