Placing table from Excel

Warren

if you preview the table in MS (within the reports tool) do you see the populated data!.  maybe the formatting isn't correct and its not actually doing anything.

I realised that the text height in the text field was incredibly small. Increasing it to a proper size actually worked, but it's going to be a pain if we have to manually edit all the cells. It looks like the Place Table tool doesn't like text below a certain size...

Just a thought.. see if the text is linked to Annotation Scale..  Try using the Annotation scale ie 1:100.  If you do not know where this is.  Press Cntl C and look for Drawing Scale

Sorry its Cntl T

Having Selected the Place Table tool, In the Tool Settings it is possible to select a predefined Text Style to use, this Text Style will then be used for the text.

https://communities.bentley.com/products/microstation/w/microstation__wiki/23888/how-to-control-the-size-of-initial-table-placement

If you have a Table Seed defined with all the formatting required this can also be selected in the Tool Settings, note this will override the Text Style setting if used. Thus if placing Tables of a standard format you may want to consider creating Table Seeds.

https://communities.bentley.com/products/microstation/w/microstation__wiki/32363/how-to-create-table-seed-that-can-be-placed-as-a-template-into-any-design

As you have found you can change the height individually by double clicking in each cell and changing the height in the Text Editor. Alternatively if you right click on the Table itself ( Not a specific cell ) and select Properties, you can set the Text Style to be used.

Having Selected the Place Table tool, In the Tool Settings it is possible to select a predefined Text Style to use, this Text Style will then be used for the text.

https://communities.bentley.com/products/microstation/w/microstation__wiki/23888/how-to-control-the-size-of-initial-table-placement

If you have a Table Seed defined with all the formatting required this can also be selected in the Tool Settings, note this will override the Text Style setting if used. Thus if placing Tables of a standard format you may want to consider creating Table Seeds.

https://communities.bentley.com/products/microstation/w/microstation__wiki/32363/how-to-create-table-seed-that-can-be-placed-as-a-template-into-any-design

As you have found you can change the height individually by double clicking in each cell and changing the height in the Text Editor. Alternatively if you right click on the Table itself ( Not a specific cell ) and select Properties, you can set the Text Style to be used.

Hi Carl

Thanks for the response. I've created a different query about this in the past:

https://communities.bentley.com/products/microstation/f/microstation-forum/138252/using-table-seeds-with-excel-data

The problem that I found is that the table seeds work brilliantly, but not when importing Excel data to populate the table seed. The screenshots in the above post show what happens. Could it be because I have several different text styles in the same Excel data/ table seed?

I've tested this out with a table seed I created for the same data in OpenRoads Designer Update 4. This is the result - the table on the left is the table seed placed normally, the table on the right is the table seed placed with Excel data:

Sorry for the delay in responding further, I have been able to reproduce and Defect 937783 has been filed, it should respect the selected Table seeds formatting.

Just curious Carl, how's the OLE technology in Connect with Excel? Nice to link Excel sheets right to Microstation sheets, we certainly waited a long time before it got "good" in v8i. Haven't tried it since I started using this buggy Connect (r10).

Bob OLE technology may be an alternative option to using Tables for bring Excel data into your designs, if you find issues with OLE or other areas please raise a new forum post or Service Request for investigation. Thanks.