File Transfer to Excel

Since asking endless rookie questions months ago I completed a Grasshopper training course so I should not have so hopefully my list of silly questions wil reduce.

The last part of the course touched on transferring data between excel and grasshopper. I am currently re-creating our Tekla roles to eliminate all of the Tekla defaults we have never used since we first started with Tekla in 2007. I would like to collect all the file names from a number of folders so I can easily see if I need to keep them or remove them. I have a file below where I have found all the file names from a folder, and formatted it into 350 branches each with 4 items. I have imported a flattened version into excel, and that works fine, but I cannot get the data to import into separate columns. Any suggestion why?

2025_Forum-Q.gh (16.5 KB)

As I was doing this I was wondering if I could use Grasshopper to create all the files I want for different profiles in Tekla? I am creating roles for both myself and a client that will need different names. This would save a lot of time and allow us the flexibility to change later as well.

Thank you

Hi Brad,

Three things missing to make it work.

  1. One more heading needed to match the numbers of branches
  2. Flip the data tree, one branch per column instead of one branch per row like you had.
  3. Replace null values with something, blank space is what I used.

Yes you can recreate the standard files from GH. But I won’t give away all my trade secrets and show you how :smiley:

Hope this helps!

Flip matrix, I should have thought of that. The missing column was silly.

I only needed to know it was possible to create the standard files. I will look some more. I know how to drive the tekla model using the attribute components, but I did not see the saved file name anywhere yet.

Thanks for the help.
Brad

1 Like

It turned out I had incorrectly inserted nulls before I internalized the data. It all works now.

The Tekla file creation is actually quite simple once it was suggested to simply import the text file and manipulate the lines of text needed. I knew these were simple text files, but did not think how easy it would be to import and edit them. I had to write a script to export the data using Python. It all works now for beams, and the same process can be used for other Tekla text files. I posted a screen grab of the script below if anyone is interested.

1 Like