Attribute to excel with count

[CAD-Geek]

After searching in forum I found code that extracts data from attribute block 

but I need to modify the excel output result as DATAEXTRACTION command

            List<object[]> rooms = new List<object[]>();
            using (var tr = db.TransactionManager.StartTransaction())
            {
                foreach (SelectedObject so in psr.Value)
                {
                    BlockReference bref = (BlockReference)tr.GetObject(so.ObjectId, OpenMode.ForRead);
                    //populate array with attribute data
                    Autodesk.AutoCAD.DatabaseServices.AttributeCollection attcoll = bref.AttributeCollection;
                    object[] info = new object[4];
                    foreach (ObjectId id in attcoll)
                    {
                        AttributeReference atref = (AttributeReference)tr.GetObject(id, OpenMode.ForRead);

                        if (atref.Tag=="QUANTITY")
                        {
                            info[0] = atref.TextString;
                        }
                        if (atref.Tag=="MATERIAL")
                        {
                            info[1] = atref.TextString;
                        }
                        if (atref.Tag=="STANDARD")
                        {
                            info[2] = atref.TextString;
                        }

                        if (!rooms.Contains(info))
                        {
                            
                            rooms.Add(info);
                        }
                    }
                }
                tr.Commit();
            }

the excel output

I need the result to be something like this 

[SENL1362]

search for GROUP BY

[_gile]

Hi,

You can have a look at this:

http://www.theswamp.org/index.php?topic=31859.msg452527#msg452527

[CAD-Geek]

thnx @_gile for reply I tried your code but I got this exception 

[CAD-Geek]

thnx @SENL1362 for the reply I tried your suggest like this 

if (!rooms.Contains(info))
                        {
                            info[3] = rooms.GroupBy(x=>x).Count() + "c";
                            rooms.Add(info);
                        }

[SENL1362]

For this:

Do this:

                //var info = new object[4];
                var rooms = new List<object[]>();
                rooms.Add(new object[] { 3, "", "MS02" });
                rooms.Add(new object[] { 1, "", "MS19E" });
                rooms.Add(new object[] { 1, "", "MS19E" });
                rooms.Add(new object[] { 3, "", "MS17B" });
                rooms.Add(new object[] { 1, "", "MS19E" });
                rooms.Add(new object[] { "1m", "439C", "" });
                rooms.Add(new object[] { "1m", "439C", "" });
                rooms.Add(new object[] { "1m", "439C", "" });
                rooms.Add(new object[] { 1, "", "MS47G" });
                rooms.Add(new object[] { 1, "", "MS19E" });
                rooms.Add(new object[] { 1, "", "MS19E" });
                rooms.Add(new object[] { 1, "", "MS19E" });
                rooms.Add(new object[] { "5m", "439C", "" });
                rooms.Add(new object[] { "5m", "439C", "" });
                rooms.Add(new object[] { "5m", "430D", "" });
                rooms.Add(new object[] { "5m", "439C", "" });


                var groupedRooms = rooms.GroupBy(x => new { A = x[1], B = x[2], C = x[0] }).Select(g => new { Count = g.Count(), Quantity = g.Key.C, Material = g.Key.A, Standard = g.Key.B });
                ed.WriteMessage("\nCount, 2-Quantity, 3-Material, 4-Standard");
                //foreach (var r in groupedRooms.OrderBy(n=>n.Count).ThenBy(m=>m.Material))
                foreach (var gr in groupedRooms)
                {
                    ed.WriteMessage($"\n{gr.Count,5}, {gr.Quantity,-10}, {gr.Material,-10}, {gr.Standard,-10}");
                }

[CAD-Geek]

I tried 

                        if (atref.Tag=="QUANTITY")
                        {
                            rooms.Add(new object[] { atref.TextString });
                            //info[0] = atref.TextString;
                        }
                        if (atref.Tag=="MATERIAL")
                        {
                            rooms.Add(new object[] { atref.TextString });
                            //info[1] = atref.TextString;
                        }
                        if (atref.Tag=="STANDARD")
                        {
                            rooms.Add(new object[] { atref.TextString });
                            //info[2] = atref.TextString;
                        }
var groupedRooms = rooms.GroupBy(x => new { A = x[1], B = x[2], C = x[0] }).Select(g => new { Count = g.Count(), Quantity = g.Key.C, Material = g.Key.A, Standard = g.Key.B });
foreach (var r in groupedRooms.OrderBy(n=>n.Count).ThenBy(m=>m.Material))

and I use this code to export to excel @Hallex

ExcelTool.FillExistingBook(@"C:\Test\Programming\BCOUNT.xlsx", new object[] { "Count","QUANTITY", "MATERIAL", "Standard" },  excdata);

but I got the error 

Index was outside the bounds of the array

[_gile · Accepted solution]

---

@CAD-Geek wrote:

thnx @_gile for reply I tried your code but I got this exception 

---

As you have a tag named "QUANTITY"  you should change the "Quantity" column name of the DataTable.

Try replacing:

dTable.Columns.Add("Quantity", typeof(int));

with:

dTable.Columns.Add("Count", typeof(int));

or whatever else different from any attribute Tag.