ByteScout Spreadsheet SDK – VB.NET – Change Document Properties

Home
/
Articles
/
ByteScout Spreadsheet SDK – VB.NET – Change Document Properties

printable version:
ByteScout-Spreadsheet-SDK-VB-NET-Change-Document-Properties.pdf

How to change document properties in VB.NET using ByteScout Spreadsheet SDK

The tutorial shows how to change document properties in VB.NET

These source code samples are listed and grouped by their programming language and functions they use. ByteScout Spreadsheet SDK is the library (SDK) that is capable of writing, reading, modifying and calculating Excel and CSV spreadsheets. Most popular formulas can be calculated and reculculated with Excel installed. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays and you can use it to change document properties with VB.NET.

This rich sample source code in VB.NET for ByteScout Spreadsheet SDK includes the number of functions and options you should do calling the API to change document properties. Just copy and paste the code into your VB.NET application’s code and follow the instruction. Enjoy writing a code with ready-to-use sample VB.NET codes.

Our website provides trial version of ByteScout Spreadsheet SDK 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 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