ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
wb.Worksheets.CreateWorksheet("Sheet2");
Range rng = wb.CreateRange("=Sheet1!A1:A3, Sheet2!A2:C5");
FunctionValue myValue = new FunctionValue(3.5drng);
Code Block
vb.net
vb.net
title
vb.net
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
wb.Worksheets.CreateWorksheet("Sheet2")
Dim rng As Range = wb.CreateRange("=Sheet1!A1:A3, Sheet2!A2:C5")
Dim myValue As New FunctionValue(3.5drng)