topic Re: Convert points xyz into excel in AutoCAD Forum

Convert points xyz into excel

ishaq03 — Tue, 19 Oct 2021 13:39:44 GMT

I have a almost 1,00,0000 points in my cad file, I would like to export all the points geometry in excel means xyz. I have been Tried with data extraction command but the command allowing me only upto 650000 geomatry points, Please anyone either provide me a lisp or solution for this dwg. For your reference I attached the dwg here.

Note: It's top urgent please.

Re: Convert points xyz into excel

ВeekeeCZ — Tue, 19 Oct 2021 13:49:51 GMT

So select less than 650.000 and make it twice... Where's the issue?

Re: Convert points xyz into excel

Alfred.NESWADBA — Tue, 19 Oct 2021 13:58:51 GMT

Hi,

>> I have a almost 1,00,0000 points in my cad file, I would like

>> to export all the points geometry in excel

Be careful, Excel can not show more than 1.048.576 lines (and I would not try to use them all 😉 ).

What are you trying to do with these amount of points in Excel?

- alfred -

Re: Convert points xyz into excel

ishaq03 — Tue, 19 Oct 2021 15:57:03 GMT

Not 6,50,000 its only 65,000

Re: Convert points xyz into excel

ishaq03 — Tue, 19 Oct 2021 15:58:36 GMT

Surveyor need the points in csv format

Re: Convert points xyz into excel

ВeekeeCZ — Tue, 19 Oct 2021 16:04:16 GMT

Use a log file and this line

(progn (repeat (setq i (sslength (setq s (ssget "_x" '((0 . "POINT")))))) (princ "\n") (princ (cdr (assoc 10 (entget (ssname s (setq i (1- i)))))))) (princ))

Re: Convert points xyz into excel

ishaq03 — Tue, 19 Oct 2021 16:13:22 GMT

Sorry I didn't get you idea Please explain me in detail

Re: Convert points xyz into excel

Pointdump — Tue, 19 Oct 2021 16:34:53 GMT

Hi Syed,
Wow, 997888 Points! Your finger must be tired from all that clicking! If you didn't create all those points, how did they get in your drawing?
No matter. Here you go. CSV attached.
Dave

Re: Convert points xyz into excel

ishaq03 — Tue, 19 Oct 2021 17:50:14 GMT

Thank u very much, Please tell me how did you extract this points.

Re: Convert points xyz into excel

Pointdump — Tue, 19 Oct 2021 20:12:00 GMT

Syed,
I used Civil 3D to MAPEXPORT the points as a Shapefile. In QGIS I saved the Point Shapefile as CSV. There's probably more ways to do this, but this seemed fastest.
Dave

Re: Convert points xyz into excel

ishaq03 — Wed, 20 Oct 2021 04:33:14 GMT

Dave,

Thanks once again for your quick response and solution, I have been tried to convert this points in as a cogo in civil3d but it's taking time process my system hanging because of the quantity of points. Any how your solution is more faster if we have a mass point quantities.

Re: Convert points xyz into excel

ishaq03 — Wed, 20 Oct 2021 04:55:06 GMT

Can you send me QGIS software link if it's free or trial version.

Re: Convert points xyz into excel

Alfred.NESWADBA — Wed, 20 Oct 2021 05:59:07 GMT

Hi,

>> Can you send me QGIS software link

SCNR: >>>click<<<

- alfred -

Re: Convert points xyz into excel

ishaq03 — Wed, 20 Oct 2021 06:23:53 GMT

Thanks Alfred

Re: Convert points xyz into excel

hmsilva — Wed, 20 Oct 2021 08:13:10 GMT

@ishaq03 wrote:

I have a almost 1,00,0000 points in my cad file, I would like to export all the points geometry in excel means xyz. I have been Tried with data extraction command but the command allowing me only upto 650000 geomatry points, Please anyone either provide me a lisp or solution for this dwg. For your reference I attached the dwg here.

Note: It's top urgent please.

@ishaq03 try the attached file....

Hope this helps,
Henrique