OpenSpan works within confines of the available methods and properties of the Office connectors that are provided to us by Microsoft.
Unfortunately, there are no interface functionality with using pivot tables for Excel. You will need to collect the necessary information from the excel worksheet through the getCellValue method within the connector and build automation logic to summarize the needed info for each field.
Once you have done so you will need to then transfer the collected information to the corresponding excel sheet using the setCellValue .
No you cannot. Our connectors allow basic functionality with the excel sheet. Any additional functionality needed will have to be done through a custom script referencing the Office.Interop.Excel Namespace.
Below are a list of available functions through the Microsoft Office connector.