Hi,
From a client i get an excel file, weekly. I want to import that into a application with an upload button. But in the excel file some headers have spaces. I know i should match them with the entity/structure attribute names, but i can't put spaces there. And I don't want to edit the excel file every week either. The columns of the excel file stay the same every week.
How can I make this work?
You can't with the standard ExcelToRecordList. You may want to take a look at the Advanced Excel Forge component.
Hi, Donny Visser
In you structure attribute you can change the label for what you need to show in the header of the excel file.