List export to excel

[endison8]

Hi,
I want to export the calculation and total value to excel.

As you see, I want my first list to start from first row, but the second list wants to start from 5th row…
Any suggestions?

[leonard.moelders]

You mean like this?

[endison8]

yes, but mine didn’t work like that
I think it’s because of the layers? but I don’t know how to adjust it…

[endison8]

I tried to use the same layer as yours, but still didn’t work out

[leonard.moelders]

Your number of lists in data must match the amount of items of your sequence. 6 data lists != 5 sequence items. Furthermore none of your items in your data list should be null.

But the most important thing: Your data list structure does not match mine. Look closely

[endison8]

you mean the list.tranpose structure is not the same?
Sorry I’m not familiar to the list structure…am I able to change my list to the same structure as yours though?

[leonard.moelders]

Yes. Your 0 List should be in a seperate list itself and that for all the other lists 1 List, 2 List, …

[endison8]

I understand now…but I don’t know how to make 0 list in a seperate list…
cuz changing the list.transpose layer doesn’t seem to work?

[leonard.moelders]

Use an imperative language block to re-structure your list.

[endison8]

Oh my god it worked!!! Thank you so much!!!