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!
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.
Jon. I have tried Help for all this but my Tables don't give me the options that help is showing. i.e no rows and headers.
I have also tried changing the symbology that that also don't work.
In the end I have has to resort to using Properties to select rows and columns to be able to change things, but this way doesn't allow me to select a single cell. Note that I can't select a cell from the table or use ctrl to select more than one. No idea what is gouing on here but my tables to act like the ones in Help!