I have the need to create a script that would accomplish the following:
Refer to an excel spreadsheet that would have values of Revit categories in one column, and in the other column a workset name
Then in Revit I would need to create the worksets contained in the excel file
After that, I would need to change the workset of all elements in each category listed to the workset name that corresponds in the column next to it in the excel file.
I know this is crazy, but its a client requirement in one of our large overseas projects. As far as I can see the API does not allow the creation of worksets, only reading ones that already exist. I am just checking here first to see if anyone has a workaround or different way to tackle this problem. I am new at programming so the API and Python are kind of beyond reach at the moment.