Skip to main content

How to Use GetCellValue and SetCellValue methods

How-to | August 7, 2019 | 01:59

When designing robots to manage data within a spreadsheet, the basics of retrieving data from a cell and then returning data to a cell is a paramount process. This video presents both simple processes using the new ExcelFile connector that is not tied a Microsoft Office version. 

How to Use GetCellValue and SetCellValue methods
Share this page Share via X Share via LinkedIn Copying...

About this Series

Product How-To's cover a wide range of topics, such as configuration, customization, workflow design, integration, data management, reporting, and more. These videos typically target users, developers, administrators, or anyone seeking practical guidance on using specific features or solving specific challenges within Pega's software ecosystem.

Related Videos

How to implement dialog boxes in an automation
Video duration: 02:29

When developing attended RPA solutions, processes and tasks require the user to interact with files. Pega Robot Studio…

Product How-to | How to implement parallel processing in a robotic automation
Video duration: 01:52

Often it is necessary to perform parallel processes in one automation by creating asynchronous threads for each process…

How to automate partial screens in text adapters
Video duration: 02:06

Mainframe systems provide lists and lists of database rows that a user must then cycle through to find the needed item. This…

How to add and invoke Javascript in an automation
Video duration: 02:16

Javascript is a universal web programming language, and often it is necessary to include custom Javascript code or invoke a…

Product How-To | How to automate receiving a new email in Outlook
Video duration: 01:47

Quite often companies use generic email accounts where customers may send their questions or issues for resolution. Being…

Product How-To | How to perform different tasks using the Switch component
Video duration: 01:13

Often the next step in a process may change or switch depending on what value or input is selected or used. This video shows…

How to retrieve Outlook emails using the Outlook connector
Video duration: 02:04

Company style email addresses are not always monitored to read emails for processing work. This video shows how to use the…

Product How-To | How to send and retrieve text from Notepad
Video duration: 01:40

Customer service representatives sometime use Notepad to capture notes to input into other system. This video shows how to…

How to configure and interrogate a text adapter
Video duration: 03:18

Interrogation regardless of application tends to be similar; however, text adapters for mainframe systems require a unique…

Product How-to | How to parse XML to locate data using the XML component
Video duration: 01:29

Often applications communicate and send data in a defined syntax, typically XML. When receiving an XML document or text, it…

View All Videos

Did you find this content helpful?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice