List of APIs under IRange

11 Jul 202424 minutes to read

Cell Address

The following code example illustrates the usage of Address, AddressGlobal, AddressLocal, AddressR1C1, AddressR1C1Local properties.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Address
  string address = worksheet.Range[3, 4].Address;

  //Global Address
  string address_Global = worksheet.Range[3, 4].AddressGlobal;

  //Local Address
  string address_Local = worksheet.Range[3, 4].AddressLocal;

  //R1C1 Address
  string address_R1C1 = worksheet.Range[3, 4].AddressR1C1;

  //Local R1C1 Address
  string address_R1C1_Local = worksheet.Range[3, 4].AddressR1C1Local;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Address
  string address = worksheet.Range[3, 4].Address;

  //Global Address
  string address_Global = worksheet.Range[3, 4].AddressGlobal;

  //Local Address
  string address_Local = worksheet.Range[3, 4].AddressLocal;

  //R1C1 Address
  string address_R1C1 = worksheet.Range[3, 4].AddressR1C1;

  //Local R1C1 Address
  string address_R1C1_Local = worksheet.Range[3, 4].AddressR1C1Local;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Address
  Dim address As String = worksheet.Range(3, 4).Address

  'Global Address
  Dim address_Global As String = worksheet.Range(3, 4).AddressGlobal

  'Local Address
  Dim address_Local As String = worksheet.Range(3, 4).AddressLocal

  'R1C1 Address
  Dim address_R1C1 As String = worksheet.Range(3, 4).AddressR1C1

  'Local R1C1 Address
  Dim address_R1C1_Local As String = worksheet.Range(3, 4).AddressR1C1Local

  workbook.SaveAs("Output.xlsx")
End Using

Boolean

As the name says, Boolean property gets or sets the boolean value in a worksheet range. The following code example illustrates this.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Boolean - True
  worksheet.Range["B3"].Boolean = true;
  bool b3 = worksheet.Range["B3"].Boolean;

  //Boolean - False
  worksheet.Range["B4"].Boolean = false;
  bool b4 = worksheet.Range["B4"].Boolean;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Boolean - True
  worksheet.Range["B3"].Boolean = true;
  bool b3 = worksheet.Range["B3"].Boolean;

  //Boolean - False
  worksheet.Range["B4"].Boolean = false;
  bool b4 = worksheet.Range["B4"].Boolean;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Boolean - True
  worksheet.Range("B3").Boolean = True
  Dim b3 As Boolean = worksheet.Range("B3").Boolean

  'Boolean - False
  worksheet.Range("B4").Boolean = False
  Dim b4 As Boolean = worksheet.Range("B4").Boolean

  workbook.SaveAs("Output.xlsx")
End Using

Borders

The following code example illustrates how to set border styles for a worksheet range using Borders property.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set text
  worksheet.Range["C2"].Text = "Sample";

  //Set borders
  IBorders borders = worksheet.Range["C2"].Borders;

  //Set border color
  borders[ExcelBordersIndex.EdgeTop].Color = ExcelKnownColors.Red;
  borders[ExcelBordersIndex.EdgeBottom].Color = ExcelKnownColors.Blue;

  //Set line style
  borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thick;
  borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thick;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set text
  worksheet.Range["C2"].Text = "Sample";

  //Set borders
  IBorders borders = worksheet.Range["C2"].Borders;

  //Set border color
  borders[ExcelBordersIndex.EdgeTop].Color = ExcelKnownColors.Red;
  borders[ExcelBordersIndex.EdgeBottom].Color = ExcelKnownColors.Blue;

  //Set line style
  borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thick;
  borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thick;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set text
  worksheet.Range("C2").Text = "Sample"

  'Set borders
  Dim borders As IBorders = worksheet.Range("C2").Borders

  'Set border color
  borders(ExcelBordersIndex.EdgeTop).Color = ExcelKnownColors.Red
  borders(ExcelBordersIndex.EdgeBottom).Color = ExcelKnownColors.Blue

  'Set line style
  borders(ExcelBordersIndex.EdgeTop).LineStyle = ExcelLineStyle.Thick
  borders(ExcelBordersIndex.EdgeBottom).LineStyle = ExcelLineStyle.Thick

  workbook.SaveAs("Output.xlsx")
End Using

Built-In-Style

The following code example illustrates how to add BuiltInStyle for a worksheet range.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set text
  worksheet.Range["C2"].Text = "Sample";

  //Set built in style
  worksheet.Range["C2"].BuiltInStyle = BuiltInStyles.Accent3;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set text
  worksheet.Range["C2"].Text = "Sample";

  //Set built in style
  worksheet.Range["C2"].BuiltInStyle = BuiltInStyles.Accent3;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set text
  worksheet.Range("C2").Text = "Sample"

  'Set built in style
  worksheet.Range("C2").BuiltInStyle = BuiltInStyles.Accent3

  workbook.SaveAs("Output.xlsx")
End Using

Calculated Value

CalculatedValue is the evaluated value of the formula. The following code example illustrates how to get the CalculatedValue of the formula.

NOTE

It is mandatory to enable sheet calculations i.e., worksheet.EnableSheetCalculations(); before accessing the CalculatedValue. Else, CalculatedValue will be returned as null.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Number = 10;
  worksheet.Range["A2"].Number = 20;

  //Set formula
  worksheet.Range["A3"].Formula = "=SUM(A1:A2)";

  //Enable sheet calculations
  worksheet.EnableSheetCalculations();

  //Get the calculated value
  string value = worksheet.Range["A3"].CalculatedValue;

  //Disable sheet calculations
  worksheet.DisableSheetCalculations();

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Number = 10;
  worksheet.Range["A2"].Number = 20;

  //Set formula
  worksheet.Range["A3"].Formula = "=SUM(A1:A2)";

  //Enable sheet calculations
  worksheet.EnableSheetCalculations();

  //Get the calculated value
  string value = worksheet.Range["A3"].CalculatedValue;

  //Disable sheet calculations
  worksheet.DisableSheetCalculations();

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set values
  worksheet.Range("A1").Number = 10
  worksheet.Range("A2").Number = 20

  'Set formula
  worksheet.Range("A3").Formula = "=SUM(A1:A2)"

  'Enable sheet calculations
  worksheet.EnableSheetCalculations()

  'Get the calculated value
  Dim value As String = worksheet.Range("A3").CalculatedValue

  'Disable sheet calculations
  worksheet.DisableSheetCalculations()

  workbook.SaveAs("Output.xlsx")
End Using

Cells

Cells property maintains the collection of cells in a worksheet range. The following code example illustrates how to access this property.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Range of cells
  IRange[] cells = worksheet.Range["A1:E5"].Cells;

  foreach (IRange cell in cells)
  {
    //Assign value
    cell.Text = cell.AddressLocal;
  }

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Range of cells
  IRange[] cells = worksheet.Range["A1:E5"].Cells;

  foreach (IRange cell in cells)
  {
    //Assign value
    cell.Text = cell.AddressLocal;
  }

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Range of cells
  Dim cells() As IRange = worksheet.Range("A1:E5").Cells

  For Each cell As IRange In cells
    'Assign value
    cell.Text = cell.AddressLocal
  Next

  workbook.SaveAs("Output.xlsx")
End Using

Cell Style Name

CellStyleName represents the name of the style of worksheet range/cell. The default value is Normal.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Add style
  IStyle style = workbook.Styles.Add("CustomStyle");

  //Set color
  style.ColorIndex = ExcelKnownColors.Red;

  //Set style
  worksheet.Range["C2"].CellStyle = style;

  //Get the cell style name
  string cellStyleName = worksheet.Range["C2"].CellStyleName;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Add style
  IStyle style = workbook.Styles.Add("CustomStyle");

  //Set color
  style.ColorIndex = ExcelKnownColors.Red;

  //Set style
  worksheet.Range["C2"].CellStyle = style;

  //Get the cell style name
  string cellStyleName = worksheet.Range["C2"].CellStyleName;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Add style
  Dim style As IStyle = workbook.Styles.Add("CustomStyle")

  'Set color
  style.ColorIndex = ExcelKnownColors.Red

  'Set style
  worksheet.Range("C2").CellStyle = style

  'Get the cell style name
  Dim cellStyleName As String = worksheet.Range("C2").CellStyleName

  workbook.SaveAs("Output.xlsx")
End Using

Column

Column property gets the column index of first column in worksheet range, which is one-index based.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Get first column in the range
  int firstColumn = worksheet.Range["E1:R3"].Column;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Get first column in the range
  int firstColumn = worksheet.Range["E1:R3"].Column;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Get first column in the range
  Dim firstColumn As Integer = worksheet.Range("E1:R3").Column

  workbook.SaveAs("Output.xlsx")
End Using

Columns

Columns property maintains the collection of columns in a worksheet range.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Columns
  IRange[] columns = worksheet.Range["A1:E5"].Columns;

  foreach (IRange column in columns)
  {
    //Assign value
    column.Text = column.AddressLocal;
  }

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Columns
  IRange[] columns = worksheet.Range["A1:E5"].Columns;

  foreach (IRange column in columns)
  {
    //Assign value
    column.Text = column.AddressLocal;
  }

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Columns
  Dim columns() As IRange = worksheet.Range("A1:E5").Columns

  For Each column As IRange In columns
    'Assign value
    column.Text = column.AddressLocal
  Next

  workbook.SaveAs("Output.xlsx")
End Using

Comment

For more details about Comment, click here.

Conditional Formats

For more details about Conditional Formats, click here.

Count

Count property returns the number of cells in that particular worksheet range.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Number of cells
  int count = worksheet.Range["A1:E5"].Count;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Number of cells
  int count = worksheet.Range["A1:E5"].Count;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Number of cells
  Dim count As Integer = worksheet.Range("A1:E5").Count

  workbook.SaveAs("Output.xlsx")
End Using

Data Validation

For more details about Data Validation, click here.

End

End property returns the last cell in the particular worksheet range.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Last cell in the range
  IRange lastCell = worksheet.Range["A1:E5"].End;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Last cell in the range
  IRange lastCell = worksheet.Range["A1:E5"].End;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Last cell in the range
  Dim lastCell As IRange = worksheet.Range("A1:E5").End

  workbook.SaveAs("Output.xlsx")
End Using

Entire Column

EntireColumn, as the name says gets the entire column of the particular range.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Last cell in the entire column
  IRange lastCell = worksheet.Range["A1"].EntireColumn.End;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Last cell in the entire column
  IRange lastCell = worksheet.Range["A1"].EntireColumn.End;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Last cell in the entire column
  Dim lastCell As IRange = worksheet.Range("A1").EntireColumn.End

  workbook.SaveAs("Output.xlsx")
End Using

NOTE

Using EntireColumn property excessively leads to time consumption and affects the performance.

Entire Row

EntireRow, as the name says gets the entire row of the particular range.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Last cell in the entire row
  IRange lastCell = worksheet.Range["A1"].EntireRow.End;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Last cell in the entire row
  IRange lastCell = worksheet.Range["A1"].EntireRow.End;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Last cell in the entire row
  Dim lastCell As IRange = worksheet.Range("A1").EntireRow.End

  workbook.SaveAs("Output.xlsx")
End Using

Formula

Formula property gets or sets the formula in specified range.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Number = 10;
  worksheet.Range["B1"].Number = 20;

  //Set formula
  worksheet.Range["C1"].Formula = "=SUM(A1:B1)";

  //Enable sheet calculations
  worksheet.EnableSheetCalculations();

  //Get the claculated value of formula
  string value = worksheet.Range["C1"].CalculatedValue;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Number = 10;
  worksheet.Range["B1"].Number = 20;

  //Set formula
  worksheet.Range["C1"].Formula = "=SUM(A1:B1)";

  //Enable sheet calculations
  worksheet.EnableSheetCalculations();

  //Get the claculated value of formula
  string value = worksheet.Range["C1"].CalculatedValue;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set values
  worksheet.Range("A1").Number = 10
  worksheet.Range("B1").Number = 20

  'Set formula
  worksheet.Range("C1").Formula = "=SUM(A1:B1)"

  'Enable sheet calculations
  worksheet.EnableSheetCalculations()

  'Get the claculated value of formula
  Dim value As String = worksheet.Range("C1").CalculatedValue

  workbook.SaveAs("Output.xlsx")
End Using

Formula Array

For more details about FormulaArray, click here.

Formula Bool Value

FormulaBoolValue gets the CalculatedValue of formula as boolean.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Number = 10;
  worksheet.Range["B1"].Number = 20;

  //Set formula
  worksheet.Range["C1"].Formula = "=SUM(A1:B1)";

  //Set boolean
  worksheet.Range["D1"].Boolean = true;

  //Set formula
  worksheet.Range["E1"].Formula = "=D1";

  //Enable sheet calculations
  worksheet.EnableSheetCalculations();

  //Get the formula boolean value
  bool value_C1 = worksheet.Range["C1"].FormulaBoolValue;
  bool value_E1 = worksheet.Range["E1"].FormulaBoolValue;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Number = 10;
  worksheet.Range["B1"].Number = 20;

  //Set formula
  worksheet.Range["C1"].Formula = "=SUM(A1:B1)";

  //Set boolean
  worksheet.Range["D1"].Boolean = true;

  //Set formula
  worksheet.Range["E1"].Formula = "=D1";                

  //Enable sheet calculations
  worksheet.EnableSheetCalculations();

  //Get the formula boolean value
  bool value_C1 = worksheet.Range["C1"].FormulaBoolValue;
  bool value_E1 = worksheet.Range["E1"].FormulaBoolValue;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set values
  worksheet.Range("A1").Number = 10
  worksheet.Range("B1").Number = 20

  'Set formula
  worksheet.Range("C1").Formula = "=SUM(A1:B1)"

  'Set boolean
  worksheet.Range("D1").Boolean = True

  'Set formula
  worksheet.Range("E1").Formula = "=D1"

  'Enable sheet calculations
  worksheet.EnableSheetCalculations()

  'Get the formula boolean value
  Dim value_C1 As Boolean = worksheet.Range("C1").FormulaBoolValue
  Dim value_E1 As Boolean = worksheet.Range("E1").FormulaBoolValue

  workbook.SaveAs("Output.xlsx")
End Using

Has Boolean

HasBoolean returns whether the range has boolean value.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Boolean = true;
  worksheet.Range["A2"].Number = 10;
  worksheet.Range["A3"].Value2 = true;

  //Get if the cell has boolean value
  bool hasBoolean_A1 = worksheet.Range["A1"].HasBoolean;
  bool hasBoolean_A2 = worksheet.Range["A2"].HasBoolean;
  bool hasBoolean_A3 = worksheet.Range["A3"].HasBoolean;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Boolean = true;
  worksheet.Range["A2"].Number = 10;
  worksheet.Range["A3"].Value2 = true;

  //Get if the cell has boolean value
  bool hasBoolean_A1 = worksheet.Range["A1"].HasBoolean;
  bool hasBoolean_A2 = worksheet.Range["A2"].HasBoolean;
  bool hasBoolean_A3 = worksheet.Range["A3"].HasBoolean;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set values
  worksheet.Range("A1").Boolean = True
  worksheet.Range("A2").Number = 10
  worksheet.Range("A3").Value2 = True

  'Get if the cell has boolean value
  Dim hasBoolean_A1 As Boolean = worksheet.Range("A1").HasBoolean
  Dim hasBoolean_A2 As Boolean = worksheet.Range("A2").HasBoolean
  Dim hasBoolean_A3 As Boolean = worksheet.Range("A3").HasBoolean

  workbook.SaveAs("Output.xlsx")
End Using

Has DataValidation

The following code snippet explains the behavior of HasDataValidation property.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Data Validation for Text Length
  IDataValidation txtLengthValidation = worksheet.Range["A3"].DataValidation;
  worksheet.Range["A1"].Text = "Enter the Text in A3";
  worksheet.Range["A1"].AutofitColumns();
  txtLengthValidation.AllowType = ExcelDataType.TextLength;
  txtLengthValidation.CompareOperator = ExcelDataValidationComparisonOperator.Between;
  txtLengthValidation.FirstFormula = "0";
  txtLengthValidation.SecondFormula = "5";

  bool validation_A1 = worksheet.Range["A1"].HasDataValidation;
  bool validation_A3 = worksheet.Range["A3"].HasDataValidation;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Data Validation for Text Length
  IDataValidation txtLengthValidation = worksheet.Range["A3"].DataValidation;
  worksheet.Range["A1"].Text = "Enter the Text in A3";
  worksheet.Range["A1"].AutofitColumns();
  txtLengthValidation.AllowType = ExcelDataType.TextLength;
  txtLengthValidation.CompareOperator = ExcelDataValidationComparisonOperator.Between;
  txtLengthValidation.FirstFormula = "0";
  txtLengthValidation.SecondFormula = "5";

  bool validation_A1 = worksheet.Range["A1"].HasDataValidation;
  bool validation_A3 = worksheet.Range["A3"].HasDataValidation;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Data Validation for Text Length
  Dim txtLengthValidation As IDataValidation = worksheet.Range("A3").DataValidation
  worksheet.Range("A1").Text = "Enter the Text in A3"
  worksheet.Range("A1").AutofitColumns()
  txtLengthValidation.AllowType = ExcelDataType.TextLength
  txtLengthValidation.CompareOperator = ExcelDataValidationComparisonOperator.Between
  txtLengthValidation.FirstFormula = "0"
  txtLengthValidation.SecondFormula = "5"

  workbook.SaveAs("Output.xlsx")
End Using

Has DateTime

The following code example illustrates the behavior of HasDateTime property.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set value through Value property
  worksheet.Range["B1"].Value = "Hello World";

  //Set date time through DatTime property
  worksheet.Range["B2"].DateTime = DateTime.Now;

  //Set value through Value2 property
  worksheet.Range["B3"].Value2 = "Hello World";

  //Set date time through Value2 property
  worksheet.Range["B4"].Value2 = DateTime.Now;

  bool dateTime_B1 = worksheet.Range["B1"].HasDateTime;
  bool dateTime_B2 = worksheet.Range["B2"].HasDateTime;
  bool dateTime_B3 = worksheet.Range["B3"].HasDateTime;
  bool dateTime_B4 = worksheet.Range["B4"].HasDateTime;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set value through Value property
  worksheet.Range["B1"].Value = "Hello World";

  //Set date time through DatTime property
  worksheet.Range["B2"].DateTime = DateTime.Now;

  //Set value through Value2 property
  worksheet.Range["B3"].Value2 = "Hello World";

  //Set date time through Value2 property
  worksheet.Range["B4"].Value2 = DateTime.Now;

  bool dateTime_B1 = worksheet.Range["B1"].HasDateTime;
  bool dateTime_B2 = worksheet.Range["B2"].HasDateTime;
  bool dateTime_B3 = worksheet.Range["B3"].HasDateTime;
  bool dateTime_B4 = worksheet.Range["B4"].HasDateTime;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set value through Value property
  worksheet.Range("B1").Value = "Hello World"

  'Set date time through DatTime property
  worksheet.Range("B2").DateTime = DateTime.Now

  'Set value through Value2 property
  worksheet.Range("B3").Value2 = "Hello World"

  'Set date time through Value2 property
  worksheet.Range("B4").Value2 = DateTime.Now

  Dim dateTime_B1 As Boolean = worksheet.Range("B1").HasDateTime
  Dim dateTime_B2 As Boolean = worksheet.Range("B2").HasDateTime
  Dim dateTime_B3 As Boolean = worksheet.Range("B3").HasDateTime
  Dim dateTime_B4 As Boolean = worksheet.Range("B4").HasDateTime

  workbook.SaveAs("Output.xlsx")
End Using

Has External Formula

The following code example illustrates the behavior of HasExternalFormula property.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set normal external formula
  worksheet.Range["C1"].Formula = "[One.xlsx]Sheet1!$A$1*5";

  //Set normal formula
  worksheet.Range["A2"].Number = 10;
  worksheet.Range["B2"].Number = 20;
  worksheet.Range["C2"].Formula = "=SUM(A2:B2)";

  bool extFormula_C1 = worksheet.Range["C1"].HasExternalFormula;
  bool extFormula_C2 = worksheet.Range["C2"].HasExternalFormula;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set normal external formula
  worksheet.Range["C1"].Formula = "[One.xlsx]Sheet1!$A$1*5";

  //Set normal formula
  worksheet.Range["A2"].Number = 10;
  worksheet.Range["B2"].Number = 20;
  worksheet.Range["C2"].Formula = "=SUM(A2:B2)";

  bool extFormula_C1 = worksheet.Range["C1"].HasExternalFormula;
  bool extFormula_C2 = worksheet.Range["C2"].HasExternalFormula;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set normal external formula
  worksheet.Range("C1").Formula = "[One.xlsx]Sheet1!$A$1*5"

  'Set normal formula
  worksheet.Range("A2").Number = 10
  worksheet.Range("B2").Number = 20
  worksheet.Range("C2").Formula = "=SUM(A2:B2)"

  Dim extFormula_C1 As Boolean = worksheet.Range("C1").HasExternalFormula
  Dim extFormula_C2 As Boolean = worksheet.Range("C2").HasExternalFormula

  workbook.SaveAs("Output.xlsx")
End Using

Has Formula

The following code example illustrates the behavior of HasFormula property.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A2"].Number = 10;
  worksheet.Range["B2"].Number = 20;

  //Set formula
  worksheet.Range["C2"].Formula = "=SUM(A2:B2)";

  bool formula_A2 = worksheet.Range["A2"].HasFormula;
  bool formula_C2 = worksheet.Range["C2"].HasFormula;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A2"].Number = 10;
  worksheet.Range["B2"].Number = 20;

  //Set formula
  worksheet.Range["C2"].Formula = "=SUM(A2:B2)";

  bool formula_A2 = worksheet.Range["A2"].HasFormula;
  bool formula_C2 = worksheet.Range["C2"].HasFormula;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set values
  worksheet.Range("A2").Number = 10
  worksheet.Range("B2").Number = 20

  'Set formula
  worksheet.Range("C2").Formula = "=SUM(A2:B2)"

  Dim formula_A2 As Boolean = worksheet.Range("A2").HasFormula
  Dim formula_C2 As Boolean = worksheet.Range("C2").HasFormula

  workbook.SaveAs("Output.xlsx")
End Using

Has Formula Array

The following code example illustrates the behavior of HasFormulaArray property.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Assign array formula
  worksheet.Range["A1:D1"].FormulaArray = "{1,2,3,4}";

  //Adding a named range for the range A1 to D1
  worksheet.Names.Add("ArrayRange", worksheet.Range["A1:D1"]);

  //Assign formula array with named range
  worksheet.Range["A2:D2"].FormulaArray = "ArrayRange+100";

  bool formulaArray = worksheet.Range["A1"].HasFormulaArray;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Assign array formula
  worksheet.Range["A1:D1"].FormulaArray = "{1,2,3,4}";

  //Adding a named range for the range A1 to D1
  worksheet.Names.Add("ArrayRange", worksheet.Range["A1:D1"]);

  //Assign formula array with named range
  worksheet.Range["A2:D2"].FormulaArray = "ArrayRange+100";

  bool formulaArray = worksheet.Range["A1"].HasFormulaArray;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Assign array formula
  worksheet.Range("A1:D1").FormulaArray = "{1,2,3,4}"

  'Adding a named range for the range A1 to D1
  worksheet.Names.Add("ArrayRange", worksheet.Range("A1:D1"))

  'Assign formula array with named range
  worksheet.Range("A2:D2").FormulaArray = "ArrayRange+100"

  Dim formulaArray As Boolean = worksheet.Range("A1").HasFormulaArray

  workbook.SaveAs("Output.xlsx")
End Using

Has Formula Bool Value

The following code example illustrates the behavior of HasFormulaBoolValue property.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set boolean
  worksheet.Range["D1"].Boolean = true;

  //Set formula
  worksheet.Range["E1"].Formula = "=D1";

  //Enable sheet calculations
  worksheet.EnableSheetCalculations();

  //Get the formula boolean value
  bool value_E1 = worksheet.Range["E1"].FormulaBoolValue;

  //Has formula boolean value
  bool hasValue_E1 = worksheet.Range["E1"].HasFormulaBoolValue;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set boolean
  worksheet.Range["D1"].Boolean = true;

  //Set formula
  worksheet.Range["E1"].Formula = "=D1";

  //Enable sheet calculations
  worksheet.EnableSheetCalculations();

  //Get the formula boolean value
  bool value_E1 = worksheet.Range["E1"].FormulaBoolValue;

  //Has formula boolean value
  bool hasValue_E1 = worksheet.Range["E1"].HasFormulaBoolValue;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set boolean
  worksheet.Range("D1").Boolean = True

  'Set formula
  worksheet.Range("E1").Formula = "=D1"

  'Enable sheet calculations
  worksheet.EnableSheetCalculations()

  'Get the formula boolean value
  Dim value_E1 As Boolean = worksheet.Range("E1").FormulaBoolValue

  'Has formula boolean value
  Dim hasValue_E1 As Boolean = worksheet.Range("E1").HasFormulaBoolValue

  workbook.SaveAs("Output.xlsx")
End Using

Has Number

HasNumber property determines whether the cell has number in it.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Number = 10;
  worksheet.Range["A2"].Text = "Sample";

  //Has number
  bool hasNumber_A1 = worksheet.Range["A1"].HasNumber;
  bool hasNumber_A2 = worksheet.Range["A2"].HasNumber;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Set values
  worksheet.Range["A1"].Number = 10;
  worksheet.Range["A2"].Text = "Sample";

  //Has number
  bool hasNumber_A1 = worksheet.Range["A1"].HasNumber;
  bool hasNumber_A2 = worksheet.Range["A2"].HasNumber;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Set values
  worksheet.Range("A1").Number = 10
  worksheet.Range("A2").Text = "Sample"

  'Has number
  Dim hasNumber_A1 As Boolean = worksheet.Range("A1").HasNumber
  Dim hasNumber_A2 As Boolean = worksheet.Range("A2").HasNumber

  workbook.SaveAs("Output.xlsx")
End Using

Has RichText

HasRichText property determines whether the cell has rich-text in it.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Add Text
  IRange range = worksheet.Range["A1"];
  range.Text = "RichText";
  IRichTextString richText = range.RichText;

  //Formatting first 4 characters
  IFont redFont = workbook.CreateFont();
  redFont.Bold = true;
  redFont.Italic = true;
  redFont.RGBColor = Color.Red;
  richText.SetFont(0, 3, redFont);

  //Formatting last 4 characters
  IFont blueFont = workbook.CreateFont();
  blueFont.Bold = true;
  blueFont.Italic = true;
  blueFont.RGBColor = Color.Blue;
  richText.SetFont(4, 7, blueFont);

  //Has RichText
  bool hasRichText = worksheet.Range["A1"].HasRichText;
  bool hasNumber_A2 = worksheet.Range["A2"].HasNumber;

  //Saving the Excel to the MemoryStream 
  MemoryStream stream = new MemoryStream();
  workbook.SaveAs(stream);

  //Set the position as '0'
  stream.Position = 0;

  //Download the PDF file in the browser
  FileStreamResult fileStreamResult = new FileStreamResult(stream, "application/excel");
  fileStreamResult.FileDownloadName = "Output.xlsx";
  return fileStreamResult;
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Add Text
  IRange range = worksheet.Range["A1"];
  range.Text = "RichText";
  IRichTextString richText = range.RichText;

  //Formatting first 4 characters
  IFont redFont = workbook.CreateFont();
  redFont.Bold = true;
  redFont.Italic = true;
  redFont.RGBColor = Color.Red;
  richText.SetFont(0, 3, redFont);

  //Formatting last 4 characters
  IFont blueFont = workbook.CreateFont();
  blueFont.Bold = true;
  blueFont.Italic = true;
  blueFont.RGBColor = Color.Blue;
  richText.SetFont(4, 7, blueFont);

  //Has RichText
  bool hasRichText = worksheet.Range["A1"].HasRichText;

  workbook.SaveAs("Output.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Add Text
  Dim range As IRange = worksheet.Range("A1")
  range.Text = "RichText"
  Dim richText As IRichTextString = range.RichText

  'Formatting first 4 characters
  Dim redFont As IFont = workbook.CreateFont()
  redFont.Bold = True
  redFont.Italic = True
  redFont.RGBColor = Color.Red
  richText.SetFont(0, 3, redFont)

  'Formatting last 4 characters
  Dim blueFont As IFont = workbook.CreateFont()
  blueFont.Bold = True
  blueFont.Italic = True
  blueFont.RGBColor = Color.Blue
  richText.SetFont(4, 7, blueFont)

  'Has RichText
  Dim hasRichText As Boolean = worksheet.Range("A1").HasRichText

  workbook.SaveAs("Output.xlsx")
End Using

For more details about RichText, click here.