Which method should you pass the range variable?

You have a web part that uses Excel Web Services to open a published Microsoft Office Excel workbook. You need to calculate formulas in the workbook for a range. You write the following line of code:

01: Dim range as String = “Sheet1!A1:F17”

Which method should you pass the range variable?

You have a web part that uses Excel Web Services to open a published Microsoft Office Excel workbook. You need to calculate formulas in the workbook for a range. You write the following line of code:

01: Dim range as String = “Sheet1!A1:F17”

Which method should you pass the range variable?

A.
Calculate()

B.
CalculateA1()

C.
SetRange()

D.
SetRangeA1()



Leave a Reply 0

Your email address will not be published. Required fields are marked *