Hi everyone,

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)

Got any suggestions?

Cheers,

Gianmaria

Solution

Hello Gianmaria.

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.


Solution

Nuno Reis wrote:

Hello Gianmaria.

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.


See you later, cheers.

Gianmaria

 

Nuno Reis wrote:

Hello Gianmaria.

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,

Gianmaria