ByteScout Barcode Suite – VBScript – Create simple spreadsheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VBScript – Create simple spreadsheet with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VBScript-Create-simple-spreadsheet-with-spreadsheet-sdk.pdf

How to create simple spreadsheet with spreadsheet sdk in VBScript with ByteScout Barcode Suite

If you want to learn more then this tutorial will show how to create simple spreadsheet with spreadsheet sdk in VBScript

Create simple spreadsheet with spreadsheet sdk is simple to apply in VBScript if you use these source codes below. ByteScout Barcode Suite: the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK. It can create simple spreadsheet with spreadsheet sdk in VBScript.

This prolific sample source code in VBScript for ByteScout Barcode Suite contains various functions and other necessary options you should do calling the API to create simple spreadsheet with spreadsheet sdk. Just copy and paste the code into your VBScript application’s code and follow the instructions. This basic programming language sample code for VBScript will do the whole work for you to create simple spreadsheet with spreadsheet sdk.

Our website gives trial version of ByteScout Barcode Suite for free. It also includes documentation and source code samples.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

HelloWorld.vbs

      Set document = CreateObject("Bytescout.Spreadsheet.Spreadsheet")

document.RegistrationName = "demo"
document.RegistrationKey = "demo"

 ' Add new worksheet
Set worksheet = document.Workbook.Worksheets.Add("HelloWorld")

' get cell value
Set cell = worksheet.Item(0,0) ' you can also use worksheet.Cell_2("A1") as well

' set cell value
cell.Value = "Hello, World!"

' delete output file if exists already
Set fso = CreateObject("Scripting.FileSystemObject")
If (fso.FileExists("Output.xls")) Then fso.DeleteFile("Output.xls")
Set fso = nothing

' save document
document.SaveAs "Output.xls"

' close Spreadsheet
Set document = Nothing