//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); var sheet = workbook.Worksheets[0]; #region Init Data sheet.Name = "API Evaluate2"; sheet.Range["B3:B11"].Value = new object[,] { { "Product" }, { "Apple"}, { "Grape"}, { "Pear"}, { "Banana"}, { "Coconut"}, { "Strawberry"}, { "Orange"}, { "Pineapple"} }; ITable table = sheet.Tables.Add(sheet.Range["B3:B11"], true); ITable table1 = sheet.Tables.Add(sheet.Range["D3:D11"], true); table.ConvertToRange(); table1.ConvertToRange(); sheet.Range["D3"].Value = "Evaluate2 results:"; sheet.Range["B:D"].AutoFit(); #endregion var evaluateRes = sheet.Evaluate2("=LEN(B4:B11)"); sheet.Range["D4:D11"].Value = evaluateRes; // Save to an excel file workbook.Save("Evaluate2.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim sheet = workbook.Worksheets(0) ' Init Data sheet.Name = "API Evaluate2" sheet.Range("B3:B11").Value = New Object(,) { {"Product"}, {"Apple"}, {"Grape"}, {"Pear"}, {"Banana"}, {"Coconut"}, {"Strawberry"}, {"Orange"}, {"Pineapple"} } Dim table As ITable = sheet.Tables.Add(sheet.Range("B3:B11"), True) Dim table1 As ITable = sheet.Tables.Add(sheet.Range("D3:D11"), True) table.ConvertToRange() table1.ConvertToRange() sheet.Range("D3").Value = "Evaluate2 results:" sheet.Range("B:D").AutoFit() Dim evaluateRes = sheet.Evaluate2("=LEN(B4:B11)") sheet.Range("D4:D11").Value = evaluateRes ' save to an excel file workbook.Save("Evaluate2.xlsx")