These source code samples are listed and grouped by their programming language and functions they use. ByteScout Spreadsheet SDK is the library (SDK) that is capable of writing, reading, modifying and calculating Excel and CSV spreadsheets. Most popular formulas can be calculated and reculculated with Excel installed. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays and you can use it to change document properties with VB.NET.
This rich sample source code in VB.NET for ByteScout Spreadsheet SDK includes the number of functions and options you should do calling the API to change document properties. Just copy and paste the code into your VB.NET application’s code and follow the instruction. Enjoy writing a code with ready-to-use sample VB.NET codes.
Our website provides trial version of ByteScout Spreadsheet SDK for free. It also includes documentation and source code samples.
Imports System Imports System.Collections.Generic Imports System.Text Imports System.IO Imports Bytescout.Spreadsheet Module Module1 Sub Main() ' Create new Spreadsheet Dim document As New Spreadsheet() ' Add new worksheet Dim worksheet As Worksheet = document.Workbook.Worksheets.Add("Sheet1") ' Set some properties document.Workbook.Properties.ApplicationName = "Bytescout Spreadsheet SDK" document.Workbook.Properties.Author = "Bytescout" document.Workbook.Properties.Comments = "Some comments" document.Workbook.Properties.Subject = "Some subject" ' 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