ByteScout Barcode Suite – VB.NET – Create worksheets with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VB.NET – Create worksheets with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VB-NET-Create-worksheets-with-spreadsheet-sdk.pdf

How to create worksheets with spreadsheet sdk in VB.NET using ByteScout Barcode Suite

How to write a robust code in VB.NET to create worksheets with spreadsheet sdk with this step-by-step tutorial

Create worksheets with spreadsheet sdk is simple to apply in VB.NET if you use these source codes below. ByteScout Barcode Suite: 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. It can create worksheets with spreadsheet sdk in VB.NET.

The SDK samples given below describe how to quickly make your application do create worksheets with spreadsheet sdk in VB.NET with the help of ByteScout Barcode Suite. Follow the instructions from scratch to work and copy the VB.NET code. Enjoy writing a code with ready-to-use sample codes in VB.NET.

Our website gives trial version of ByteScout Barcode Suite for free. It also includes documentation and source code samples.

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

Module Module1

    Sub Main()
        ' Create new Spreadsheet
        Dim document = New Spreadsheet()

        ' Add worksheets
        Dim worksheet1 As Worksheet = document.Workbook.Worksheets.Add("Demo worksheet 1")

        Dim worksheet2 As Worksheet = document.Workbook.Worksheets.Add("Demo worksheet 2")

        ' Get worksheet by name
        Dim worksheetByName As Worksheet = document.Workbook.Worksheets.ByName("Demo worksheet 2")

        ' Set cell values
        worksheet1.Cell(0, 0).Value = "This is Demo worksheet 1"

        worksheetByName.Cell(0, 0).Value = "This is Demo worksheet 2"

        ' 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