Hi Team,
I have excel with multiple data , Please find the attachment for your reference
In that attachment, BYD=“55602960” and “55719321” . Need to remove this entire rows
Please suggest.
How to delete above entire rows from the excel and I want remaining data in the same excel with headers.
Please help me to slove this issue
Hello @Baby123
You can use Insert/Delete rows activity in excel scope
Define the position that you need to delete and change the mode to remove for delete rows
Hi @Gokul_Jayakumar ,
Thanks for quick response.
I tired this one but I have problem with row position.
I don’t know which position those above values are there .
So I want pass position dynamically.
Kindly suggest
@Baby123
Use Look up range and pass the value you need to find
example lookupu value is 55725781 and output variable stored in String “CellPosition”, it will print as a “B4”
Useing regex you cant split number
Sysytem.Text.RegularExpression.Regex.Match(cellPosition,"\d+").tostring.trim
@Baby123
please follow these steps.
1- use read range to read data from excel in datatable.
2- use for each loop over datatable.
3- put if condition and place condition where you want to match data.
4- in then block put delete/insert row activity and put (For Each ->Row)
5- outside loop write range activity and give datatable and output file.
@Baby123 This is the easiest way. without linq or another complex method
Hi @raja.arslankhan ,
In that insert/ delete activity how to pass position as dynamic.
I don’t know in which rows those values are there
At that time how can I mention position in insert/delete activity to delete entire row.
And also I want to delete previous mentioned 2 Types of duplicate values only .
I want remaining data and headers.
Thank you
Hi @Gokul_Jayakumar ,
We will try and update you
I have another issue like
I wnat to create column at end of the excel for example I created one column like Status and reasonofFailure
So I want to write in that columns as fail and mention the reason also.
Here my issue is how I know in which column position to write the fail and reason
.
Please find the attachment for your reference.
For example I want create column in M column and then enter the values as fail and reason one by one for that I using write cell activity,
In that activity how to pass M cellvalue as dynamic.
Please suggest
Processing: IMG-20220909-WA0012.jpeg…
Hello @Baby123 , Screen shot image is not visible
Kindly try this
Dt.columns.count+1Use Looku Up range
You can get position of word status For example “M1”
System.Text.RegularExpressions.Regex.Match(YourString,"\D+").ToString.Trim
You can Get M, In write cell use M+NumberString
HI @Baby123
Try like this
Use Excel Application and read range activity and store the value in the datatable
Use Filter Datatable activity and configure it.
Use write range and give the new sheet name and check on add headers in properties and write the data table in the new sheet.
Delete the old sheet using modern activity(Find the activity after enabling show modern in the filters)
Or you can use that sheet as the initial inout with no changes
Hope this Helps!!
Regards
Sudharsan
@Baby123 give me time I can try with code. I implemented this but I can try again
@Baby123 Can you send me sample data.
Best would be to filtwr on byd using filter excel activity
And then use delete rows with visible option…it would delete all the rows
Cheers
