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 )
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.