Use rich text formatting with spreadsheet sdk is simple to apply in VBScript if you use these source codes below. ByteScout Data Extraction Suite 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 be applied to use rich text formatting with spreadsheet sdk using VBScript.
The following code snippet for ByteScout Data Extraction Suite works best when you need to quickly use rich text formatting with spreadsheet sdk in your VBScript application. This VBScript sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Check VBScript sample code samples to see if they respond to your needs and requirements for the project.
Trial version of ByteScout Data Extraction Suite is available for free. Source code samples are included to help you with your VBScript app.
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