I created an algorithm to allow me to update our Excel drawing register so that it always contains the latest drawing sheets created in Revit. The Excel spreadsheet needs to display the following drawing sheet information:
- sheet number
- sheet name
- paper size/drawing size (A1, A2, A3, etc)
I had no problem with items “sheet name” and “sheet number” as they are sheet parameters and it was quite easy to get them from Revit.
My problem is with scale and paper size.
I couldn’t work out how to extract the paper size and the problem with the scale is that it does not display the way in should in Excel such as 1:100. it displays as a division of 1 and 100.
Thanks a lot for your help.