Hello, I am trying to read a 89 MB excel file with 455302 rows. if I use the read range (a system activity) it UiPath frozen and stop working, but if I use excel application scope anad a read column read column activity works great, but the problem is that I would like to delete the file that con…

Either you read a column or an entire range it is recommended to use Excel Application Scope. Reading very large Excel files has a nice solution: do it in chunks of 10000 rows. Read A1:C10000, then A10001:C:20000 and so on until you get less than 10.000 rows in the resulting datatable. I don’t qui…

Thank you for your reply Badita ImI>, I have this file with 37 columns and a lot of rows, and I’m trying to delete everything that has today’s date. I know how to run a “for each” activity but like I said UiPath frozen every time I tried to read the file due to the quantity of lines I guess, the t…

Let’s suppose that reading in batches has been solved. Now we need to remove the rows that falls under a specific condition. There are two remarks here: There’s no need to use Invoke Method as there is a dedicated activity for this Remove Data Row. As a parenthesis, if you want to use Invoke Me…

Is there any activity that could be built based on badita’s answer? Then we could delete whilst iterating through the datatable? People have different ways of doing this - my method is to use dt.Select to grab the rows I don’t want into an array of Data Rows and then delete them in a separate for e…

Hi Badita, Based on your While block example, how do I refer to the particular column’s data of the corresponding data row for the condition check, prior to decide using RemoveDataRow if the condition is true? Thanks, Tew

[image] leepoo: I refer to the particular column’s data of the corresponding data row for the condition check, prior to decide using RemoveDataRow if the condition is true? This post might help you on this: [image] Comparing two CSV files by checking email addresses Help …

@badita I have a same problem while reading 100,000 rows in a excel sheet . So , i tried doing it in chunks but issue is header of the sheet , i have 100 columns in my sheet . So , if i read 10000 rows first and store it in a datatable(Dt1) then i run do while loop to read more rows until rows less…

How to delete a row in excel using invoke method

Help

aksh1yadav (AKSHAY YADAV) April 18, 2017, 9:39am 7

This post might help you on this:

Regards…!!
Aksh

Topic		Replies	Views
How to delete row from excel Help	15	2299	May 20, 2021
How to delete Top 5 excel row? Help	11	5233	October 29, 2018
How to delete particular row from excel Activities excel , activities , question	9	921	January 2, 2024
How can i delete a row from an excel ? Is there any activity outside excel application scope Studio studio	2	1181	January 18, 2023
How to delete a row in an Excel workbook Help	6	13449	October 12, 2018

How to delete a row in excel using invoke method

Related topics