Read Excel Data when Data defined on Column wise

0
Hi All,   We have scenario like required to upload excel file in the system and extract the data which present in the sheet.  But the excel data we have little different as below,   With normal excel the data can be read with row wise where we can define which row could be Header and Value. We have couple of sheets in the same format in this case what could be the template configuration would required to get this data read and filled in the form. Can anyone help on this .   Thanks in advance.   Regards, Satya
asked
1 answers
0

You’ll need to transpose the data in the excel before uploading the file, then you can use the standard import features. If this is not possible you’ll need to implement this with java actions and the Apache POI library.

The latter option being quite a bit of effort though.

answered