I have found someone solved this almost a year ago.I determined to learn python from then,but I found huge world to explore of Revit API.
Here’s that link which use python to solve the problem.
I really admire adn appreciate those who use python to make custome nodes and packages.There are a lot good nodes and packages I’m still learning,I decide to get familiar with them first.
A year ago I’ve build more complex script for my company,now I decide to make a simple one and share it in Youtube,hope it can help someone to show how to import data from excel and using them.
Here‘s my youtube video.