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

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

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

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

Step-by-step tutorial on how to copy worksheet with spreadsheet sdk in VB.NET

Sample source code below will display you how to manage a complex task like copy worksheet with spreadsheet sdk in VB.NET. ByteScout Barcode Suite can copy worksheet 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.

This prolific sample source code in VB.NET for ByteScout Barcode Suite contains various functions and other necessary options you should do calling the API to copy worksheet with spreadsheet sdk. Follow the instructions from scratch to work and copy the VB.NET code. Applying VB.NET application mostly includes various stages of the software development so even if the functionality works please test it with your data and the production environment.

If you want to try other source code samples then the free trial version of ByteScout Barcode Suite is available for download from our website. Just try other source code samples for VB.NET.

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 Bytescout.Spreadsheet
Imports System.Diagnostics
Imports System.IO

Module Module1

    Sub Main()
        ' Open existing Spreadsheet
        Dim document As New Spreadsheet()
	document.LoadFromFile("input.xls")

        ' Create copy of worksheet
        document.Workbook.Worksheets.Copy(0, 1, "Copy of Sheet1")

        ' 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