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.
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