Sum of each row.

[Rasheed]

Hi All,

i have created one xls file using c# Excel =
Microsoft.Office.Interop.Excel. DLL
and i have the data like below


A B C D
1 100 20 30
2 101 20 31
3 102 20 35
4 103 20 35
5 104 20 32


I need to do subtotal of each row. please help me out how to do ?


result will be like below


-------------------------------------------------------------
GrandTotal 510 100 163
-------------------------------------------------------------



oWSheet.get_Range("A1" , "D5" )).Subtotal(1,
Excel.XlConsolidationFunction.xlSum, Type.Missing,
(object)true, (object)true, Excel.XlSummaryRow.xlSummaryBelow);


i am using the above function but it gives only one row total only.
but i want 3 rows Grand Total individually like above.


thanks in advance.


regards
Rasheed

 

[SK08]

Hi All,

i have created one xls file using c# Excel =
Microsoft.Office.Interop.Excel. DLL
and i have the data like below

      A           B            C          D
1                  100         20        30
2                   101         20        31
3                   102         20        35
4                   103         20        35
5                   104         20        32

 I need to do subtotal of each row. please help me out how to do ?

result will be like below

-------------------------------------------------------------
GrandTotal         510         100      163
-------------------------------------------------------------

oWSheet.get_Range("A1" , "D5" )).Subtotal(1,
Excel.XlConsolidationFunction.xlSum, Type.Missing,
(object)true, (object)true, Excel.XlSummaryRow.xlSummaryBelow);

i am using the above function but it gives only one row total only.
but i want 3 rows Grand Total individually like above.

thanks in advance.

regards
Rasheed

=sum(B1:B5)
=sum(C1:C5), etc

 

[Rasheed]

Hi SK,

I want the solution using c# code please.

regards
Rasheed

 

[Glenn]

Hi SK,

I want the solution using c# code please.

regards
Rasheed

Well, this is the worksheet.functions group.

Maybe try the programming group.

 

[T. Valko]

You'll probably have a better chance at getting a useful reply if you post
your question in a C# newsgroup.