Im scripting to create sheets from an excel template, to Revit with some conditions; and also write filtered parameters to sheets.
The condition is this:
If excel cell of the I column is empty don’t extract all the information that excel contains. So don’t create a sheets if I is empty.
Example: https://imgur.com/a/Hhv6j
Now im with this: (Upper is correct I think, down side just for tests)
Yes,is that but not for a any value is empty in any column, only empty values in the column “i”.
So I’m extracting all the information from excel and each column is in a indexed list.
USING THE IMAGE
The values from the index number 3 have empty values, I want to remove all the empty values (3.2) on this sublist, and then, remove also the same subindex values in the other index list (X.2).
I’m still not sure if it’s necessary to remove these nulls though. You’ll have to explain your reasoning so we can get a better idea of what the issue is. There might be a better workflow.
Objectives: I have an excel template to create sheets for a project.
Now: By the moment we use the schedules to replace the excel and make a sheet scope.
Idea: Use the template to create the sheets with dynamo. I have this sample. I want to read all the rows from my excel that have content in the M column. if any cell of the M column is empty, the row is not necessary because this are a titles not sheets.
@xavierderos this is similar to what @Nick_Boyts showed above, but uses a custom node from the DanEDU Dynamo package to find the indices of nulls in the sublists and eliminates the need for the Object.IsNull node
