How can I import data in Excel Column wise if headers are given in row wise?

0
While exporting excel I am facing one issue, we have custom export template that having headers given row wise, after exporting excel data is coming in one row for one object. we have requirement like data will export column wise for one object , can anyone help me here?
asked
1 answers
0

Create a intermediate entity with an association to a parent (may be your imported ExcelFileDocument) and Columns: FieldName, RowNumber, Data1, Data2, etc

 

Import the excel with the Excel Importer from the market place, (Create a template, just follow the procedure, set association to parent) be sure to fill the rownumber.

 

After excel has imported Loop thru the read data (retrieve over association from parent) on order of rownumber, compare the field name ('Item No', 'DPAS', etc) and process per line and fieldname.

 

 

answered