Excel function pass range in string format argument

Help
, ,
1

I want to pass a range in the excel function
eg: String.Format(“=Sum({0})”,Excel.Sheet(“Sheet1”).Range(“A2:B2”))

Please guide how to do it. Currently not able to pass the range

1 Like
2

Hey @shivam.gup,

Please check below workflow whether it solve your query.

image
image959×515 9.39 KB

If not, please let me know.

PFA FYR - ExcelFormula.zip (8.0 KB)

Thanks :slight_smile:

3

Actually i am writing it some other workbookand that excel file is currently in scope
and i am referring the resource excel for calculate the sum… so the values for sum i.e. range is coming from other excel file in current application scope . I am able to get to the cell value with this format but not the range.

1 Like