The sample shows steps and algorithm of how to create simple hello world spreadsheet and how to make it work in your VB.NET application. ByteScout Spreadsheet SDK: the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays. It can create simple hello world spreadsheet in VB.NET.
This code snippet below for ByteScout Spreadsheet SDK works best when you need to quickly create simple hello world spreadsheet in your VB.NET application. Follow the instructions from the scratch to work and copy the VB.NET code. Implementing VB.NET application typically includes multiple stages of the software development so even if the functionality works please test it with your data and the production environment.
ByteScout Spreadsheet SDK free trial version is available on our website. VB.NET and other programming languages are supported.
Imports Bytescout.Spreadsheet Imports System.IO Module Module1 Sub Main() Dim document As New Spreadsheet() Dim worksheet As Worksheet = document.Workbook.Worksheets.Add("HelloWorld") worksheet.Cell(0, 0).Value = "Hello, World!" ' 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