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.
This is the Programming Forum, where people want to write code (VBA, .NET, C++). Do you fit into that category?
If you are a MicroStation user wanting to import an Excel table into MicroStation V8i, then post your question to the MicroStation Forum.
Regards, Jon Summers LA Solutions
Hi Jon Summers
I am using Microstation V8i Select series 3
Kiran Kumar Varre said:i am thinking to import data into Microstation from an excel file
Which version of MicroStation? The OP uses MicroStation V8i. If you're using a different version then the above answers may be inaccurate.
Hi Aparna Did you find any solution for this issue, recently i am thinking to import data into Microstation from an excel file. If any possibilities ?
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.
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: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!
Easy fix Jon, your link above ends in v8 whereas the original link 4 days ago contains v9. Switch the 9 for the 8 and you get this which works fine:
Place a Table from an Excel Workbook
Unknown said:Given link isn't working for me
It's not working for me, either, today!
The link should take you to MicroStation CONNECT on-line help, and topic To Place a Table from an Excel Workbook. If that still doesn't work then I suggest that you download the CONNECT installation and look at the help supplied.
Given link isn't working for me. Could you please provide a working link?