Skip to content
Sherpa
En
EnEsPtRu
  • Knowledge Base
  • Contents
  • Sherpa RPA
    • Key Concepts
    • Deployment Diagram of Sherpa RPA
    • Installing Sherpa RPA
    • Getting Started
    • Working with Citrix
    • Working with RDP
    • External Monitoring and Logging
    • Sherpa Robot and Sherpa Assistant
    • Sherpa IDP (Template Creator)
    • Sherpa Designer
      • Key Concepts
      • Installing Sherpa Designer
      • Working in Sherpa Designer
      • REST Client
      • How to Host a Project on GitHub Using Sherpa Designer
      • Smart Assistant
      • Block Reference
        • Main Blocks
        • Application Automation
        • Browser Automation
        • Computer Vision Automation
        • Invisible Browser
        • OCR Automation
        • Orchestrator
        • SAP
        • Dialog Windows
        • Word
        • Excel
        • Outlook
        • Exchange
        • Automation R7 Office
          • Create Document
          • Open Document
          • Connect to Document
          • Save Document
          • Close Document
          • Get Cell Value
          • Write Value to Cell
          • Add Sheet
          • Delete Sheet
          • Rename Sheet
          • Switch to Sheet
          • Get Data from Range
          • Write Data to Range
          • Clear Range
          • Insert Data into Range
          • Text Search
          • Get the Number of Sheets
          • Get the Number of Rows and Columns
          • Execute Macro
          • Set Font Color/Style
          • Set Cell Borders
          • Set Cell Sizes
        • ODS/ODT Automation
        • File System
        • Clipboard
        • Lists and Dictionaries
        • Data Tables
        • Date and Time
        • Email
        • PDF
        • Text
        • FTP/SFTP
        • Processes/Services/Windows
        • Terminals
        • Registry
        • 1C
        • Databases
        • Google Sheets
        • Remote Desktop RDP/Citrix
        • Working with Archives
        • Business Functions
        • Images
        • Max
        • Telegram
        • Credentials and Security
        • Machine Learning
        • Text Analysis in NLP
        • S3 Storage
        • SSH
        • Sherpa AI Server. Folders and files
        • Sherpa AI Server. Model Requests
        • Sherpa AI Server. Agent Chats and Launches
      • URLs for Online Service Blocks
      • Robot Examples
      • Setting Up Robot Launch via Windows Task Scheduler
      • Migrating Robots from Windows to Linux
      • Operation of Attended Robots on Virtual Machines
      • Sherpa Designer: Frequently Asked Questions
    • Sherpa Orchestrator
  • Sherpa Process Discovery
  • Sherpa AI
  • Releases
  • Licenses
  • Security
  • Sherpa RPA Academy
  • Videos with Examples of Sherpa RPA Platform Work
  • Links to Distributions
  • Products in the Russian Software Registry
  • Contacts
Sherpa RPA/Sherpa Designer/Block Reference/Automation R7 Office

Automation R7 Office#

Here are the articles in this section:

Create DocumentOpen DocumentConnect to DocumentSave DocumentClose DocumentGet Cell ValueWrite Value to CellAdd SheetDelete SheetRename SheetSwitch to SheetGet Data from RangeWrite Data to RangeClear RangeInsert Data into RangeText SearchGet the Number of SheetsGet the Number of Rows and ColumnsExecute MacroSet Font Color/StyleSet Cell BordersSet Cell Sizes
← BackReply to EmailNext →Create Document
Last updated: 13 April 2026