How to get rid of null?

Data in excel is limited however in dynamo it appears upto column 5 and row 10. What should I do?

Null values are present when parameters are not populated.

Use the List.Clean node on your data before exporting, or convert your ‘null’ value to a suitable placeholder.


That is really weird, could you share your Excel file? I have never had this problem, maybe try creating a new Excel file. (Just like Ewan said, a list.clean node would also work just fine :slight_smile: )

1 Like

Simply delete the unwanted row\columns on excel. I mean not clear the values, but select the columns (letters above cells) and hit delete on the main ribbon tab. This will avoid to import into dynamo empty cells.