//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet sheet1 = workbook.ActiveSheet; sheet1.Name = "BYROW"; sheet1.Range["$B$2"].Value = "ETA LAMBDA VS Normal LAMBDA"; sheet1.Range["$B$2"].Font.Bold = true; var table1 = sheet1.Tables.Add(sheet1.Range["$B$5:$E$10"], true); table1.ConvertToRange(); var sheet1rngB5E10 = new object[,] { { "Student", "Math", "English", "Physics"}, { "Tom", 19d, 23d, 19d}, { "Jerry", 21d, 15d, 18d}, { "Mario", 19d, 22d, 22d}, { "Luigi", 17d, 15d, 23d}, { "Galen", 16d, 22d, 24d} }; var table2 = sheet1.Tables.Add(sheet1.Range["G5:G10"], true); table2.ConvertToRange(); var table3 = sheet1.Tables.Add(sheet1.Range["G13:G18"], true); table3.ConvertToRange(); sheet1.Range["$B$5:$E$10"].Value = sheet1rngB5E10; sheet1.Range["$G$4"].Value = "Normal LAMBDA"; sheet1.Range["$G$5"].Value = "BYROW(C6:E10,LAMBDA(row,SUM(row)))"; sheet1.Range["$G$5"].Font.Color = Color.Black; sheet1.Range["$G$5"].Interior.Color = Color.White; sheet1.Range["$G$6"].Formula2 = "=BYROW(C6:E10,LAMBDA(row,SUM(row)))"; sheet1.Range["$G$12"].Value = "ETA LAMBDA"; sheet1.Range["$G$13"].Value = "BYROW(C6:E10,SUM)"; sheet1.Range["$G$13"].Font.Color = Color.Black; sheet1.Range["$G$13"].Interior.Color = Color.White; sheet1.Range["$G$14"].Formula2 = "=BYROW(C6:E10,SUM)"; // Save to an excel file workbook.Save("EtaLambda.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim sheet1 As IWorksheet = workbook.ActiveSheet sheet1.Name = "BYROW" sheet1.Range("$B$2").Value = "ETA LAMBDA VS Normal LAMBDA" sheet1.Range("$B$2").Font.Bold = True Dim table1 As ITable = sheet1.Tables.Add(sheet1.Range("$B$5:$E$10"), True) table1.ConvertToRange() Dim table2 As ITable = sheet1.Tables.Add(sheet1.Range("G5:G10"), True) table2.ConvertToRange() Dim table3 As ITable = sheet1.Tables.Add(sheet1.Range("G13:G18"), True) table3.ConvertToRange() Dim sheet1rngB5E10 As Object(,) = New Object(,) { {"Student", "Math", "English", "Physics"}, {"Tom", 19.0, 23.0, 19.0}, {"Jerry", 21.0, 15.0, 18.0}, {"Mario", 19.0, 22.0, 22.0}, {"Luigi", 17.0, 15.0, 23.0}, {"Galen", 16.0, 22.0, 24.0} } sheet1.Range("$B$5:$E$10").Value = sheet1rngB5E10 sheet1.Range("$G$4").Value = "Normal LAMBDA" sheet1.Range("$G$5").Value = "BYROW(C6:E10,LAMBDA(row,SUM(row)))" sheet1.Range("$G$5").Font.Color = Color.Black sheet1.Range("$G$5").Interior.Color = Color.White sheet1.Range("$G$6").Formula2 = "=BYROW(C6:E10,LAMBDA(row,SUM(row)))" sheet1.Range("$G$12").Value = "ETA LAMBDA" sheet1.Range("$G$13").Value = "BYROW(C6:E10,SUM)" sheet1.Range("$G$13").Font.Color = Color.Black sheet1.Range("$G$13").Interior.Color = Color.White sheet1.Range("$G$14").Formula2 = "=BYROW(C6:E10,SUM)" ' save to an excel file workbook.Save("EtaLambda.xlsx")