ByteScout Barcode Suite – VBScript – Use rich text formatting with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VBScript – Use rich text formatting with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VBScript-Use-rich-text-formatting-with-spreadsheet-sdk.pdf

How to use rich text formatting with spreadsheet sdk in VBScript using ByteScout Barcode Suite

Learn to code in VBScript to use rich text formatting with spreadsheet sdk with this step-by-step tutorial

Source code documentation samples give simple and easy method to install a needed feature into your application. ByteScout Barcode Suite: the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK). It can use rich text formatting with spreadsheet sdk in VBScript.

The SDK samples given below describe how to quickly make your application do use rich text formatting 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. Use of ByteScout Barcode Suite in VBScript is also described in the documentation included along with the product.

ByteScout provides the free trial version of ByteScout Barcode Suite along with the 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)

RichTextFormatting.vbs

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

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

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

' add cell with HTML formatted text
Set cell = worksheet.Cell(1, 1)
cell.ValueAsHTML = "<b>Bold text</b> and <i>Italic text</i>"


' 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