excel --> microstation95
excel --> microstation95
(OP)
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
I am looking for a free utility or macro which allows to import excel table into microstation 95.
Many thanks,
Vlado





RE: excel --> microstation95
Edit>Insert Object
You will be prompt to define a rectangle, then select the excel format, then the file.
RE: excel --> microstation95
Thanks,
Vlado
RE: excel --> microstation95
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.