1️⃣ AutoProcessExcelPurpose

Automatically detects the header row in an Excel worksheet and converts the remaining rows into JSON.

Description

This action scans the top rows of the worksheet and determines the most likely header row using structural heuristics such as:

• Number of non-empty cells

• Absence of merged cells

• Presence of data in the following row

• Reasonable header text length

Once identified, it extracts the data rows and returns them as JSON.

2️⃣ ProcessExcelWithHeaderLocationPurpose

Processes an Excel file using a known header cell location.

Description

This action allows the caller to explicitly define the header row by providing a cell address (e.g., "A7"). The system extracts the row number from the cell reference and treats it as the header row.

3️⃣ ProcessExcelByHeaderNamesWithMinMatchPurpose

Identifies the header row only when a minimum number of headers are matched.

Description

This advanced version improves reliability by requiring a defined number of expected headers to be found in the same row.
It is ideal for complex or loosely structured Excel files.