If I have two excel files, can I create a new file and create a pivot table in the new file .
It is a very difficult job to do but with ui vision and desktop automation it is possible to control Excel and thus create a Pivot table
If it is possible then how can I do any tutorial or documentation is available ?
It is possible to create a pivot table in Excel using UI.Vision, which is a browser automation tool that can automate repetitive tasks in web applications, including Excel. Refer this source .
If it is possible then how can I do any tutorial or documentation is available ? Give reference link.
There is no specific tutorial to create a pivot table with Excel and ui vision, you have to study the commands and understand how to control the excel menus with ui vision and it’s a long and complex job.
You have to use Xclic and Xtype to control excel with ui vision