ByteScout Data Extraction Suite – VBScript – Change row height with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – VBScript – Change row height with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-VBScript-Change-row-height-with-spreadsheet-sdk.pdf

How to change row height with spreadsheet sdk in VBScript using ByteScout Data Extraction Suite

Learning is essential in computer world and the tutorial below will demonstrate how to change row height with spreadsheet sdk in VBScript

On this page you will learn from code samples for programming in VBScript.Writing of the code to change row height with spreadsheet sdk in VBScript can be executed by programmers of any level using ByteScout Data Extraction Suite. ByteScout Data Extraction Suite: the set that includes 3 SDK products for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can change row height with spreadsheet sdk in VBScript.

Want to save time? You will save a lot of time on writing and testing code as you may just take the VBScript code from ByteScout Data Extraction Suite for change row height with spreadsheet sdk below and use it in your application. 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.

The trial version of ByteScout Data Extraction Suite can be downloaded for free from our website. It also includes source code samples for VBScript and other programming languages.

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

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

ChangeRow.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(2,2)
cell.ValueAsHTML = "test resizing"

set row = worksheet.rows.Item(1)

row.Height = 100

' 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