Take a look at my post Excel How To - it will show you how to export data. Once you have that datatable you just need to use proxies to walk through the hierarchy of the datatable. Here is an example doing that - adapt to your own needs.
I am new to openspan. I am not able to find the GetItem(columnName) in datarowcollectionproxy on methods. Found one method with GetItem(Index). Could you please provide the snapshot of Getitem with columnname as input?
Thank you for the automation diagram. I was able to fetch the data from the excel and display it on message box cell by cell. Instead of message box, I'm trying to input the values to form having text fields and drop-downs but the complete for loop is executing only in 1 text field and does not proceed to the next text field. Appreciate, If you could you help me, as to how, this next item can be handled? I'm looking something like below : parameterizing the text field as "getItem(columnIndex)" Please find the screenshot of my automation diagram.
I was going through your above post in order to get cell value of each cell on a table. I did exactly the same as your example shows just to test to get values but at the last block (dataRow, GetItem method), i am not getting columnName as a parameter instead i am getting columnIndex. I checked several times, everything looks good. Am i missing or doing something wrong?
I have attached the error i am getting and also the automation.
Did you enabled Office support when you installed Pega Robotics Studio? Additionally, you must have Office installed on the machine. You can enable Office support after install by changing a value in the StudioConfig.xml file. This file is found in the %appdata%\Roaming\OpenSpan folder. Change the Office key to match your installed version of Office.
Version of Microsoft.Office.Interop.Excel.dll in install folder is
Version of Microsoft.Office.Interop.Excel.dll in C:\Program Files (x86)\Microsoft Visual Studio 12.0\Visual Studio Tools for Office\PIA\Office15 is
I copied dll from C:\Program Files (x86)\Microsoft Visual Studio 12.0\Visual Studio Tools for Office\PIA\Office15 to C:\Program Files (x86)\OpenSpan\OpenSpan Studio for Microsoft Visual Studio 2015, and then Pick Type window showing 'Office' in tree.