How to get empty rows from the excel

[mkankatala (Mahesh Kankatala)]

Hi @Taruna_Gupta

Check the below thread for better understanding

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!

Hope it helps!!