Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again?

Help Activities
1

Description

Hi,
Can anyone help how to write data from DataTable(Sheet1) to other sheet (Sheet2) of the same excel but some of the columns of Sheet2 are hidden. So, getting above error

Please suggest any solution

Link

Date

2024-06-24

Related UiPath products

Studio

2

Hi @nkumarm271

Excel Process scope
Use Excel file
copy paste range activity.
Source-Excel.Sheet(Sheet1)
Destination -Excel.Sheet(Sheet2)

Hope it helps!!

3

@nkumarm271

If you have a data table

Excel Process scope
Use Excel file
Read range-Excel.Sheet(Sheet1)
Output Data table
Write data table to excel
Sheet 2

4

Thanks for the reply.
But I want to copy rows from A2 to last column of same row in between few columns are hidden (A2 to S2 cells are having formula).

Then I need to paste copied Rows from A2 to S2 in Row A4 to S4. When I was writing it throws above error.

I have used:

  1. Excel Process Scope:- Use Excel:- Read Range(Start Index and LastIndex - A2 to S2) - Sheet2
  2. Using Write DataTable to Excel to write

image
image1894×114 10.1 KB

5

@nkumarm271
Can you share the excel with dummy data.
So that it will be helpful to give a quick solution

Regards

6

@pravallikapaluri ,

Its difficult share the dummy sheet as the original sheet interlink with multiple sub-sheets with macro code.

Let me give try.

Thanks