topic Update Excel exported schedule in Collaboration with other software

Update Excel exported schedule

SajW — Thu, 13 Jun 2019 02:42:03 GMT

Is it possible to update a schedule which was exported to Excel? Assume that I have added an extra column to the exported excel file, so when I re-export the schedule, I do not want to loose the extra column, currently the whole excel file is updated as per my knowledge.

Re: Update Excel exported schedule

Christophe Fortineau — Thu, 13 Jun 2019 06:44:19 GMT

Hello,

Any additional changes in Excel can not be imported into AC because these changes can not be organized within the model

You must :
- create an element nomenclature from AC with one or more properties to inquire
- export the file xls from the menu File / interoperability / classification and properties
- modify only the column or columns previously created by AC
- save the xls file
- import the xls file into AC from the menu File / interoperability / classification and properties

Re: Update Excel exported schedule

SajW — Thu, 13 Jun 2019 07:01:57 GMT

Hello,

Thanks for the information.

But I do not need to import back the information, it is maintained as an external database.

Re: Update Excel exported schedule

Barry Kelly — Thu, 13 Jun 2019 07:09:23 GMT

I think you will need to save as a new Excel file from Archicad.
And then use some Excel magic to merge the new file into the original one.

Barry.