Detect if excel has header


#1

Hi all,

The question might not be directly related to UiPath. However, I need to detect if there is a header in the excel file. The most preferred method would be to use macro, but I’m not very good at VBA. Tried to search online for an answer but couldn’t find what I wanted.

Here’s an Example of the header.

I would like excel to automatically detect the header. Via the sort, and check whether “My Data Has Headers” has been checked.

image

Thanks all