I have two excels DT1 and DT2. DT2 has 4 columns and in 4th column i will be writing sumif formula.
What i have to sumif is…I have to take column"Wb" from Dt1,next column should be from Dt2 …column1 name as " DISALLOWED" and also column from DT1 which has name “IR”.
Could someone help me on this @ppr @Palaniyappan @vvaidya @ClaytonM @mickeymack @supermanPunch @Zac_Soh @MAHESH1 @kirankumar.mahanthi1 @mukeshkala @StefanSchnell @prasath_S
Could you explain ur query with screenshots , could not getting the ur query ?
i need to calculate = sumif(‘Final Report’!D:D,‘Disallowed’!B11,‘Final Report’!AL:AL)
Here final report and disallowed are two sheets in one excel…i need to write calculation in disallowed sheet in G column
so you need to copy the formula to all cells under G column upto data resides?
You can Use write cell for writing formula directly in Cells of G column.
Or You can use for each row and apply this formula for given column.
Or you can directly use macro code to apply formula.
Then use write cell as specified by @ImPratham45
better to use invoke code with microsoft interop excel it will fasten up the speed of processing
We are not allowed to use invoke code.
Could you tell me how to write this with linq query if possible
We cant use for loop as this will take time and macros as suggested by client not to use.
Could you let me know if we can write linq query for this.
Its not working.Can u help me with the linq query for this.
Does anyone provide me the linq query for this.
Could you help me how to write this directly into writecell
And how to write it if i use datatables to store first
Can you share what you wrote in given screenshot. As i am not getting any error
I cant use hardcorded values like this …so i will be storing it in datatable first…finalreport as dt1 and disallowed as dt2
For that i need syntax
whatever you wrote in write cell please give me that string
Screenshot is having the string bro already
where Finalreport is one sheet name and disallowed is another sheetname
store them in String variable not in Datatable