Hi, I'm looking to take a group of 31 excel workbooks, loop through them, get the value from the same field (M7), which is of the General format, and get a sum total for all of the workbooks. What I'm stuck on is how to get the data from excel.Here is the formula in cell C4, which returns the value from the specified address. =INDIRECT(ADDRESS(C2,C3)) Ex 3: Address of cell with highest value. In this example, we'll find the cell with the highest value, and use the ADDRESS function to get its address. First, in cell F3, the MAX function finds the highest number in column C. =MAX(C3:C8)
Sep 15, 2015 · >> C# OpenXmlReader get cell value from excel instead of formula With the code below, you could find the cell value is stored in the value element of cell, you could use Cell.LastChild to get the element. <x:c r="C1"> <x:f>A1+B1</x:f> <x:v>3</x:v> </x:c> Here is a simple demo to get the value instead of formula.