Importing Excel data into Microstation

Hi,

I want to build an application that imports data into MicroStation from an excel file. The data should be imported  in the form of MicroStation elements(not as an image like in case of Paste/Special Paste). The data should maintain to the input excel,so that if there are any updates in the input file, they are reflected back into MicroStation.

Please do not suggest any related Product.

Any help is appreciated!

Thanks.

Parents
  • Unknown said:
    I want to build an application that imports data into MicroStation from an Excel file.   If there are any updates in the input file, they are reflected back into MicroStation

    That's hard.  You need to code something in Excel that creates an event in MicroStation.  Alternatively, an observer in MicroStation that reacts to changes in the specified workbook file.  How do you propose to achieve that?

    You've tagged your post in way that indicates you're planning to use a .NET API with MicroStation V8i.  Be aware that that version of MicroStation doesn't really have a .NET API.  You can, for example, write C# code that calls the MicroStation VBA COM server via a .NET InterOp. That doesn't get around the fact that you will be using VBA, which has no provision for interprocess communication (with Excel or anything else) and no way of monitoring an external file.

    You've also added a tag ConvertToGraphicCell, which doesn't seem to have much bearing on your question.  Perhaps you would like to clarify what you're asking.

     
    Regards, Jon Summers
    LA Solutions

Reply
  • Unknown said:
    I want to build an application that imports data into MicroStation from an Excel file.   If there are any updates in the input file, they are reflected back into MicroStation

    That's hard.  You need to code something in Excel that creates an event in MicroStation.  Alternatively, an observer in MicroStation that reacts to changes in the specified workbook file.  How do you propose to achieve that?

    You've tagged your post in way that indicates you're planning to use a .NET API with MicroStation V8i.  Be aware that that version of MicroStation doesn't really have a .NET API.  You can, for example, write C# code that calls the MicroStation VBA COM server via a .NET InterOp. That doesn't get around the fact that you will be using VBA, which has no provision for interprocess communication (with Excel or anything else) and no way of monitoring an external file.

    You've also added a tag ConvertToGraphicCell, which doesn't seem to have much bearing on your question.  Perhaps you would like to clarify what you're asking.

     
    Regards, Jon Summers
    LA Solutions

Children