Wildcard XLSX input tool giving the header names in ROW 1

Question

I'm using wildcard xlsx input tool to read multiple tabs from an excel file. The issue that I'm facing is that the output from macro has incorrect header names....F1,F2,F3 and so on. The header values are displayed in row 1. When I uncheck the option of row containing headers then it does not help. Any idea on how I can solve for this?

Felipe_Ribeir0 · Answer

Hi @Idyllic_Data_Geek

It worked?

Felipe_Ribeir0 · Answer

Hi @Idyllic_Data_Geek

I downloaded the tool and tested it here, for me the header is working fine. Take a look at the attached workflow.

xlsx_test.yxzp

Idyllic_Data_Geek · Answer

This is what I have