Hi, could anyone please help me here? I have two excel files with many sheets. Originally it is old export of objects property sets with property definitions and some values. There were some values added for back import to objects in Civil 3D. In the meantime the model was updated and new exported excel exist. I am looking for solution how to merge data from older excel to new one. This should be only for rows with same Handle in first column of every sheet. Here are pictures of two excel files and the result I am looking for.
I believe there is some elegant solution for example with Python and Pandas (Merge, join, concatenate and compare — pandas 1.3.3 documentation), but I can’t learn so quickly now I tried this with Dynamo, but I can’t find solution.
D4C3D_Excel_SpojeniTabulekIndex_1.4_1.dyn (134.8 KB)
Testing Excel files
Sešit1.xlsx (8.8 KB)
Sešit2.xlsx (8.8 KB)