topic Table Column Sum in .NET Forum

Table Column Sum

k005 — Sat, 17 Dec 2022 21:26:24 GMT

Hi all,

I am creating a table. and it has data-numbers on it...

How can I sum the 4th column in this table from the 1st row?

I want to get the result with message box.

Thank you in advance for the help.

var table = new Table();

Re: Table Column Sum

JTBWorld — Sat, 17 Dec 2022 23:15:26 GMT

Something like this, modify as needed.

using Autodesk.AutoCAD.ApplicationServices; using Autodesk.AutoCAD.DatabaseServices; Document acDoc = Application.DocumentManager.MdiActiveDocument; Database acCurDb = acDoc.Database; using (Transaction acTrans = acCurDb.TransactionManager.StartTransaction()) { Table acTable; acTable = acTrans.GetObject(acCurDb.CurrentSpaceId, OpenMode.ForRead) as Table; double sum = 0; for (int i = 0; i < acTable.Rows.Count; i++) { for (int j = 0; j < acTable.Columns.Count; j++) { Cell acCell = acTable.Cells[i, j]; sum += (double)acCell.GetValue(acTrans); } } }

Re: Table Column Sum

k005 — Sun, 18 Dec 2022 08:17:08 GMT

Thanks for the answer. This is how my table is created. At the end of the code, I determine the table position by choosing a point.

* I tried to add the codes you sent, but it didn't work.

foreach (var entry in blocks) { table.Cells[row, 0].BlockTableRecordId = entry.Value[0].BlockTableRecord; string searched = "Q";// bool bak = (bool)(table.Cells[row, 1].Value = entry.Key.Contains(searched)); table.Cells[row, 1].Value = entry.Key; // İSİM table.Cells[row, 2].Value = entry.Value.Length; // ADET if (bak == true) { table.Cells[row, 3].Value = "-"; table.Cells[row, 4].Value = "-"; table.Cells[row, 5].Value = "-"; } else { table.Cells[row, 3].Value = (entry.Value.Length * double.Parse(entry.Key.Split('-')[1])).ToString("F2"); //adet * boy table.Cells[row, 4].Value = (double.Parse((trg.Krs(int.Parse(entry.Key.Split('-')[0].Remove(0, 1))) * 0.00617).ToString("F3")) * entry.Value.Length * double.Parse(entry.Key.Split('-')[1])).ToString("F2"); //Ağırlık. table.Cells[row, 5].Value = (entry.Value.Length * double.Parse(entry.Key.Split('-')[1]) / 12).ToString("F2"); //adet * boy / 12m Çubuk } row++; }

sum += (double)acCell.GetValue(acTrans); ---> red part error...

Re: Table Column Sum

norman.yuan — Sun, 18 Dec 2022 14:45:28 GMT

Well, if your OWN CODE fills up the table's columns/cells, wouldn't you (or the code) already know the sum of each column after the cells being filled in your "foreach..." loop?

Re: Table Column Sum

k005 — Sun, 18 Dec 2022 15:09:22 GMT

Yes. After picking a point and creating the table, I can explode it and get a total.

but what I want to do is to get a total without detonating.

Re: Table Column Sum

norman.yuan — Mon, 19 Dec 2022 14:12:07 GMT

Again, SINCE YOUR CODE FILLS(!!!) the table cells, you should have already known the sum of each column after the table cells are filled in the "foreach (var entry...){...}" loop. So, there is no need to try to figure out the sums AFTER the table is created, or even go to the extreme to explode it for that matter. As matter of fact, you do not even need to create the table for get the column sums of a set of tabular data (which you retrieved from a set of blocks).

Something like:

var colSum1=0.0;

var colSum2=0.0;

...

foreach (var entry in blocks)

{

var num1=entry.prop1;

// fill out the cell of first row, first column, if you whish;

colSum+=num1;

var num2=entry.prop2;

// fill out the cell of first row, second column, if you whish;

colSum2+=num2;

... ...

}

editor.WriteMessage($"\nSUM of Column1={colSum1}\tSUM of Column2={colSum2}");

Re: Table Column Sum

k005 — Mon, 19 Dec 2022 15:07:39 GMT

You need a table. because block shapes are also required.

var num1=entry.prop1 ---> What is the full definition of this?

Ynt: Table Column Sum

k005 — Tue, 20 Dec 2022 07:41:30 GMT

Isn't there another way to sum column 4?

table.Cells[row, 4].Value = (double.Parse((trg.Krs(int.Parse(entry.Key.Split('-')[0].Remove(0, 1))) * 0.00617).ToString("F3")) * entry.Value.Length * double.Parse(entry.Key.Split('-')[1])).ToString("F2"); //Ağırlık.