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

On Dec 2, 12:21*pm, Rasheed wrote:
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

Hi SK,

I want the solution using c# code please.

regards
Rasheed

Rasheed wrote:
Hi SK,

I want the solution using c# code please.

regards
Rasheed


Well, this is the worksheet.functions group.

Maybe try the programming group.

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

--
Biff
Microsoft Excel MVP


"Rasheed" wrote in message
...
Hi SK,

I want the solution using c# code please.

regards
Rasheed