New topic Closed topic
avatar image
1
Import a XLSX within a collection in a cell.
By Created , last editted

Hey,


I would like to import a XLSX file, using an Action, with in one of the cells a collection. How do I have to format this collection and how to I fetch the collection into a collection var?


See image below for examples of what I mean:


The XLSX if first imported into a temp import model to have more control of what is happening with the data. So in this example, both Name and Collection are stored in a Text property.  Then I will loop through each record in the temp import model and deal with the data one row at the time.


Hey,


I would like to import a XLSX file, using an Action, with in one of the cells a collection. How do I have to format this collection and how to I fetch the collection into a collection var?


See image below for examples of what I mean:


The XLSX if first imported into a temp import model to have more control of what is happening with the data. So in this example, both Name and Collection are stored in a Text property.  Then I will loop through each record in the temp import model and deal with the data one row at the time.

Answers
Sort by:

This topic is closed.