Hi,
Does anyone Know how to delete 3 top row in Excel with.out Using hotkey ?
or delete 3 top row with out Opening .xlsx file .
anyone know about this ?
Rookie,
AUPE
Hi,
Does anyone Know how to delete 3 top row in Excel with.out Using hotkey ?
or delete 3 top row with out Opening .xlsx file .
anyone know about this ?
Rookie,
AUPE
Hi,
Use read range and specify range “A3”
This will return entire excel from 3 row.
And write range in same file.
Loop this for each exel file in folder
this is Great @iakshman
how about i have plenty of Excel to delete of top 3 rows ,
and all of this excel is inside the Folder
but he said without opening the .xlsx file
Insert/Delete Rows activity only valid Inside ExcelApplicationScope activity means the excel will be opened
Use workbook activity instead excelapplicationscope.
This my Problem
i have many excel file then all those file have a 3 rows must deleted .
strFiles = Directory.GetFiles(folderPath)
Iterate that array using For each activity and inside take one excel application scope and pass item. Then it will take one by one file and will delete top 3 rows. For this use above workflow.
Can’t use workbook activity for Insert/Delete Rows activity, because Insert/Delete Rows activity is valid only on ExcelApplicationScope activity.
You can try it.
@Aupe you can use his idea. But it will still open your excel 1 by 1, but it will close your excel 1 by 1 automatically once each excel top 3 rows been deleted.
but this will take a lot of time if there are files in bulk. How do we get this done without opening excel 1 by 1?
@VirajN
actually i can just make all cells on top 3 rows data to be null, but this will not delete the top 3 rows means your top 3 rows in your excel will be empty and the data starting from the row 4.
I know better to delete the rows instead of make the data to be empty without opening the excel.
But with the UiPath default activity seems no way to delete without opening excel, need to find 3rd party activity packages that can do that.
just fyi … this is not a issue that i am facing but i am just keen to learn
Hi @Aupe,
If you want to skip first 3 rows or N rows and take the rest all rows,
but then the purpose is not met. i guess we will have to just open the excel 1 by 1 using for each activity and delete the 3 rows
i agree with you.
with the UiPath default activity seems no way to delete without opening excel, need to find 3rd party activity packages that can do that.
thank you
hi @ iakshman can you show me .xaml sample for me to check
thank you
aupe
the scenario are simple .
i have plenty of Excel file in my Folder.
hundreds or more.
and all those excel have 3 row must deleted
means i want to delete first 1 to 3 rows
and start with the row 4.
Please find the attached workflow.
Test.xaml (10.4 KB)