import xml

Jan Haspra

Hi there

I have Excel file with Y, X, and Z coordinates and numbers of points. Is there way how to use it for Bcad and make points in dwg with that coordinates and points marks and numbers?

Thanks

 

Vaidas Guogis

Hi Jan,

You can find a couple of applications for point import from text data, just save your XLS data to Tab delimited ot CSV text file. Please try http://www.bricscad.com/common/applications/application.jsp?app=384 for this purpose.

Regards, Vaidas

Rakesh Rao

Hi Jan,

There are ways and means to import/export data from Excel to Bricscad. You can look up the Bricscad applications catalog for applications that do that.

Personally, I often find it easier to export the XLS data into ASCII text in delimited or fixed columns format and bring it into Bricscad.

Our GeoTools program (see URL below) has one such tool called GT_IMPEX that will offer a variety of means to import and export point data into / from Bricscad.

-Or- Let me know if you want some Lisp code for some quick-and-dirty point import and I can create one for you.

Regards
Rakesh Rao
www.coordsys.com

Jason Bourhill

X,Y,Z data in Excel? Why don't you use excel to create a script. Example below has X,Y,Z data in columns A,B,C. Column E contains the data for the script, which you create by simply concatenating the data together

 

	A	B	C	D	E
1	X	Y	Z		Script
2	12.0	5.0	8.0		POINT 12,5,8
3	15.0	62.0	5.0		POINT 15,62,5
4	18.0	1.0	45.0		POINT 18,1,45
5	45.0	2.0	12.0		POINT 45,2,12
6	45.0	46.0	36.0		POINT 45,46,36
7	64.0	14.0	12.0		POINT 64,14,12
8	12.0	32.0	10.0		POINT 12,32,10

For instance Cell E2 contains the following formulae: ="POINT " &B3& ","&C3& ","&D3

Once you have formed the data for your script simply select in excel, paste in a text editor (notepad) and save it as a script.

Recommend you trial on a test drawing to work out any issues, before unleashing on your real drawing.

I have created script files this way many times. Its simple and it works.

 

Greg Skelhorn

I will just add the warning that you will always want to turn Snaps off when running a script to create point entities.