Write range does not work if there are hidden columns

Help Activities
, ,
1

I have a robot that uses Write Range activity, and it was working without errors even though an excel file has hidden columns. However, after I updated packages of the robot, the Write Range raises an error:
Write Range: Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again.

Here’s the package I use for the robot.
image

and if I unhide columns it works.

Does this happen because I updated packages??

2

Hi,

I believe this is a known bug with the Excel activity and I can replicate this behaviour even in the latest preview. However it doesn’t seem to occur with the Workbook > Write Range activity.

image

Are you able to try the workbook write range activity instead?

Cheers,

1 Like
3

Hi,

The following document helps you.

There is the following note in it. So you might be able to handle it version 2.8.4 or below.

Note:

In UiPath.Excel.Activities v2.8.5 and later releases an error is thrown if you use this activity to write to a range that contains hidden rows or columns.

Regards,

1 Like
4

Thank you so much for your answer. I eventually used macro to hide/ unhide columns so the entire process looks ugly. I think I should have use Workbook write range.

5

Thank you so much for your help. This is very helpful information. If I downgrade the excel package, does it affect other packages as well?

6

I tried Workbook Write Range activity, but the file has macro, and an syntax error occurs.

I think using the macro is the best idea or degrade the excel package??

7

Hi,

If downgrade, there might be maintainability matter in long term usage. For example, even if bug is found, there is no way to fix it. So it might be better to use ReadRange and vba code for unhide/hide columns.

Regards,

1 Like
8

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