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 Reply Children
  • Unknown said:
    your link above ends in v8 whereas the original link 4 days ago contains v9

    What else do you do in your spare time?   Thanks for spotting that!

     
    Regards, Jon Summers
    LA Solutions

  • ce still has the same draw back with excel updates as previous versions in that they are not automatic I know we can key in TABLE REFRESH ALL.

    but  couldnt that be a variable option in configs or run as a macro on start up... if one is going to link an excel from external source then you want it autorefresh when you open mstn. no after  you  open msnt. if you dont want that then you dont link it  you embed it like old school pre CE..FYI  the auto update has never worked from first version msn had it  listed as an option .. nice to see it still doesnt work in in CE...

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

  • Unknown said:
    CE still has the same draw back with Excel updates as previous versions in that they are not automatic

    Perhaps you missed Paul's earlier comment?

    Unknown said:
    You can optionally retain a link back from the table to the worksheet, in which case the table can be updated when the contents of the worksheet change.

    Unknown said:
    If you dont want that then you dont link it you embed it

    CONNECT tables are real tables, made from DGN elements.  They are not embedded images of a foreign worksheet.  It would be a good idea for you to test the table feature in MicroStation CONNECT.  Then let us know what it does and doesn't do compared to earlier versions of MicroStation.

     
    Regards, Jon Summers
    LA Solutions