ByteScout Spreadsheet SDK - VB.NET - Read Number Format In Cell - ByteScout

ByteScout Spreadsheet SDK – VB.NET – Read Number Format In Cell

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – VB.NET – Read Number Format In Cell

How to read number format in cell in VB.NET using ByteScout Spreadsheet SDK

How to code in VB.NET to read number format in cell with this step-by-step tutorial

The coding tutorials are designed to help you test the features without need to write your own code. ByteScout Spreadsheet SDK is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays. It can read number format in cell in VB.NET.

Fast application programming interfaces of ByteScout Spreadsheet SDK for VB.NET plus the instruction and the code below will help you quickly learn how to read number format in cell. In your VB.NET project or application you may simply copy & paste the code and then run your app! Code testing will allow the function to be tested and work properly with your data.

Our website provides trial version of ByteScout Spreadsheet SDK for free. It also includes documentation and source code samples.

Try ByteScout Spreadsheet SDK today: Get 60 Day Free Trial or sign up for Web API

Module1.vb
      
Imports Bytescout.Spreadsheet Imports Bytescout.Spreadsheet.Constants Imports System.IO Module Module1 Sub Main() ' Create new Spreadsheet Dim document As New Spreadsheet() document.LoadFromFile("Data.xls") ' Get worksheet by name Dim worksheet As Worksheet = document.Workbook.Worksheets.ByName("Sample") ' Check dates For i As Integer = 0 To 7 For j As Integer = 0 To 1 ' Set current cell Dim currentCell As Cell = worksheet.Cell(i, j) ' Get format type Dim formatType As NumberFormatType = currentCell.ValueDataTypeByNumberFormatString ' Write line Console.Write("Cell({0}:{1}) type is {2}. Value : ", i, j, formatType.ToString()) Select Case formatType Case formatType.DateTime ' Read datetime Dim datm As DateTime = currentCell.ValueAsDateTime ' Write date to console output Console.Write(datm.ToString()) Case formatType.General ' Write value to console output Console.Write(currentCell.Value) End Select Console.WriteLine() Next Next ' Close document document.Close() Console.ReadKey() End Sub End Module

Try ByteScout Spreadsheet SDK today: 60 Day Free Trial (on-premise version) or sign up for Web API (on demand version)

VIDEO

ON-PREMISE VERSION

Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK page

Explore ByteScout Spreadsheet SDK documentation

WEB API

Sign Up for free Web API key

Explore Web API Documentation

Tutorials:

prev
next