Create Simple Spreadsheet - VBScript
Spreadsheet SDK sample in VBScript demonstrating ‘Create Simple Spreadsheet’
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