Excel to Microstation

Question

I'm having trouble linking Excel to Microstation. I select what I need to copy to Microstation and then I paste special as "Linked text to Design File". When it comes in, the columns and rows are not lined up. I'm also doing this in ProjectWise so the only time the spreadsheet is linked is when I have the drawing open. When I close out and come back in, it is no longer linked. 
 Does anybody have any suggestions without using AXIOM? I've attached some pictures to show what I'm talking about.

Judy Wong · Answer

This article may help > https://communities.bentley.com/products/microstation/w/microstation__wiki/23889/how-to-update-table-with-modified-contents-from-source-file

Melissa Hook · Answer

Have you tried the linked Microsoft excel worksheet option ?

Melissa Hook · Answer

To Link or Embed Another Application's Document by Pasting the Document by Its Size In the source application, select the part of the document to link and then copy it. In MicroStation, choose Edit > Paste Special. The Paste Special dialog opens. In the Data Type list box, select one of the following: — Linked

Dervalcanny · Answer

Hello, 
The following article may also help, as it describes all the methods of adding Excel information to a DGN file in MicroStation: 
 communities.bentley.com/.../the-power-of-ole-in-microstation-v8 
Regards 
Derval Canny.

Markus Eicheldinger · Answer

This question is quite old, but I found a very simple solution to this in another thread, which someone might find useful when stumbling across this post. 
 The solution is to simply copy and pastespecial every column seperately. This might be a little bit tedious to do, especially for larger tables, but hey, you only have to do it once and then all the columns will be aligned by default, plus you can adjust the spacing easily. 
 Regards, Markus

Excel to Microstation

Top Replies