Welcome to Kofax RPA > Design Studio > Load an Excel Page from a Variable

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:

Important Design Studio may become unresponsive when working with large Excel files. To avoid that, try working with smaller Excel files. Alternatively, increase the physical memory (RAM) of the machine or allocate more memory in the memory.config.
  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 the Contents 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.

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