I have just spent the last 2 hours trying to insert a very very very standardly formatted excel table - just some text and bordered cells - not very big either.
Admittedly, this is the first time I have tried this, using CONNECT and its vaunted "Place Table" tool (using the 'From File' option). I guess when I started this I thought it would be pretty straight forward. My fault for making that assumption.
What I wanted was to just insert my relatively straight forward excel table on to my design plane and have it look like the one in my spreadsheet.
Split this question from the original discussion as it was quite old and separate from the original questions.
Placing table from Excel
It is always helpful for you to provide the version of MicroStation CONNECT Edition that you are currently using as this may make a difference to any answers provided.
MicroStation Forum best practices
It would also be helpful if you could provide details for the issues that you've encountered which might include example files or any error messages.
RegardsAndrew BellTechnical SupportBentley Systems
There have been several discussions about tables and table seeds...You may find some helpful information with a search here.
But my takeaway is that it is never as easy as it sounds, and still a bit buggy (depending what you intend to do).
MaryB
Power GeoPak 08.11.09.918Power InRoads 08.11.09.918OpenRoads Designer 2021 R2
The place table tool is for creating a new table.
If you just want to insert (cut-and-paste) a table from excel (embedded or linked) you open it with EXCEL, mark the area that you want to insert and copy (eg. CTRL-C).
Then in microStation do insert (eg. rightclick>Paste) In the following dialog you decide how to insert that "OLE-Object"
Works well for me. Is available since many years.
The place table tool is rather a challenge. (I also got stuck there)
Richard Tarntino said:What I wanted was to just insert my relatively straight forward excel table on to my design plane and have it look like the one in my spreadsheet.
Yes, and one option lets you place a table using the data in an Excel workbook or .csv file...
Key-in: PLACE TABLE FILE [ file ] [ worksheet ] [ range ]
launches the Place Table tool in the From file mode. If the file that includes the file path is invalid, the tool starts in From file mode with file set to None. If file is a CSV file, then worksheet and Range are ignored. If file is an Excel file and worksheet is missing or invalid, the default worksheet is selected. If file is an Excel file and range is missing or invalid, populated range is used. Named ranges are supported. Standard range format like A1:D5 is also supported.
It's important to adjust the Seed choice.
If you select to place a table from a Microsoft Excel file, you get an option "From Excel" in this drop-down list. If you select it, MicroStation attempts to preserve the formatting such as colors, borders, text direction, text justification, fonts, font styles, font sizes, row/column/cell sizes, and cell margins.
When you choose Seed from Excel, does MicroStation create a table with the appearance you want? If not, please post an example Excel file for someone to try.
Regards, Jon Summers LA Solutions
The given seeds did not work with my files (?) I have not yet digged in and tried to create my own seeds.
With Seed: none sometimes it seems to not come to an end.
A smaller xls work fine.