Set Range

Category

Excel Commands

Description

This command sets the value of a cell. Use this command when you want to set a value to a specific cell.

Parameters

Instance Name

Indicate the instance name for the selected workbook

Range

Enter the Cell Location (ex. A1 or B2)

Text

Enter the text value that will be set

Apply style

Set to apply this style

Background Color

Choose the background color

Font Name

Select Font name from the list

Font Size

Enter the font size to set size

Font Color

Choose the font color

Bold

Set bold to the the text

Italic

Set italic to the the text

Underline

Set underline to the the text

Returned Value

This command does not have returned value.

Example Usage

Example Location:

BYpass\Examples\Excel Commands\Set Range\Set Range.xml

See Also

• Add Workbook

• Add Worksheet

• Append Cell

• Append Row

• Close Workbook

• Copy Worksheet

• Delete Cell

• Delete Row

• Excel Create Datatable

• Export to PDF

• Get Cell

• Get Cell Style

• Get Last Column Index

• Get Last Row Index

• Get Range

• Get Range As Datatable

• Get Worksheets

• Go To Cell

• Insert Cell

• Lookup Range

• Open Workbook

• Remove Duplicate

• Run Macro

• Save Workbook

• Save Workbook As

• Write Range

• Write Row