excel --> microstation95 1

[123121]

Can somebody help me with this issue, please.
I am looking for a free utility or macro which allows to import excel table into microstation 95.

Many thanks,
Vlado

 

[vsiccclubchamp]

Use OLE
Edit>Insert Object

You will be prompt to define a rectangle, then select the excel format, then the file.

 

[123121]

I checked it but in Microstation95 is not option to insert OLE objects.

Thanks,
Vlado

 

[acdjr]

You can bring large Excel spreadsheets by saving them as an image.
In Excel highlight the cell range you wish to import and select copy.
Next right click on your desktop and start a new bitmap image, paste the spreadsheet into the bitmap,
You will be prompted to enlarge the image – say yes.
Your spreadsheet can be saved as a .bmp or save space save it as .jpg.
Now in your MicroStation drawing reference you image file as a raster file.
You can modify the reference to fit your drawing space.
Note: To get the Excel borders you will need to highlight the column before and the column after and one roll above and one roll below.