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. 

stuartw said:

The table also wasn't editable in CE

I used the table tool with MicroStation Update 11.  It successfully created a DGN table.  I can edit the table...

Make sure that you use an appropriate table seed, which is described in MicroStation help.

stuartw said:

I got a table that linked to the spreadsheet, which didn't update when updating the spreadsheet

Do Bentley Systems claim that an associated table updates automatically?  Try modifying the worksheet in Excel, then save the file in Excel, then refresh the table in MicroStation.

stuartw said:

How do I just place the spreadsheet into the file without the link?

I think you're looking for the Association option in the Place Table dialog when you choose to import from Excel.

Jon Summers said:

Make sure that you use an appropriate table seed, which is described in MicroStation help

I don't have any seeds available. There is nothing listed and no where to browse to find one!

Jon Summers said:

Do Bentley Systems claim that an associated table updates automatically?  Try modifying the worksheet in Excel, then save the file in Excel, then refresh the table in MicroStation.

Tried that but don't have the option on right mouse click.

Jon Summers said:

Do Bentley Systems claim that an associated table updates automatically?  Try modifying the worksheet in Excel, then save the file in Excel, then refresh the table in MicroStation.

Tried that but don't have the option on right mouse click.

Hi Stuart,

stuartw said:

I don't have any seeds available.

In my opinion it's fine, I have also None displayed and I am able to create table from Excel sheet without any problem.

stuartw said:

Tried that but don't have the option on right mouse click

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

1. Select the table itself, so rows and headers are displayed.
2. Use right mouse button display Refresh context menu, it can be used at upper left corner (refresh option is the only displayed) or at any table cell (refresh displayed as the last menu option).

With regards,

  Jan

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.

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.