Data import via excel importer

Hello everyone, I have a requirement in project where I need to import data from excel sheet with format as xlsx and want to convert it into cvs format but the data that I am importing is not consistent. A first few rows contain some data in form of description and after few rows its in the proper row and column format. Below is the example of excel sheet in xslx format.Is it possible to import data directly into mendix like this?
1 answers


You could create an entity to be used for importing all of the data in the spreadsheet with enough attributes to accomodate all of the columns in the spreadsheet.  You would need to make the attributes in this entity of type string. 


Once you import the raw data, you would then need a microflow to process/parse the information in this table into the correct entities in your app.

Hope that helps,