ByteScout Data Extraction Suite – VBScript – Create simple spreadsheet with spreadsheet sdk

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

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

How to create simple spreadsheet with spreadsheet sdk in VBScript with ByteScout Data Extraction Suite

Step-by-step tutorial on how to create simple spreadsheet with spreadsheet sdk in VBScript

Sample source code below will display you how to manage a complex task like create simple spreadsheet with spreadsheet sdk in VBScript. What is ByteScout Data Extraction Suite? It is the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can help you to create simple spreadsheet with spreadsheet sdk in your VBScript application.

This prolific sample source code in VBScript for ByteScout Data Extraction 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. Complete and detailed tutorials and documentation are available along with installed ByteScout Data Extraction Suite if you’d like to learn more about the topic and the details of the API.

The trial version of ByteScout Data Extraction Suite can be downloaded for free from our website. It also includes source code samples for VBScript and other programming languages.

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