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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to get cell type in 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.

Article ID: Published Date: Last Revised Date: Platform: Control:
8548 02/28/2018 04/04/2018 Windows Forms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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