ByteScout Barcode Suite – VB.NET – Change document properties with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VB.NET – Change document properties with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VB-NET-Change-document-properties-with-spreadsheet-sdk.pdf

How to change document properties with spreadsheet sdk in VB.NET using ByteScout Barcode Suite

This code in VB.NET shows how to change document properties with spreadsheet sdk with this how to tutorial

This sample source code below will display you how to change document properties with spreadsheet sdk in VB.NET. ByteScout Barcode Suite can change document properties with spreadsheet sdk. It can be applied from VB.NET. 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.

Want to save time? You will save a lot of time on writing and testing code as you may just take the VB.NET code from ByteScout Barcode Suite for change document properties with spreadsheet sdk below and use it in your application. Follow the instructions from scratch to work and copy the VB.NET code. If you want to use these VB.NET sample examples in one or many applications then they can be used easily.

ByteScout provides the free trial version of ByteScout Barcode Suite along with the 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 System
Imports System.Collections.Generic
Imports System.Text
Imports System.IO
Imports Bytescout.Spreadsheet

Module Module1

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

        ' Add new worksheet
        Dim worksheet As Worksheet = document.Workbook.Worksheets.Add("Sheet1")

        ' Set some properties
        document.Workbook.Properties.ApplicationName = "Bytescout Spreadsheet SDK"
        document.Workbook.Properties.Author = "Bytescout"
        document.Workbook.Properties.Comments = "Some comments"
        document.Workbook.Properties.Subject = "Some subject"


        ' 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