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:

  1. In the robot workflow, insert a Create Page action step.
  2. In the Contents list, select the binary variable.

    This is used to load the file into the Page View.

    To select a variable, set theContents list value selector to Variable, then select the binary variable from the list.

  3. Click More to open Options dialog.
  4. On the Page Loading tab, Page Content Type, select Same for All Pages.
  5. In the Content Type field, select Excel and click OK.

    Page Loading Same for all Pages Content Type

    The robot can now recognize the Binary data from Excel pages.