Studio
HomeSiteForumLanguage
  • Studio Introduction
  • DOWNLOAD
    • Download and Installation
  • Studio
    • Registration and Login
      • On Premise
    • Start a Project
      • Project with Excel Parameters
    • Notification
    • Routines
    • Use Variables
    • Favorite
    • Objects
      • Artificial Intelligence
        • IBM's Watson - Natural Language
      • Clipboard
        • Set Text
        • Get Text
        • Clear Content
      • Global Actions
        • Wait
        • Search Object Result
        • Message Box
        • Question Box
        • Check Box
        • Issue Alert
        • LOG Message
        • Customized Return
        • Timeout
      • Files
        • Change Extension
        • Find latest file
        • Find Files
        • Copy File
        • Delete File
        • File Information
        • Move File
        • Rename File
        • File Triggers
        • Check if File Exists
      • Database
        • Access
        • Run Command
        • MongoDB
        • MySQL
        • Oracle
        • PostgreSQL
        • Progress 4GL
        • SQL Server
      • Command Blocks
        • Assign Value to Variable
        • Calculate Date
        • Arithmetic Calculations with Date
        • Case
        • Call Method
        • Call Routine
        • Custom Code
        • HTML Code
        • Declare Variable
        • Else If
        • Data Structure
          • Assign Value to Property
          • Create Structure
        • End Execution
        • If
        • Include Method
        • Task List
        • Insert Task
        • Switch
        • Throw
        • Try/Catch
        • Using
      • Compression
        • Compress/Zip Files and Folders
        • Decompress/Unzip files and/or folder
      • CSV
        • Find and Replace
        • New CSV
        • Write to CSV
        • Read CSV Data
      • Dashboard
        • Progress Bar
        • Run Robot
        • Charts
          • New Chart
          • Add Chart Data
        • Grid
          • New Grid
          • Add Row
      • E-mail
        • Set Up E-mail
        • Move E-mail
        • Send E-mail
        • Read E-mail
          • Reply E-mail
          • Forward E-mail
          • Download Attachment
          • Reading Conditions
          • Read E-mail
          • Delete E-mail
          • Export E-mail
      • ERP
        • SAP
          • Call Transaction
          • Open SAP
          • Click on Element
          • Type on Field
          • Run Script
          • Read Status Bar
          • SAP Login
          • Check Selection Box
          • Get Field Value
          • Select Window
          • Select in the Field
          • Check If It Exists
        • Totvs Datasul
      • Internet
        • Open Browser
        • Open New Tab
        • Action on Elements
        • Reload Page
        • Search for Elements
        • Enter into an iFrame
        • Execute Javascript
        • Close Current Tab
        • Close Browser
        • Redirect to URL
        • Solve Captcha
          • Image
          • Recaptcha v2
          • Recaptcha v3
          • H Captcha
        • Select Tab
        • Return to Main Frame
        • Screenshot
        • Search Attribute
        • Check If Element Exists
        • Add Element Attribute
        • Remove Element Attribute
        • Select Certificate
      • Loops
        • Insert Data in the List
        • Sort List
        • Convert List into Numeric
        • Convert List to XML
        • Convert to JSON
        • Filter List
        • Reverse List
        • Free Loop
        • Clear List
        • Next Loop
        • Remove Duplicates
        • Exit Loop
        • Loop Through List
        • Check if Element Exists in the List
      • OCR
        • Image
          • Click on Text
          • Extract Text
      • Folders
        • Open Folder
        • Search for Folders
        • Copy Folder
        • New Folder
        • Delete Folder
        • Clear Folder
        • Move Folder
        • Get Files from Folder
        • Rename Folder
        • Check if Directory Exists
      • Pdf
        • Set Up PDF Extraction
        • Extract PDF Data
        • Join PDF's
        • PDF to Excel
        • PDF to Html
        • PDF to Text
        • PDF to Word
        • Split PDF
      • Excel
        • New Excel
        • Auto Adjust Column
        • Open Excel
        • Sort Columns
        • Colorize Cells
          • Select Range
        • New Macro
        • Delete Column
        • Delete Row
        • Get First Row Index
        • Get Last Row Index
        • Run Macro
        • Close Excel
        • Filter Columns
        • Conditional Formatting
        • Format Cell
        • Insert Formula
        • Add Row
        • Add Columns
        • Insert Spreadsheet
        • Clear Spreadsheet
        • Read Excel Data
          • Select Range
        • Edit Cells
        • Search for Value
        • Remove Duplicate Cells
        • Save Excel
        • Save As
        • Select Worksheet
        • Make It Visible
        • Loop Through Excel Data
        • Export to PDF
        • Export to CSV
      • PowerPoint
        • New PPT
        • Add Image PPT
        • Open PPT
        • Add Slide
        • Duplicate Slide
        • Export to PDF
        • Save PPT
        • Close PPT
      • Word
        • New Word
        • Open Word
        • Find and Replace
        • Set Layout
        • Write Document
        • Close Word
        • Insert Data into Table
        • Insert Image
        • Insert Table
        • Export to PDF
        • Save As
        • Read Word Data
          • Full Content
          • Previous Content
          • In-Between Content
          • Subsequent Content
      • HTTP Request
        • DELETE
          • Authentication
            • Basic
            • Token
            • Certificate
          • Headers
          • Body
            • Free
            • File
        • GET
          • Authentication
            • Básica - Basic
            • Token
            • Certificate
          • Headers
          • Body
            • Free
            • File
        • POST
          • Authentication
            • Basic
            • Token
            • Certificate
          • Headers
          • Body
            • Free
            • File
        • PUT
          • Authentication
            • Basic
            • Token
            • Certificate
          • Headers
          • Body
            • Free
            • File
      • Ready-Made Robots
        • Central Bank
        • Correios
        • Receita Federal
        • Simples Nacional
        • Sintegra
        • Suframa
      • Data Table
        • Load File
        • Sort Table
        • Convert to JSON
        • Convert Table to XML
        • Filter Table
        • New Table
        • Export
        • Insert Data into Table
        • Read Column
        • Delete Duplicate Itens
        • Loop Through Data Table
        • Check if Value Exists in the Data Table
      • Keyboard and Mouse
        • Mouse
        • Keyboard
      • Text
        • Find and Replace
        • Convert Text to Int
        • Convert Text to Datetime
        • New Text File
        • Write Text
        • Read Text Data
        • Get Letters
        • Get Numbers
        • Get Substring
        • Find Text
        • Split Text
        • Remove Special Characters
        • Replace Text
      • Windows
        • Open Program
        • Actions on Element
        • DLL
        • Take Screenshot
        • Find Element
        • Powershell
        • Select Window
        • Services
          • Start
          • Stop
          • Restart
          • Check Status
        • Processes
          • End by Name
        • Terminal
      • XML
        • Change Element Value
        • New XML
        • Import XML
        • Insert Group of Elements
        • Insert Elements
        • Read Element Attributes
        • Get Attribute Value
        • Delete Element Attribute
        • Read Elements
        • Select Element
        • Delete Element
        • Save XML
    • Password Vault
    • Process Recorder
    • Publish Robot
    • Examples
    • Utilities
      • XPATH
Powered by GitBook
On this page

Was this helpful?

  1. Studio
  2. Objects
  3. Excel

Format Cell

Object used to perform alignment, colors, fonts, and type formatting on an Excel worksheet.

PreviousConditional FormattingNextInsert Formula

Last updated 2 years ago

Was this helpful?

This object depends on another object: New Excel or Open Excel.

Settings

Field

Descriptive

Title

Object title

Select Main Object

Select an Excel Object

Cell

Field to define the cell that will be formatted

Select Range

Check to enable the cell selection fields

Starting Column

Initial column to be considered for the formatting

Final Column

Final column to be considered for the formatting

Starting Row

Initial row to be considered for the formatting

Final Row

Final row to be considered for the formatting

Field

Descriptive

Align to the left

Aligns text to the left

Centralized

Aligns text to the center

Align to the right

Aligns text to the right

Align up

Aligns the text on top

Align to the middle

Aligns the text in the middle

Align down

Aligns text downwards

Default

Horizontal text alignment

Vertical Alignment

Vertical text alignment

Rotate text clockwise

Rotates the text clockwise

Rotate text anticlockwise

Rotates the text anticlockwise

Auto line-breaking

Enables automatic line-breaking for the cells

Auto Width Adjustment

Adjusts column widths based on its content

Auto Height Adjustment

Adjusts the row height based on its content

Field

Descriptive

Background (color)

Background color of the cell

Font (color)

Text color

Font

Font type of the cell

Font Size

Font size of the cell

B

Bold

I

Italic

U

Underlined

T

No typography

Borderless

Delete cell borders

All borders

Adds borders to the range of cells

Outer borders

Adds outer borders to the range of cells

Field

Descriptive

Type

Data type of the cell. Ex: text, numeric, money