For Each Excel Row not skipping blank rows

Feedback StudioX
,
1

Hello,

I am running StudioX on version 2024.10.6. I built and published an automation about around a few months ago on an older version of StudioX (I don’t know how to see which version this published version is on). The published automation from that older version of StudioX works perfectly. However, I wanted to add some features to the program, but when I open the automation in StudioX through the .json file now, it does not work the same. I have not made any changes yet to when I originally published the program a few months ago. The program enters numbers from an excel table into an application. I do this by using the For Each Excel Row activity. I have the “Empty Row Behavior” option set to Skip. However, when I run it up in this new version, it is not skipping the row and is instead trying to enter in the blank rows. The excel table it is pulling from has not changed. The excel table does have a formula in every row in a column to sum up the row, but the formula will display as blank if there is no other corresponding data in the row. I believe that is what is causing the problem now. The old published version will skip the row, but the new version does not. I did discover if I unprotect the excel sheet it will work as expected and skip the blank rows, however if the sheet is protected, it will not skip the blank rows. The older version will skip the blank rows regardless if the sheet is protected or not. Is this working as intended or is this a bug in the new version? Is there a way I can get around this? I tried getting around it by having the automation unprotect the sheet before it starts, however, the sheet cannot have a password, and the Unprotect Sheet Excel activity will give an error if you do not have a password. Also, I would prefer not to have to unprotect and re-protect the sheet anyways.

Thank you!

4

Hey @Zach ,

I have a couple of follow up questions to help us investigate this further:

  • Have there been changes to the Excel version when working on this version?
  • Would you be able to share the Excel version currently on the project?
  • Is it possible to also share with us a sample project repro’ing this new behavior you are seeing right now?

Many thanks,
Raluca

6

  • Have there been changes to the Excel version when working on this version?
    I’m not sure what version the published version that works is on, but the new version was running on 2.23.4, I updated to 2.24.3 and the issue is still the same.

  • Would you be able to share the Excel version currently on the project?

The Excel sheet is Version 2410. The UiPath.Excel.Activities is 2.24.3

  • Is it possible to also share with us a sample project repro’ing this new behavior you are seeing right now?

I’m not sure how to do that. The program I enter the data into is local and I don’t have access to any part of the program except the screen to enter the numbers. Here is a screenshot of it entering the data from the excel sheet.

image
image1591×838 58.2 KB

If there’s something else I can add please let me know.