ByteScout Barcode Suite – VB.NET – Remove columns from existing spreadsheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VB.NET – Remove columns from existing spreadsheet with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VB-NET-Remove-columns-from-existing-spreadsheet-with-spreadsheet-sdk.pdf

How to remove columns from existing spreadsheet with spreadsheet sdk in VB.NET and ByteScout Barcode Suite

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

On this page you will learn from code samples for programming in VB.NET.Writing of the code to remove columns from existing spreadsheet with spreadsheet sdk in VB.NET can be executed by programmers of any level using ByteScout Barcode Suite. ByteScout Barcode Suite is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK). It can remove columns from existing spreadsheet with spreadsheet sdk in VB.NET.

These VB.NET code samples for VB.NET guide developers to speed up coding of the application when using ByteScout Barcode Suite. Simply copy and paste in your VB.NET project or application you and then run your app! Complete and detailed tutorials and documentation are available along with installed ByteScout Barcode Suite if you’d like to learn more about the topic and the details of the API.

Trial version of ByteScout Barcode Suite is available for free. Source code samples are included to help you with your VB.NET app.

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)

        ' Remove Column
        worksheet.Columns.Delete(1, 1)


        ' 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