Spaces in excel headers
Application Type
Traditional Web
Service Studio Version
11.10.12 (Build 39237)

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?

mvp_badge
MVP

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.


Structure.JPG

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.