Read, Write, & Manipulate Data in Excel with Kofax RPA

Kofax RPA is a powerful robotic process automation platform with a simple drag-and-drop software robot designer. Kofax RPA automates manual tasks and activities like accessing web portals or desktop applications, copying and transposing data, and completing complex logic that replaces the need for human-driven actions.

In this Office Hours presentation, RPI Consultants provides demonstrations and an interactive Q&A related to reading and writing data in Excel using Kofax RPA. This function is useful for many solutions and processes, such as accessing the National Change of Address database to validate vendor or employee information.

Download PDF
Transcript

Quinn Huntsman:
All right, again, thanks everyone who is joining us here today for another one of RPI’s Office Hours. Today, we are going to be showing some cool automation with Kofax RPA and Microsoft Excel. First, I want to tell you a little bit about what Kofax RPA is just in case you don’t know. It is an RPA tool, which means robotic process automation. It has an awesome single or simple to use drag and drop interface designer. You don’t really have to know how to write code or anything to interact or build with it, and it eliminates manual tasks that end users would be typically doing like logging into websites, exporting data.

It can write reports. It can read from reports, all kinds of cool stuff. Today, we’ll be focusing on using the embedded Microsoft Excel driver and fewer in the design studio here to interact with Microsoft Excel. Without further ado, go ahead and dive in here. We want to tell you about some of our upcoming webinars in Office Hours. We have a digital signing solutions webinar coming up here shortly, May 6th at 11:00 AM Central, followed by a 1:00 PM webinar, what to do with SharePoint, and then we have another Office Hours about halfway through May on digital signatures.

Then at the end of