In an Excel data table like the following
Get first free column/row from Excel Worksheet] will not count well if there is a blank string.
So I used [Substract lists] in Winautomation to count the number of lines, excluding the blank strings.
This will give me the correct number of rows.
If I do the same thing with PAD, [Substract lists] will do Distinct processing at the same time.
I can't get the correct row count anymore.
I don't want it to work differently from WinAutomation.
Please fix this.
Thanks for the reply.
I tried saving the Excel file as csv.
But the solution seems to be difficult.
I have converted the RPA Challenge Excel file to csv.
The ghost cells remain.
http://www.rpachallenge.com/
It is also possible to count with regularized expressions and looping.
But it is slow.
I am now trying a python script action.
Hi,
You are right, it does not work as expected with Get first free column/row from Excel. So, I have used Read from CSV file to solve this problem for my flow instead of waiting for MS to fix it.
Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional