Excel in Grasshopper: WIP

anon39580149 · March 6, 2022, 8:01pm

To open, edit, create and save xlsx | csv files

Using ReoGrid

julian.riise · March 6, 2022, 8:51pm

That looks awesome! Could this be used for documentation purposes on say a small/medium architecture project?

anon39580149 · March 6, 2022, 9:41pm

Hi, it is as describes to open ,edit create and save but not all excel functions.
Maybe you find it useful after testing, i will add it to Fennec Addon soon

anon39580149 · March 7, 2022, 4:20am

Adding some buttons: Copy, Paste, Select All, Clear

nathanletwory · March 7, 2022, 6:04am

When you open your CSV file where you have added four values to the second column before saving these four values show up on the third column…

anon39580149 · March 7, 2022, 6:22am

Hi @nathanletwory
I will check it , maybe this is a bug

anon39580149 · March 7, 2022, 7:27am

Thanks @nathanletwory , i test it again and the same error
I think this is a bug , i will contact the developer about it
The same error in their editor:

nathanletwory · March 7, 2022, 7:40am

Looks like there are two bugs according to your screenshot:

The shift of values from B to C, but also the empty row 2 is missing on the right.

anon39580149 · March 7, 2022, 7:54am

Yes , i hope they fix that
From their website saving to csv is not possible but they have another method to export.
Maybe i will disable this and use regular csv export in ironpython

anon39580149 · March 7, 2022, 10:21am

anon39580149 · March 8, 2022, 2:00am

Some options added: Merge, Unmerge, Borders… and input to create excel file.
We can add many sheets to the same files with different datas.

anon39580149 · March 8, 2022, 10:12am

Some options added

anon39580149 · March 9, 2022, 6:43am

Hi
I try to convert the form to a component but i don’t find the right way.
Any help is very appreciated

anon39580149 · March 10, 2022, 7:18pm

When i use: form.Show(Grasshopper.Instances.ActiveCanvas)
I cant add values when navigating in the table (like in excel)
Using: form.ShowDialog() solve the problem but the can’t use Grasshopper in this case
Is there a way to use ShowDialog like Show(Grasshopper.Instances.ActiveCanvas)

anon39580149 · March 11, 2022, 12:22am

For now this work fine:

form.Show(Grasshopper.Instances.ActiveCanvas)
Application.Run()

lignindes · March 11, 2022, 4:58am

Hello,

When do you think you’ll add this to Fennec?

Dan

anon39580149 · March 11, 2022, 5:11am

Hi
Until i can compile it to ghpy component, right now i don’t find a way.

anon39580149 · March 11, 2022, 9:18am

More options added:

Switching between edit mode and read-only.
Disable and enable receiving data from Grasshopper.
Two lists of colors (long and short).
Formulas can created with strings from Grasshopper.
Border sides.
Create and edit different sheets on the same file and every sheet can receive different data from Grasshopper.