topic Re: Export coordinates of selected points to Excel C# in .NET Forum

Export coordinates of selected points to Excel C#

J-Rocks — Sat, 31 Oct 2015 19:06:04 GMT

Hello folks,

I have searched the fourm for C# codes to export coordintes of the selected points to Excel but did not find.

Anyone can help please?

Thank you.

Re: Export coordinates of selected points to Excel C#

Matti72 — Mon, 02 Nov 2015 10:32:19 GMT

Could you specify your problem?

Could you not select points and get the coordinates?

Then try something like this.

Document doc = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument;
Autodesk.AutoCAD.DatabaseServices.Database db = doc.Database;
Editor editor = doc.Editor;

// Get the PickFirst selection set
PromptSelectionResult ss;
ss = editor.SelectImplied();
// If the prompt status is OK, objects were selected before
// the command was started, if not ask.
if (ss.Status != PromptStatus.OK)
{
	PromptSelectionOptions sOpt = new PromptSelectionOptions();
	//SelectionFilter sFilter = new SelectionFilter();
	ss = editor.GetSelection(sOpt);
}

Point3dCollection colRes = new Point3dCollection();
if (ss.Status == PromptStatus.OK)
{
   using (Transaction tr = doc.Database.TransactionManager.StartTransaction())
   {
	if (ss.Value != null)
	{
		for (int i = 0; i < ss.Value.Count; i++)
		{
			Entity dim = tr.GetObject(ss.Value[i].ObjectId, OpenMode.ForRead) as Entity;
			if (dim is DBPoint)
			{
				colRes.Add(((DBPoint)dim).Position);
			}
		}
        }
	tr.Commit();
}

Or do you not know, how to export everything to excel?

Then you could either write everything to a csv file (google for csv file and c# / .net)

or do you want to open excel and put the coordinates directly in the worksheet?

Then google for excel automation and .net

This article would be a good start : https://support.microsoft.com/en-us/kb/302084

Re: Export coordinates of selected points to Excel C#

J-Rocks — Mon, 02 Nov 2015 20:13:36 GMT

Thank you.

I am sorry for not being clear .

I am after learning how the codes of C# work in AutoCAD via transfering data to Excel . for example.

Select Points objects , then prompt the use to enter the name of the Excel file then transfer the coordinates of the previous selcted points into four columns:

[ Serial No. ] [ X ] [ Y ] [ Z ]

Thanks a lot.

Re: Export coordinates of selected points to Excel C#

BrentBurgess1980 — Tue, 03 Nov 2015 00:39:59 GMT

I havent tested this, but hopefully it should give you a starting point and refine to your needs.

public void WritePointsToCSVFile()
            {
            Document doc = AcApp.DocumentManager.MdiActiveDocument;
            Editor ed = doc.Editor;
            Database db = doc.Database;

            using (DocumentLock dLock = doc.LockDocument())
                {
                TypedValue[] tvs = new TypedValue[3];
                tvs.SetValue(new TypedValue((int)DxfCode.Operator, "<or"), 0);
                tvs.SetValue(new TypedValue((int)DxfCode.Start, "POINT"), 1);
                tvs.SetValue(new TypedValue((int)DxfCode.Start, "or>"), 2);

                PromptSelectionOptions pso = new PromptSelectionOptions();
                pso.MessageForAdding = "\nSelect points: ";
                SelectionFilter sf = new SelectionFilter(tvs);
                PromptSelectionResult psr = ed.GetSelection(pso, sf);

                if (psr.Status == PromptStatus.OK)
                    {
                    SaveFileDialog sfd = new SaveFileDialog();
                    sfd.Filter = "*.csv Files|*.csv";
                    if (sfd.ShowDialog() == DialogResult.OK)
                        {
                        StreamWriter sw = new StreamWriter(sfd.FileName);

                        using (Transaction tr = db.TransactionManager.StartTransaction())
                            {
                            foreach (ObjectId id in psr.Value.GetObjectIds())
                                {
                                DBPoint pt = (DBPoint)tr.GetObject(id, OpenMode.ForRead);
                                sw.WriteLine("{0},{1},{2}", pt.Position.X, pt.Position.Y, pt.Position.Z);
                                }
                            tr.Commit();
                            }
                        sw.Close();
                        ed.WriteMessage("\nCoordinates output to {0}", sfd.FileName);
                        }
                    }
                }
            }

Hope this helps.

Re: Export coordinates of selected points to Excel C#

J-Rocks — Tue, 03 Nov 2015 10:57:57 GMT

Hi ,

The codes loaded without any error but it does not do anything . can you check the codes once again please ?

Thank you.

Re: Export coordinates of selected points to Excel C#

J-Rocks — Tue, 03 Nov 2015 11:47:33 GMT

I was able to make to work by modifying the Typedvalue like this:

TypedValue[] tvs = new TypedValue[] { new TypedValue((int)DxfCode.Start, "POINT") };

but the codes write the coordinates (X,Y,Z) in one cell and I am in need of them to be each one in a cell in one row .

Can you please modify the codes ?

EDIT: nevermind , I modified the codes by replacing the comma to semicolon and it works , thank you.

sw.WriteLine("{0};{1};{2}", pt.Position.X, pt.Position.Y, pt.Position.Z);

Re: Export coordinates of selected points to Excel C#

Anonymous — Tue, 12 Mar 2019 03:37:40 GMT

I recommend you to use https://zetexcel.com/. I used it for many projects.