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!
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.
Happy Automation 
Best Regards
Er Pratik Wavhal 
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
So what happen if column names are not der
We can do it by using Index.
Happy Automation
Best Regards
Er Pratik Wavhal
@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:
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)
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 :-
Output :-
Mark this as solution and Like it
Happy Automation
Best Regards
Er Pratik Wavhal
@ppr This is what i was not getting. Thank you very much!!
Thank you @Pratik_Wavhal !! This is working pretty well.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.