Hi everyone,
I’ve recently imported XYZ data via Excel, in a couple of ways, and I was just wondering whether any of you can think of other ways it can be imported/organized that are worth looking into.
I’ve attached two images. One shows a node-based approach, the other uses a code-based approach.
In both cases, the 4-point lists are then used with the AdaptiveComponent.ByPoints node, to place an adaptive component with 4 adaptive points.
There’s always many ways to do something, and I’m interesting in learning new ways you could come up with.
Here’s the code:
<span style=“color: #309130;”>// Obtain Excel data for the in-place points</span>
D1 = <span style=“color: #2e998f;”>Excel</span>.<span style=“color: #417693;”>ReadFromFile</span>(data, <span style=“color: #885d3b;”>“Sheet 1”</span>, <span style=“color: #8c5eaa;”>false</span>);
D2 = <span style=“color: #2e998f;”>Excel</span>.<span style=“color: #417693;”>ReadFromFile</span>(data, <span style=“color: #885d3b;”>“Sheet 2”</span>, <span style=“color: #8c5eaa;”>false</span>);
D3 = <span style=“color: #2e998f;”>Excel</span>.<span style=“color: #417693;”>ReadFromFile</span>(data, <span style=“color: #885d3b;”>“Sheet 3”</span>, <span style=“color: #8c5eaa;”>false</span>);
D4 = <span style=“color: #2e998f;”>Excel</span>.<span style=“color: #417693;”>ReadFromFile</span>(data, <span style=“color: #885d3b;”>“Sheet 4”</span>, <span style=“color: #8c5eaa;”>false</span>);
<span style=“color: #309130;”>// Obtain Excel data for the unfolded points</span>
D6 = <span style=“color: #2e998f;”>Excel</span>.<span style=“color: #417693;”>ReadFromFile</span>(data, <span style=“color: #885d3b;”>“Sheet 6”</span>, <span style=“color: #8c5eaa;”>false</span>);
D7 = <span style=“color: #2e998f;”>Excel</span>.<span style=“color: #417693;”>ReadFromFile</span>(data, <span style=“color: #885d3b;”>“Sheet 7”</span>, <span style=“color: #8c5eaa;”>false</span>);
D8 = <span style=“color: #2e998f;”>Excel</span>.<span style=“color: #417693;”>ReadFromFile</span>(data, <span style=“color: #885d3b;”>“Sheet 8”</span>, <span style=“color: #8c5eaa;”>false</span>);
D9 = <span style=“color: #2e998f;”>Excel</span>.<span style=“color: #417693;”>ReadFromFile</span>(data, <span style=“color: #885d3b;”>“Sheet 9”</span>, <span style=“color: #8c5eaa;”>false</span>);
<span style=“color: #309130;”>// Group the points for the placement of adaptive components</span>
PtGroup1 = groupPts(getPts(D1), getPts(D2), getPts(D3), getPts(D4));
PtGroup2 = groupPts(getPts(D6), getPts(D7), getPts(D8), getPts(D9));
<span style=“color: #309130;”>// Create Points from the Excel data</span>
<span style=“color: #8c5eaa;”>def</span> getPts(list:<span style=“color: #8c5eaa;”>var</span>)
{
xyz = <span style=“color: #2e998f;”>List</span>.<span style=“color: #417693;”>Transpose</span>(list);
Pt_X = <span style=“color: #2e998f;”>List</span>.<span style=“color: #417693;”>GetItemAtIndex</span>(xyz, <span style=“color: #2585e5;”>0</span>);
Pt_Y = <span style=“color: #2e998f;”>List</span>.<span style=“color: #417693;”>GetItemAtIndex</span>(xyz, <span style=“color: #2585e5;”>1</span>);
Pt_Z = <span style=“color: #2e998f;”>List</span>.<span style=“color: #417693;”>GetItemAtIndex</span>(xyz, <span style=“color: #2585e5;”>2</span>);
Pt = <span style=“color: #2e998f;”>Point</span>.<span style=“color: #417693;”>ByCoordinates</span>(Pt_X, Pt_Y, Pt_Z);
<span style=“color: #8c5eaa;”>return</span> = Pt;
};
<span style=“color: #309130;”>// Group Points by transposing lists</span>
<span style=“color: #8c5eaa;”>def</span> groupPts(a:<span style=“color: #2e998f;”>Point</span>, b:<span style=“color: #2e998f;”>Point</span>, c:<span style=“color: #2e998f;”>Point</span>, d:<span style=“color: #2e998f;”>Point</span>)
{
list = <span style=“color: #2e998f;”>List</span>.<span style=“color: #417693;”>Transpose</span>({b, c, d, a});
<span style=“color: #8c5eaa;”>return</span> = list;
};