How do I make a Table from a Excel spreadsheet?

Using the "Place Table" tool set to from excel file:

For a detailed description of each tool setting see the following information.

I tried that but all I got was a table that linked to the spreadsheet, which by the way, didn't update when updating the spreadsheet. The table also wasn't editable in CE. I could pick it but do nothing else with it.

How do I just place (copy) the spreadsheet into the file without the link. 

Jan Šlegr said:

What will happen when you use normal Element Selection tool to add the table to selection set?

What is the normal Selection Tool. I am using this one to select the Table but still no rows and headers.

Hi Stuart,

stuartw said:

I am using this one to select the Table but still no rows and headers.

Hmmm ... I have no idea what can be wrong :-(

Can you share your file?

A few more ideas:

• Is the element table (element type displayed in tooltip is Table)?
  
• Is the table the only selected element (there is one element in selection set, not more)?
• Is "table context" tab Table Tools / Layout displayed in ribbon?
  

With regards,

  Jan

Jan Šlegr said:

Can you share your file?

File attached. This is my DGNLIB which I'm trying to make a templateFloor_Area_Schedule.dgnlib of. 

Note that is not from an excel file as I've gone back top basics to crate one from scratch.

Jan Šlegr said:

Is "table context" tab Table Tools / Layout displayed in ribbon?

Yes but no rows or headers

Hi Stuart,

stuartw said:

What is the normal Selection Tool. I am using this one to select the Table but still no rows and headers.

You don't get to see rows and headers because in your Element Selection you have Disabled Handles (like read only) object turned on.

Hope this helps and regards.

Hi Stuart,

stuartw said:

What is the normal Selection Tool. I am using this one to select the Table but still no rows and headers.

You don't get to see rows and headers because in your Element Selection you have Disabled Handles (like read only) object turned on.

Hope this helps and regards.

Jose Pinho said:

You don't get to see rows and headers because in your Element Selection you have Disabled Handles (like read onl) object turned on.

That's correct because i don't use them. Thanks Jose, that solved the problem but  Bentley where in Help does it say that these need to be turned on?

Jose Pinho said:

You don't get to see rows and headers because in your Element Selection you have Disabled Handles (like read only) object turned on.

Wow, did not know about this feature! ... and I have handles displayed on alwyas. Always something new to learn ;-)

Regards,

  Jan

But you shouldn't need to have handles enabled to allowed Tables to work correctly.

Bentley - Any chance you can fix this. Think I will file an ST. 

stuartw said:

But you shouldn't need to have handles enabled to allowed Tables to work correctly.

I do not usually switch off handles, so I had to test how MicroStation behaves when the handles are not visible and it would be valuable to create a list what features are now treated as handles. I found:

• Traditional handles displayed at element vertices
• Table handles
• Tool widgets handles used to modify e.g. cut plane etc.
• 3D element handles used to access parametric modeling features for selected element

Maybe there are some more, displayed in specific situations. Anyway, to use handles to edit table element seems to be consistent with common concept when to display addition tools to modify the selected element.

With regards,

  Jan

Defect 1005408 has been filed to have this addressed. Thanks for reporting.