How to get the cell value after it because sum in a particular
how to get the sum value in every sheet
Yon can try this
In row(0).ToString… put your Column Name
currentSum = dtCurrentSheet.AsEnumerable().Where(Function(row) Not row(0).ToString().IsNullOrEmpty()).Sum(Function(row) Convert.ToDouble(row(0)))
there is a column called total stock
the column value should be sum and enter at the main sheet
like that it has 21 sheets
every sheet of total stock should be sum and add in main sheet linely
this is the sheet which contains data
the F column should sum and enter in the summary sheet but already the value is there in D column how to sum and enter the value in summary sheet
To get sum of a column in datatable you can use the below formula in assign the output would be of double type so create sum as double…then paste it or write it wherever you need
Sum = dt.AsEnumerable.Sum(function(x) CDBL(x("ToTal Stock").ToString))
Cheers
there are 21 sheets how to sum for 21 sheets and pass the values linely in summary this
i have tried this but how to pass the values dynamically
Loop through the sheets use the above formula inside loop
And then to write use currentindex to identify the row
In weite cell use Excel.Sheet("SheetName").Range("D" + (currentindex+6).ToString)
This will change the cell to d6,d7 and so on as the sheets change in loop
Cheers
Where to write is where you need to write the excel prt what to write is the sum.ToString
Cheers
You are using Write Cell activity so give this
Excel.Sheet(“Summary”).Cell(“D”+(currentindex+6).ToString… like this
In place of Range use Cell
the column is correct only but it is not in summary sheet it is in another sheet but i want that into summary sheet
Anil_G
Yoichi
fernan
lakshmi.mp
Gayathri_Ramanathan
Nawazish_Ahmad
Tanmay_V_Chetule
Nguyen_Van_Luong1
Shiva_Nikhil
cprima