Check empty cells in Excel rows

Hello,

How can I check for empty cells in an excel sheet that does not have the usual Table format?
I have an excel file that instead of columns it comes in a “row format”, being the first column the names of each row.
I need to identify the empty cells (Cells C7 and E8) in rows 6 to 9.
How can this be done? What should be the logic behind if it is not a table format?
output.xlsx (8.5 KB)

Thank you in advance!

Hi @andres.santos

For checking empty cells you can use below format
row(“yourcolumnname”) = String.Empty

Hope this help you to solve your query.
Make as a solution and like it if it helps you.:slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

Hi @Pratik_Wavhal,

Sorry but I do not get how can I apply that format to my problem. I understand the format, the problem is that there are no column names, if you check the output.xlsx file you will see that the format is not a table format, hence the issue.

Best,
Andrés

Hi @andres.santos

So what happen if column names are not der

We can do it by using Index.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

@andres.santos
have a look here
andres.santos.xaml (7.8 KB)

when flag off add Headers the excel is readin with autogenerated columnames and is not failing on duplicated col names

Demo is logging the 0-based row and col index for blank column values:
grafik

just take it as starter help

for getting the Excel Cell range:
row Index + 1
for the column letter (simple solution done by workarounds or)

1 Like

Hi @andres.santos

I have created the workflow for the same. It is giving accurate output where it gets the empty cell and meet all your requirements.

Below is the workflow attached :-
Main.xaml (14.2 KB)

Input :-
image

Output :-
image

image

image

image

image

image

image

Mark this as solution and Like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

@ppr This is what i was not getting. Thank you very much!!

Thank you @Pratik_Wavhal !! This is working pretty well.

Hi @andres.santos

Your are welcome :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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