Just sharing some info I posted earlier, that may help, it is about controlling families from Excel (your outputs are txt which can be converted easily to Excel). This process allows bi-directional processing centred around the excel file. See earlier post Control Revit family via excel
I have attached some sample files, but as yet I haven’t looked into controlling hosted families and the lights in the samples are hosted families, so there is some discrepancies on the levels when extracting the family information to and from Excel. But you should get the gist of how it works.
The lesson I learnt here, was rather than trying to “Bake” families, was to handle them on separate sheets within the spreadsheet. This allows quantified processing of discrete elements. This is handled by the input “sheetName” on “Excel.ReadFromFile” and “Excel.WriteToFile”.
Of course I’m open to suggestions that improve this process.
Lights.xlsx (10.3 KB)
EXCEL-2LIGHTS.dyn (86.8 KB)
LIGHTS-2EXCEL.dyn (43.8 KB)
LIGHTS.rvt (1.4 MB)