ByteScout Data Extraction Suite – VB.NET – Add columns into existing spreadsheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – VB.NET – Add columns into existing spreadsheet with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-VB-NET-Add-columns-into-existing-spreadsheet-with-spreadsheet-sdk.pdf

How to add columns into existing spreadsheet with spreadsheet sdk in VB.NET and ByteScout Data Extraction Suite

Learning is essential in computer world and the tutorial below will demonstrate how to add columns into existing spreadsheet with spreadsheet sdk in VB.NET

Source code documentation samples give simple and easy method to install a needed feature into your application. ByteScout Data Extraction Suite: the set that includes 3 SDK products for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can add columns into existing spreadsheet with spreadsheet sdk in VB.NET.

The SDK samples given below describe how to quickly make your application do add columns into existing spreadsheet with spreadsheet sdk in VB.NET with the help of ByteScout Data Extraction Suite. Simply copy and paste in your VB.NET project or application you and then run your app! Enjoy writing a code with ready-to-use sample VB.NET codes.

ByteScout Data Extraction Suite 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()
        ' Open Spreadsheet
        Dim document As New Spreadsheet()
       document.LoadFromFile("AdvancedReport.xls")

        ' Get Worksheet
        Dim worksheet As Worksheet = document.Workbook.Worksheets(0)

        ' Add new Column
        worksheet.Columns.Insert(3, 1)

        ' Set values
        worksheet.Rows(0)(2).Value = "Age"

        ' 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