Using CE 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.
Regards, Jon Summers LA Solutions
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.