ByteScout Data Extraction Suite – VBScript – Use rich text formatting with spreadsheet sdk

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

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

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

If you want to learn more then this tutorial will show how to use rich text formatting with spreadsheet sdk in VBScript

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.

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