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.
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