We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to get cell type in XlsIO?

Platform: WinForms |
Control: XlsIO

This article explains how to get cell type in XlsIO using C#/VB.NET.

What is cell type?

Cell type specifies data type of the cell in the worksheet. The cell type in XlsIO can be Blank, Error, Boolean, Number, Formula and String.

To get the cell type, you need to follow the below steps.

Steps to get cell type

  1. Get the cell’s range to get the cell type.
  2. Use the WorksheetImpl.GetCellType(int row, int column, bool bNeedFormulaSubType) to get the cell type.


To know more about cell manipulation in XlsIO, please refer the documentation.

Download Input file

Download complete sample

The following C#/VB.NET complete code snippet shows how to get cell type in XlsIO.



The following screenshot shows the output generated by XlsIO after getting the cell type.

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile