Load an Excel Page from a Variable
Even though the most common way to load a page in Design Studio is using a Load Page step, a robot may also receive Excel documents as input in a Binary attribute. To load an Excel document into the robot to loop and extract data from Excel documents, perform the following steps:
- In the robot workflow, insert a Create Page action step.
-
In the
Contents list, select the binary variable.
This is used to load the file into the Page View.
To select a variable, set the Contents list value selector to Variable, then select the binary variable from the list.
- Click More to open Options dialog.
- On the Page Loading tab, Page Content Type, select Same for All Pages.
-
In the Content Type field, select
Excel and click
OK.
The robot can now recognize the Binary data from Excel pages.