ByteScout Barcode Suite – VBScript – Save as pdf with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VBScript – Save as pdf with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VBScript-Save-as-pdf-with-spreadsheet-sdk.pdf

How to save as pdf with spreadsheet sdk in VBScript with ByteScout Barcode Suite

Step-by-step tutorial on how to save as pdf with spreadsheet sdk in VBScript

The code displayed below will guide you to install an VBScript app to save as pdf with spreadsheet sdk. ByteScout Barcode Suite is 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 save as pdf with spreadsheet sdk in VBScript.

The SDK samples given below describe how to quickly make your application do save as pdf with spreadsheet sdk in VBScript with the help of ByteScout Barcode Suite. IF you want to implement the functionality, just copy and paste this code for VBScript below into your code editor with your app, compile and run your application. Further improvement of the code will make it more robust.

ByteScout Barcode Suite free trial version is available on our website. VBScript and other programming languages are supported.

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

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

Save As PDF.vbs

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

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

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

' add a cell 
Set cell = worksheet.Cell(1, 1)
cell.Value = "Testing, Testing, Testing, Testing..."

' Save spreadsheet as PDF file:

' Save PDF with automatic page size...
document.SaveAsPDF "autosized.pdf"
' ... or save PDF with fixed page size
document.SaveAsPDF_2 "fixedsize.pdf", False ' the second parameter disables autosizing 

' close Spreadsheet
Set document = Nothing