Creating Excel Documents with renamed sheets based on information in Revit

Revit
,
1

Hi All,

Currently, I have around 20 sheets each with around 4-5 schedules on them, I’ve been tasked with putting this information into excel.

I understand how to write to excel and read data so once the Spreadsheets are created with the sheets I should be okay.

The plan is that each Sheet in Revit is going to have its own excel document and each schedule on that sheet will have it on excel sheet.

I was hoping there is a way I can take the sheet and schedules names and create excel documents with this naming convention. I’ve put a screenshot below to try and give an example.

Then its just a case of inputting the information.

Any help or suggestions on how to tackle this would be great

Thanks

image
image.png1530×901 81.8 KB

2

You just need to have the correct list structure.

For a single file with a single sheet your list structure would be:

  • 1D Path
  • 1D Sheet Name
  • 3D Data

For a single file with multiple sheets your list structure would be:

  • 1D Path
  • 2D Sheet Name
  • 4D Data

For multiple files with multiple sheets your list structure would be:

  • 2D Path
  • 3D Sheet Name
  • 5D Data
2 Likes
3

Thanks!