How to Load an Excel Page from a Variable

Even though the most common way to load a page in Design Studio is to use a Load Page step, a robot may also sometimes receive an Excel documents as input in a Binary attribute and you may want to have this document loaded into the robot so that your robot can loop and extract data from from this. This is possible, but it involves a bit of configuration and we will describe how to do this below. You start by inserting a Create Page step into your robot and configure this to get its Content from the Binary attribute, but to make this work you also have to tell the step that the data in the attribute is actually an Excel document and not just any kind of binary data. You do this by opening the Option configuration on the Create Page step. On the Page Loading tab of the Options dialog you set the Page Content Type to Same for All Pages and choose Content Type: Excel as show below.

Setting the Content Type to Excel