ByteScout Barcode Suite – VB.NET – Rename worksheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VB.NET – Rename worksheet with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VB-NET-Rename-worksheet-with-spreadsheet-sdk.pdf

How to rename worksheet with spreadsheet sdk in VB.NET with ByteScout Barcode Suite

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

Source code documentation samples give simple and easy method to install a needed feature into your application. What is ByteScout Barcode Suite? It 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. It can help you to rename worksheet with spreadsheet sdk in your VB.NET application.

Want to quickly learn? This fast application programming interfaces of ByteScout Barcode Suite for VB.NET plus the guidelines and the code below will help you quickly learn how to rename worksheet with spreadsheet sdk. Simply copy and paste in your VB.NET project or application you and then run your app! Use of ByteScout Barcode Suite in VB.NET is also described in the documentation included along with the product.

The trial version of ByteScout Barcode Suite can be downloaded for free from our website. It also includes source code samples for VB.NET and other programming languages.

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 As New Spreadsheet()
document.LoadFromFile("Data.xls")

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

        ' Set new worksheet name
        worksheet.Name = "Collected Data Sheet"


        ' 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