RE: Placing table from Excel

Question

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.

Jon Summers · Answer

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. 
 Table Seed 
 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.

RE: Placing table from Excel

Top Replies