Write to Excel


#1

Hi all

I have a problem writing a list to specific keys in Excel.

The behavior I get is that the full list (4 values) is written to all the rows in excel that I have defined.

In my case, I like to write the first value from list into the first row. Then second value from list into the second row etc.

I tried different List.Map solutions combined with the Write to Excel node without any luck.

/Jesper WallaertWrite to excel 2

 

 


#2

Hello Jesper,

I think you’ll only need to give the first row you want to start on, as for the column. It should write the data row by row.

test


#3

Hi Jostein

The Excel.WriteToFile node can handle when u specify multiple rows. See picture the picture 1

Write to Excel 3

 

 

 

However, when I am adding a list to the data input its writes the full list for every row. Visualized in picture 2 by writing to Columns instead.

Write to excel 4

 

 

 

 

My goal is to control the rows I am writing to and only adding one value from my list to one row from top to bottom.

BTW I am counting the days to become Sweco employee


#4

Hi Jesper,

I think your looking for this:

Excel1


#5

Hi Jesper.

I dont know why its behaving like that, but have you tried using “bumblebee”?
It seems alot stronger?

Theres a great guide to the pacekage at the archi-lab website

Excel write to fileExcel


#6

Hi Kulkul

This is the exact behavior I am looking for:

I think your solution is close but I had no luck converting it.

Write to excel 5

 


#7

Below is the graph and dynamo file for your reference. Good Luck!

Excel

excel