Import excel data to sheet set manager

Hi there,

Does anyone know, is that possible to import excel data to sheet set manager in civil 3d?

I have some data in the excel file, and want to import them to Sheet Set Manager in Civil 3D shown as attached screen capture.

I want to fill the sheet titles from excel to the sheet titles in Sheet Set Manager in Civil 3D.

Thanks inadvance.


You should be able to do this with the Sheet Set Manager package that @AdammReilly put together.

Capture

3 Likes

This is very doable, if you haven’t already figured it out I have some examples from a project I did recently. The extract dyn file will write an excel file from the sheets and custom properties. The import file will take the same excel file and write it back in to the sheet set.
Word of warning, large sheet sets can take some time to process the import, depending on the amount of data your pushing.

Extract_Sheet_Data_to_Excel.dyn (49.4 KB)
Import_Excel_to_SSM.dyn (153.3 KB)

1 Like

Hi,

I tried using the script but it’s returning a null value at the end. Any idea why or how to fix it? I’m using Civil 3D 2022 by the way.

CHECK , FILEPATH
It must be a STRING

Hi @albert.lagumbayan,

You’ll probably need to either repair Office 365 or do a full reinstall. It’s a common problem that you’ll find a lot of discussion about if you search around the forum. Another option is to use these nodes:

openxml

1 Like

Thanks @mzjensen !,

Yes i used those two as i did some searching after i posted my question. All good now!