2 results about "Pivot table" patented technology

The application discloses a kind of based on RPA realization Excel data pivot table pickup method, including RPA robot, including the following steps: S1, application RPA robot reads the data pivot table in original Excel;S2, data pivot table is set event listening;S3, return to original Excel and click data pivot table relevant area, obtain the entire data pivot table of this sheet, then determine the data pivot table object selected currently;S4, according to data pivot table object, the encoding information of data pivot table is loaded into the program of RPA robot;S5, using RPA robot, the pivot table setting rule corresponding to encoding information is applied to current Excel object.The present application can obtain existing data pivot table configuration information, and then be applied to other arbitrary Excel by RPA robot, improve the automation execution efficiency of RPA.

The present disclosure provides a data processing method, device and electronic equipment, a specific embodiment of the method includes: obtaining a plurality of filtering conditions for filtering data in a target data table and a logical relationship between the plurality of filtering conditions; determining a first value corresponding to each filtering condition in the plurality of filtering conditions, the first value corresponding to any filtering condition being determined by at least one first record obtained according to the filtering condition; performing a logical operation based on the first value and the logical relationship between the plurality of filtering conditions to determine a target record to generate a pivot table. This embodiment can simplify the process of generating a pivot table and improve the speed of generating a pivot table.