Log in to AnswerLog in to Follow
Donny Visser
10Views
1Comments
Spaces in excel headers
Question
Import/Export Data
Traditional Web
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?

0
0
on 5th Mar
Kilian Hekhuis
mvp_badge
MVP

You can't with the standard ExcelToRecordList. You may want to take a look at the Advanced Excel Forge component.

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