How do I make a Table from a Excel spreadsheet?

Jon Summers said:

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

With the options shown I get an empty, not editable table. The table shouldn't be empty as the spreadsheet has information in it.

Actually not quite editable. It appears that there is information there but I just can't see it because the table is white and masks all the text. How do I change this to the background colour? 

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

stuartw said:

There is nothing listed and no where to browse to find one

You could try MicroStation help.  It's been available online for several years now, in addition to being installed with MicroStation.

stuartw said:

I don't have any seeds available

Table seeds are described in MicroStation help.

stuartw said:

Don't have the option [to Refresh Table] on right mouse click

It worked for me, as described in MicroStation help.  There's also a key-in, which you will find in MicroStation help.

stuartw said:

The table is white and masks all the text. How do I change this to the background colour?

You can change the Table Symbology.

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!