How To Use Delete Rows Activity For Studio And StudioX Profiles?

News Knowledge Base
,
1

How to use Delete Rows activity for Studio and StudioX profiles?

In this tutorial, we will provide examples for both Studio and StudioX profiles and we used the latest package version UiPath.Excel.Activities[2.12.0-preview] that were available at that moment (you can use your newest available version).

For Studio profile use this example:

  1. Add in Dependencies: UiPath.Excel.Activities[2.12.0-preview] package

![](upload://kzr7u12D67g5c4KYObrTQgIfNrd.html)

  1. Add an Excel Process Scope activity

![](upload://oB43MgYJFTE9TqQIOgvsV8gb6yL.html)

  1. Add an Use Excel File activity

![](upload://zEtuCqFnsXWXvSd5E9NjC6UJTUw.html)

  1. Add a Delete Rows activity

![](upload://zBfWvht5O3Kc4CYyxCAQZpyj5jc.html)

*************

For StudioX profile use this example:

  1. Open Project in StudioX -> Project Settings -> Excel Modern -> Excel Design Experience -> UseGlobalSetting -> OK

![](upload://2pgxWVz6jHwAdY3Mpq3WPmnJjuC.html)

  1. Manage Packages -> Project Dependencies -> find UiPath.Excel.Activities[2.12.0-preview] package -> Update -> Save

![](upload://o7iOgY0EpGYSX3V4UgqjNAbePJV.html)

  1. Add an Excel Process Scope activity

![](upload://wHASrzLDg7bbQ8OPAxMNlzcfGDM.html)

  1. Add an Use Excel File activity

![](upload://Ag4idwmm3N4y9SHrwcoXxgLnYUV.html)

  1. Add an Delete Rows activity

![](upload://akKaE88QiuDTxmOGWta1t75dIFn.html)

  1. The whole workflow should look like below

![](upload://hhlDZ2HpFuGp4OwcMpdXKu70u5V.html)