Excel Delete Range Bug

Help
,
1

I am using Delete Range from UIpath.Excel.Activities 2.6.3
for example we use delete range with A1:E100
if some rows (for example A5:E50) are filtered it won’t be deleted and will break inserted data to A1:E100 (makes a lot of corrupted data).

2

did we try with insert/delete rows activity

Cheers @vadim

3

Thanks,

But delete rows is not the same that is delete range. It is not a decision, the issue is about removing data from the definite range.

4

why not buddy
here also we will be mentioning the range to be deleted with two properties

  • NoRows - The number of rows you wish to add or remove. This field supports only integers or Int32 variables.
  • Position - The row where the insertion or removal begins. This field supports only integers or Int32 variables.

but we need datatable and then once after deleting it we can write back to excel with write range activity
Cheers @vadim

5

@vadim,

Check this xaml, I have used Excel.Extensions package, new package from UiPath Team. Include that from Manaage package and then check with this xaml.

ExcelDeleteRange.xaml (5.1 KB)

6

For example, you will get different results removing rows and range. So that’s exactly i told you about.

image
image1929×1039 208 KB

there is no need to use such approach that requires extra efforts and resources to store data and write it back.

7

The simplest decision i found is in that

  1. set ShiftCells property of Delete Range to enabled.
  2. set ShiftOption to ShiftUp

It works only you dont’ store data below the range.

8

The most effective resolution is to Invoke VBA And to remove filters on a sheet.

Sheets(sheetName).ShowAllData

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.