ByteScout Spreadsheet SDK – VB.NET – Create Simple Hello World Spreadsheet

Home
/
Articles
/
ByteScout Spreadsheet SDK – VB.NET – Create Simple Hello World Spreadsheet

printable version:
ByteScout-Spreadsheet-SDK-VB-NET-Create-Simple-Hello-World-Spreadsheet.pdf

How to create simple hello world spreadsheet in VB.NET and ByteScout Spreadsheet SDK

How to create simple hello world spreadsheet in VB.NET

The sample shows steps and algorithm of how to create simple hello world spreadsheet and how to make it work in your VB.NET application. ByteScout Spreadsheet SDK: 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 create simple hello world spreadsheet in VB.NET.

This code snippet below for ByteScout Spreadsheet SDK works best when you need to quickly create simple hello world spreadsheet in your VB.NET application. Follow the instructions from the scratch to work and copy the VB.NET code. Implementing VB.NET application typically includes multiple stages of the software development so even if the functionality works please test it with your data and the production environment.

ByteScout Spreadsheet SDK free trial version is available on our website. VB.NET and other programming languages are supported.

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()
        Dim document As New Spreadsheet()

        Dim worksheet As Worksheet = document.Workbook.Worksheets.Add("HelloWorld")

        worksheet.Cell(0, 0).Value = "Hello, World!"

        ' 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