How can i check bottom pivot table in excel to check if Payroll Name exist?, if exist how to check if it is blank or not? if eixst then do some operations , if exist but blank then do some operations, doesnot exist then do some operations

[srilakshmi.baru]

Please clarify my question. I suppose to post this as question not sure if this is right place to post.

[ashokkarale]

@srilakshmi.baru

Try reading it using Read Range activity

Pivot to DataTable

Yes, you would use the Read Range activity to read the Excel tab that has the pivot table. [Pivot table screenshot]

[Gokul001 (Gokul Balaji)]

Hi @srilakshmi.baru

Welcome to community

• Use Read Range activity
• Indicate that Pivot result range
• Output → dtPivot
• Use Assign activity

hasPayrollName = dtPivot.AsEnumerable().
                 Any(Function(r) Not String.IsNullOrWhiteSpace(r("Payroll Name").ToString))

• Use If activity

If hasPayrollName Then
    'Logic A → Payroll Name exists (at least one row has value)
Else
    'Logic B → Payroll Name is empty for all rows

Regards,
Gokul