ByteScout Barcode Suite - VB.NET - Number format in cells with spreadsheet sdk - ByteScout

ByteScout Barcode Suite – VB.NET – Number format in cells with spreadsheet sdk

  • Home
  • /
  • Articles
  • /
  • ByteScout Barcode Suite – VB.NET – Number format in cells with spreadsheet sdk

number format in cells with spreadsheet sdk in VB.NET using ByteScout Barcode Suite

Learn number format in cells with spreadsheet sdk in VB.NET

The documentation is crafted to assist you to apply the features on your side easily. Number format in cells with spreadsheet sdk in VB.NET can be applied with ByteScout Barcode Suite. ByteScout Barcode Suite is the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK.

This rich and prolific sample source code in VB.NET for ByteScout Barcode Suite contains various functions and options you should do calling the API to implement number format in cells with spreadsheet sdk. To use number format in cells with spreadsheet sdk in your VB.NET project or application just copy & paste the code and then run your app! These VB.NET sample examples can be used in one or many applications.

ByteScout Barcode Suite is available as a free trial. You may get it from our website along with all other source code samples for VB.NET applications.

On-demand (REST Web API) version:
 Web API (on-demand version)

On-premise offline SDK for Windows:
 60 Day Free Trial (on-premise)

Module1.vb
      
Imports Bytescout.Spreadsheet Imports System.IO Imports System.Diagnostics Module Module1 Sub Main() ' Create new Spreadsheet Dim document As New Spreadsheet() ' Get worksheet by name Dim worksheet As Worksheet = document.Workbook.Worksheets.Add("Sample") ' Set header worksheet.Cell(0, 0).Value = "Number" worksheet.Cell(0, 1).Value = "Format" ' Set variables Dim plan As Double = 3000 Dim result As Double = 3100 ' Fill cells For i As Integer = 1 To 5 worksheet.Cell(i, 0).Value = result / plan Next ' Set cells format worksheet.Cell(1, 0).NumberFormatString = "0.00" worksheet.Cell(2, 0).NumberFormatString = "0.00%" worksheet.Cell(3, 0).NumberFormatString = "mm:ss" worksheet.Cell(4, 0).NumberFormatString = "hh:mm:ss" worksheet.Cell(5, 0).NumberFormatString = "##0,0E+0" ' Set captions worksheet.Cell(1, 1).Value = "0.00" worksheet.Cell(2, 1).Value = "0.00%" worksheet.Cell(3, 1).Value = "mm:ss" worksheet.Cell(4, 1).Value = "hh:mm:ss" worksheet.Cell(5, 1).Value = "##0,0E+0" ' remove output file if already exists If File.Exists("Output.xls") Then File.Delete("Output.xls") End If ' Save document document.SaveAs("Output.xls") ' Close Spreadsheet document.Close() ' open in default spreadsheets viewer/editor Process.Start("Output.xls") End Sub End Module

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Barcode Suite Home Page

Explore ByteScout Barcode Suite Documentation

Explore Samples

Sign Up for ByteScout Barcode Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

VIDEO

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Barcode Suite Home Page

Explore ByteScout Barcode Suite Documentation

Explore Samples

Sign Up for ByteScout Barcode Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Tutorials:

prev
next