CE - Link object properties to excel

Hi everyone,

Does anyone care to help me find the best solution to link object properties into excel cells?

I believe the best way is through VBA but unfortunately I don't have spare time to learn this language, so if someone could spare some tips how I achieved this it would be great.

I already read this from Jon:

But of course I didn't manage to continue as the sample give us only the first steps. This is for the illuminated ones.

I also present the same question on programming forum but until now I didn't receive any answer. 

http://communities.bentley.com/products/programming/f/343380/t/115869

I don't want to use the new table object, because I want to use filters, and others elements in my table.

Thanks for all the help that anyone can give.

Regards

  • Yes, the link is one way process. Even if it would be possible to export data to XML we would need to do that everytime information change. I'm asking is to someone give me some light how to achieve this as is now the program using VBA or a more simplified way.

    Regards

    José

  • Unknown said:
    Information can be extracted from the drawing properties to a spreadsheet but not vice versa

    Yes: making a general-purpose two-way communications channel is hard.  Relational database technology provides this capability, but under constrained conditions that don't meet José's request.

    If you constrain your requirement, then things get easier.  For example, FlexiTable™ can be used to exchange tag data with an Excel worksheet.  The exchange is bidirectional.  However, it requires that your Excel worksheet has Excel named ranges.  The named ranges (i.e. an Excel schema) correspond to MicroStation tag data definitions (i.e.  a MicroStation schema).

    Unfortunately, few people are aware of Excel named ranges, few people are familiar with MicroStation tag definitions, and still fewer people understand both together.  Consequently, not many people are using FlexiTable's capabilities other than in highly constrained circumstances, such as drawing title blocks.

     
    Regards, Jon Summers
    LA Solutions

  • Jon I don't think I'm describing what I need in clear. I want a single way link element properties to present data in my excel spreadsheet.

    Maybe people read this and think why don't use new table element from CE and link element information on the table and then export that to excel? Well, I need to use filters. So everytime I would do a element change, my table from Microstation would update, but then I would need to export to excel and configure again everything. Too much work this way. I need to link excel cell to catch the element information that I need from Microstation. Automatically or not. If I need a button to refresh the data that would be very nice also because I wouldn't need to check every item again.

    Regards.

    José

  • We badly need a simple Import and export utility to support the new element properties provided by Item Types, if you have a project with a large number of element / member properties which are stored outwith Microstation in CSV ,or Excel files, how do you accurately transfer 16000 pieces of data into properties without error?

    Regards

    Ken
  • Unknown said:
    I need to link Excel cell to catch the element information that I need from MicroStation

    Can you provide an example of element information  in MicroStation and how you would like those data to appear in Excel?

    Unknown said:
    We badly need a simple Import and export utility to support the new element properties provided by Item Types

    • How badly do you need such a utility?
    • How do you want to store those data externally: in Excel or a database?

    Element Information vs. Item Types

    This thread has evolved and its dicussions are diverging. We now have two different topics...

    • Export element information  to Excel
    • Import/Export Item Types  data with Excel

     
    Regards, Jon Summers
    LA Solutions