I was asked by a team member If I cold create a script that would produce some programing block from an excel spreadsheet. In short, 3D generic models are produced from an architectural program in Excel. The script works great when producing the first round of blocks. What I am really struggling with is pushing updates from the spreadsheet to the newly created blocks. The script will completely rewrite the blocks when trying make changes via the spreadsheet.
for instance, if the blocks were moved after the initial creation, to start organizing spaces in 3D, and the script was rerun to make adjustments to the areas, names, etc, the blocks get regenerated back in their original locations, like shown in the picture below. This obviously does not work for space planning if the blocks keep getting moved back to their starting places.
Has anyone dealt with this problem in the past? I have search but keep coming up empty handed.
Any help would be appreciaited