I'm trying to import a Non linear excel like the one attached, but I can't actually figure out how to do it; also changing the excel to a linear one is not an option (that would be easy to achieve as I can use the "Excel to Record List" default widget)

The ExcelToRecordLsit is for Excel files that are lists.

If your scenario is exactly this (one answer each file) you can import as a binary and use Excel manipulation libraries (Advanced Excel for instance) to get the content of specific cells.

The ExcelToRecordLsit is for Excel files that are lists.

If your scenario is exactly this (one answer each file) you can import as a binary and use Excel manipulation libraries (Advanced Excel for instance) to get the content of specific cells.

Hello Nuno,

thanks for the quick reply. I'll try your solution in a new oml and see if I can work this out. I hope to come back here asap to mark your answer as solution.

The ExcelToRecordLsit is for Excel files that are lists.

If your scenario is exactly this (one answer each file) you can import as a binary and use Excel manipulation libraries (Advanced Excel for instance) to get the content of specific cells.

Thanks Nuno,

now I know how to proceed. Thank you again, cheers,