MicroStation supports script files, which are simply ASCII files with one valid keyin on eack line. You can send datapoints to MicroStation using the keyin XY=x-coordinate,y-coordinate,optional-z-coordinate and I often create a formula column in a spreadsheet to combine adjacent columns into valid keyins. For example, if you had three columns AB & C with x, y and "some text string" in row1 and wanted to place the "some text string" at coordinate x,y in Excel, you could enter the following formula:
="set parseall on;/ptext;"&C1&";xy="&TRIM(A1)&","&TRIM(B1)&";null"
If you have a whole column of data, simply copy the formula down to the end of the data.
Then selact the column of the formula and copy and paste it into notepad and save the file.
Then in MicroStation, set your text attributes and keyin:
@full_path_to_script_file
substituting the actual full path filename.
"Magic" wrote:
Has anyone had experience placing text from a column at coordinates X,Y in adjacent columns Text,X,Y I have a spreadsheet that I want X,Y coordinates labeled with the text in a third column Regards