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:

It's a bit more tricky, has been discussed already in the past:

1. Select the table itself, so rows and headers are displayed.

I don't get the rows and headers!

Jan Šlegr said:

Use right mouse button display Refresh context menu,

I don't get this option! See my earlier screenshot.

Jon. I have tried Help for all this but my Tables don't give me the options that help is showing. i.e no rows and headers.

I have also tried changing the symbology that that also don't work.

In the end I have has to resort to using Properties to select rows and columns to be able to change things, but this way doesn't allow me to select a single cell. Note that I can't select a cell from the table or use ctrl to select more than one. No idea what is gouing on here but my tables to act like the ones in Help!

stuartw said:

I don't get the rows and headers!

Probably because you do did not select the table (as element).

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

stuartw said:

I don't get this option! See my earlier screenshot.

I do not see any screenshot (do I miss any?) that shows table selected. I found the screenshot with right mouse button menu, but it's not "table is selected" situation.

Regards,

  Jan

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.

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.

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?