Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel --> microstation95 1
- Thread starter 123121
- Start date
vsiccclubchamp
Civil/Environmental
Use OLE
Edit>Insert Object
You will be prompt to define a rectangle, then select the excel format, then the file.
Edit>Insert Object
You will be prompt to define a rectangle, then select the excel format, then the file.
-
1
- Thread starter
- #3
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.
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.
- Status