karakasa/PancakeSpreadsheet

Generate data in multiple cells?

Closed this issue · 2 comments

Hi. Please can you provide a sample on how I can pass the information from Grasshopper tree into "Set Multiple Cells" component because seems that nothing that I tried works.

I do have a list with branches that contains 5 indices like this:

Pancake_Sheet_create_multiple_cells

The 5th element it's a separator. It is a long list and I do need to split in multiple columns to fit an A4 page paper into the xlsx file. Basically I want to create an excel spreadheet to feed all this information and create some labels.

I want to split the content in three or four colums to fit the content into the cells like in this page template:

@zohozer

If I understand correctly, you want an Excel file like this:

image

Now there's a bug that Set Multiple Cells requires a calculated cell range, i.e., you must specify the entire area to set, instead of the left-top corner only.

label_gh.zip

1

image

Thank you very much. Exactly what I needed.