CN113807068B - Excel automation method based on RPA - Google Patents
Excel automation method based on RPA Download PDFInfo
- Publication number
- CN113807068B CN113807068B CN202111160136.5A CN202111160136A CN113807068B CN 113807068 B CN113807068 B CN 113807068B CN 202111160136 A CN202111160136 A CN 202111160136A CN 113807068 B CN113807068 B CN 113807068B
- Authority
- CN
- China
- Prior art keywords
- attribute
- attributes
- excel
- reading
- rpa
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 38
- 230000008569 process Effects 0.000 claims description 11
- 238000004364 calculation method Methods 0.000 claims description 3
- 238000012163 sequencing technique Methods 0.000 claims description 2
- 230000006870 function Effects 0.000 description 3
- 230000003993 interaction Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000004801 process automation Methods 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 230000003044 adaptive effect Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008602 contraction Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000007373 indentation Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
Abstract
The invention discloses an Excel automation method based on RPA, which comprises an RPA robot, and is carried out according to the following steps: s1, creating a data pivot table, and configuring attributes of the data pivot table; s2, setting a cell format and configuring the attribute of the cell format; s3, custom ordering, and configuring attributes of the custom ordering; s4, picking up the pivot table in the step S1, the unit format in the step S2 and the custom ordering in the step S3 in the Excel table, converting the picked-up relevant configuration into JSON data, and performing Excel automation operation by using the JSON data through the RAP robot. According to the invention, the RPA robot is used for performing complex Excel automatic operation, so that the working efficiency of the RPA is improved.
Description
Technical Field
The invention relates to the technical field of RPA (reactive power analysis), in particular to an Excel automation method based on RPA.
Background
The robotic flow automation RPA (Robotic process automation) is software robot-based business process automation process software. The technology can simulate human behaviors, and can automatically operate the existing manual tasks or processes, so that the working efficiency can be greatly improved.
The Excel form is the most widely applied office software at present, and is mainly applied to working scenes such as data filling, information extraction, data arrangement, data archiving and the like. Excel automation is also an important part of RPA, saving a lot of labor time for tedious and repeated Excel work and reducing the great human error cost.
When faced with Excel operations with more operation parameters and more complicated procedures, conventional RPA is more complex to implement and is also extremely unfriendly to users.
Disclosure of Invention
The invention aims to provide an Excel automation method based on RPA. According to the invention, the RPA robot is used for performing complex Excel automatic operation, so that the working efficiency of the RPA is improved.
In order to solve the technical problems, the technical scheme provided by the invention is as follows: an Excel automation method based on RPA comprises an RPA robot, a newly-built pivot table and attribute configuration pivot table;
setting a cell format and configuring the attribute of the cell format;
custom ordering, configuring the attribute of the custom ordering;
and (3) picking up the data pivot table, the cell format and the custom ordering in the Excel table, converting the picked up relevant configuration into JSON data, and performing Excel automation operation by using the JSON data through the RAP robot.
In the Excel automation method based on RPA, the attribute of the configuration pivot table comprises a pivot_table attribute and a pivot_field attribute;
the pivot_table attributes include a Name attribute, a columngand attribute, a displaymediateitems attribute, a substotal hiddenpageitems attribute, an InGridDropZones attribute, a RowAxisLayout attribute, a displayfeldcaptons attribute, a fieldlistsortassond attribute, a RowGrand attribute, a showdrilllnductors attribute, a sortuseringcustom list attribute, a displaycontexttools attribute, and a showvalueswow attribute.
The pivot_field attribute is divided into a filter field attribute, a row field attribute, a column field attribute and a value field attribute, wherein the filter field attribute, the row field attribute, the column field attribute and the value field attribute all comprise an organization attribute, a Calculation attribute, a Function attribute, a NumberFormat attribute, an enable multiple items attribute, a showalltems attribute, a pivotem attribute, a substotal attribute, a Position and an enable items selection attribute.
In the above Excel automation method based on RPA, the attribute of the configuration cell format includes a digital attribute, an alignment attribute, a font attribute, a frame attribute, a background color attribute and a protection attribute;
the digital attributes comprise a NumberFormat attribute and a NumberFormat local attribute;
the alignment attribute configuration includes an index level attribute, a horizontalialignment attribute, a Verticialignment attribute, an Orientation attribute, a Mergecells attribute, a SringToFit attribute, a WrapText attribute, and a ReadingOrder attribute;
the attributes of the font attribute configuration include Name attribute, underline attribute, bold attribute, itic attribute, size attribute, color attribute, strikethrough attribute and Superscript.
The frame attributes comprise Index attributes, color attributes and Weight attributes;
the Pattern attributes include a Pattern attribute, a Pattern Color attribute, and a Color attribute.
The protection attributes include a Locked attribute and a formula Hidden attribute.
In the foregoing Excel automation method based on RPA, the attribute of the configuration custom ordering includes a Header attribute, an Orientation attribute, a SortMethod attribute, a MatchCase attribute, and an ordering condition SortField attribute, where the ordering condition SortField attribute includes a Key attribute, a SortOn attribute, an Order attribute, a CustomOrder attribute, and a SortOn value attribute; the SortOnValue attribute includes Color attribute, pattern attribute, and ColorIndex attribute.
In the above-mentioned Excel automation method based on RPA, the data pivot table port in step S1 is picked up in the Excel table by the RAP robot, and the process is as follows:
step 1.1, calling an interface provided by a Windows system, and reading attributes from a pivot table;
step 1.2, reading a pivot_table attribute;
step 1.3, reading the field attribute of the filter;
step 1.4, reading row field attributes;
step 1.5, reading column field attributes;
step 1.6, reading the value field attribute;
and step 1.7, serializing all the read attribute data into JSON data.
In the above-mentioned Excel automation method based on RPA, the picking operation is performed on the cell format in step S2 in the Excel table by the RAP robot, and the process is as follows:
s2.1, calling an interface provided by a Windows system, and reading cell format attributes from a selected table;
s2.2, reading digital attributes and protection attributes from the selected area attributes;
s2.3, reading font attributes from the selected region attributes;
s2.4, reading an alignment attribute from the selected area attribute;
s2.5, reading frame attributes from the selected region attributes;
s2.6, reading a background color attribute from the selected area attribute;
and step S2.7, serializing all the read attribute data into JSON data.
In the above-mentioned Excel automation method based on RPA, the picking operation is performed on the custom ordering in step S3 in the Excel table by the RAP robot, and the process is as follows:
s3.1, reading Excel sorting attributes provided by a Windows system;
s3.2, respectively reading a Header attribute, an Orientation attribute, a Sortmethod attribute and a matchCase attribute from the ordering attribute;
s3.3, reading all sort condition SortField attributes from the sort attributes;
and S3.4, serializing all the read attribute data into JSON data.
Compared with the prior art, the method and the device have the advantages that the attribute of the pivot table is configured by newly creating the pivot table; configuring attributes of cell formats by setting the cell formats; configuring the attribute of the custom ordering through the custom ordering; the data pivot table, the cell format and the custom ordering are picked up in the Excel table, the relevant configuration is picked up and then converted into JSON data, and the RAP robot applies the JSON data to perform Excel automation operation. Therefore, the invention provides an effective and feasible method for complex Excel automatic operation of the RPA. Meanwhile, the Excel data pivot table picking method, the Excel cell format picking method and the Excel custom ordering picking method provide a simple and quick interaction mode for complex Excel automatic operation, reduce parameter configuration complexity, reduce use complexity of users, improve accuracy and efficiency, have strong expansibility, and can be applied to wide application scenes.
Drawings
Fig. 1 is a schematic flow chart of the present invention.
Detailed Description
The invention is further illustrated by the following examples and figures, which are not intended to be limiting.
Examples: an Excel automation method based on RPA comprises an RPA robot, wherein the RPA robot consists of an instruction set, a flow designer, a result debugger, a flow manager, a global variable manager and a toolbar.
Instruction set: the RPA storage management instruction is used for storing the RPA storage management instruction, and a user can select a required instruction to be added to the flow designer in a double-click or dragging mode to perform free design.
The flow designer: and a visual RPA flow editing platform is provided for the user.
A medium result debugger: for displaying program error information, log information, and other debug data.
Middle-flow manager: and managing RPA flow, python script and other flow files.
A global variable manager: the global variables are managed.
Middle toolbar: the intelligent recording system comprises functions of flow arrangement, debugging, intelligent recording and the like.
An Excel automation method based on RPA is performed by using an RPA robot, wherein the RPA robot is configured with related RPA instructions and parameters of a pivot table, a cell format and custom ordering, and the steps comprise:
s1, creating a data pivot table, and configuring attributes of the data pivot table; the attributes of the configuration pivot table comprise a pivot_table attribute and a pivot_field attribute;
the pivot_table attributes include a Name attribute, a columngand attribute, a displaymediateitems attribute, a substotal hiddenpageitems attribute, an InGridDropZones attribute, a RowAxisLayout attribute, a displayfeldcaptons attribute, a fieldlistsortassond attribute, a RowGrand attribute, a showdrilllnductors attribute, a sortuseringcustom list attribute, a displaycontexttools attribute, and a showvalueswow attribute.
The pivot_field attribute is divided into a filter field attribute, a row field attribute, a column field attribute and a value field attribute; the filter field attribute, the row field attribute, the column field attribute and the value field attribute all comprise an Orientation attribute, a Calculation attribute, a Function attribute, a NumberFormat attribute, an enable multiplexing items attribute, a ShowAllItems attribute, a PivotItem attribute, a Subtotals attribute, a Position and an enable items selection attribute.
S2, setting a cell format and configuring the attribute of the cell format; the attributes of the configuration cell format comprise a digital attribute, an alignment attribute, a font attribute, a frame attribute, a background color attribute and a protection attribute;
the digital attributes comprise a NumberFormat attribute and a NumberFormat local attribute;
the alignment attribute configuration includes an index level attribute, a horizontalialignment attribute, a Verticialignment attribute, an Orientation attribute, a Mergecells attribute, a SringToFit attribute, a WrapText attribute, and a ReadingOrder attribute;
the attributes of the font attribute configuration include Name attribute, underline attribute, bold attribute, itic attribute, size attribute, color attribute, strikethrough attribute and Superscript.
The frame attributes comprise Index attributes, color attributes and Weight attributes; the Index mainly refers to the numbers of different positions of the cells, and is determined by the Windows interface, which is not described herein.
The Pattern attributes include a Pattern attribute, a Pattern Color attribute, and a Color attribute.
The protection attributes include a Locked attribute and a formula Hidden attribute.
S3, custom ordering, and configuring attributes of the custom ordering; the attribute of the configuration custom ordering comprises a Header attribute, an Orientation attribute, a Sortmethod attribute, a matchCase attribute and an ordering condition SortField attribute, wherein the ordering condition SortField attribute comprises a Key attribute, a SortOn attribute, an Order attribute, a Customorder attribute and a SortOnValue attribute; the SortOnValue attribute includes Color attribute, pattern attribute, and ColorIndex attribute.
In order that those skilled in the art can better understand the related art terms related to the embodiments of the present invention, the related terms are further explained in the form of table 1.
ShowAllItems | Displaying all items | PivotItem | Perspective item |
Subtotals | Small counter | Position | Position of |
EnableItemSelection | Enabling item selection | ||
NumberFormat | Digital format | NumberFormatLocal | Local digital format |
IndentLevel | Level of indentation | HorizontalAlignment | Horizontal alignment of |
VerticalAlignment | Vertical alignment of | Orientation | Direction |
MergeCells | Merging cells | ShrinkToFit | Adaptive contraction |
WrapText | Text linefeed | ReadingOrder | Reading sequence |
Name | Name of the name | Underline | Underline line |
Bold | Bold face | Italic | Italics body |
Size | Word size | Color | Font color |
Strikethrough | Strikethrough | Superscript | Superscript |
Index | Frame index | Color | Frame color |
Weight | Frame thickness | Pattern | Pattern and method for producing the same |
PatternColor | Pattern color | Color | Color of |
Locked | Locking | FormulaHidden | Hidden formula |
Header | Whether or not to contain a title | Orientation | Direction |
SortMethod | Ordering mode | MatchCase | Case-to-case |
SortField | Ordering field | Key | Key column |
SortOn | Ordering of | Order | Ordering order |
CustomOrder | Custom order | SortOnValue | Ranking value |
Color | Color of | Pattern | Pattern and method for producing the same |
ColorIndex | Color index |
TABLE 1
S4, picking up the data pivot table in the step S1, the cell format in the step S2 and the custom ordering in the step S3 in an Excel table, picking up relevant configuration, converting the relevant configuration into JSON data (JSON (JavaScript Object Notation, JS object numbered) is a lightweight data exchange format, storing and representing the data based on ECMAScript (JS specification formulated by European computer Association) in a text format completely independent of programming language, simplifying and clearly layering the JSON into an ideal data exchange language, facilitating human reading and writing, facilitating machine parsing and generation, effectively improving network transmission efficiency, and performing Excel automation operation by using the JSON data through a RAP robot.
Specifically, the data pivot table port in the step S1 is picked up in the Excel table by the RAP robot, and the process is as follows:
step 1.1, calling an interface provided by a Windows system, and reading attributes from a pivot table;
step 1.2, reading a pivot_table attribute;
step 1.3, reading the field attribute of the filter;
step 1.4, reading row field attributes;
step 1.5, reading column field attributes;
step 1.6, reading the value field attribute;
and step 1.7, serializing all the read attribute data into JSON data.
The cell format in step S2 is picked up by the RAP robot in the Excel table, and the process is as follows:
s2.1, calling an interface provided by a Windows system, and reading cell format attributes from a selected table;
s2.2, reading digital attributes and protection attributes from the selected area attributes;
s2.3, reading font attributes from the selected region attributes;
s2.4, reading an alignment attribute from the selected area attribute;
s2.5, reading frame attributes from the selected region attributes;
s2.6, reading a background color attribute from the selected area attribute;
and step S2.7, serializing all the read attribute data into JSON data.
The self-defined sorting in the step S3 is picked up in the Excel table by the RAP robot, and the process is as follows:
s3.1, calling an interface provided by a Windows system to read Excel sequencing attributes;
s3.2, respectively reading a Header attribute, an Orientation attribute, a Sortmethod attribute and a matchCase attribute from the ordering attribute;
s3.3, reading all sort condition SortField attributes from the sort attributes;
and S3.4, serializing all the read attribute data into JSON data.
The Excel newly-built data pivot table based on the RPA provided by the embodiment of the invention sets the cell format and the custom ordering, and provides an effective and feasible method for complex Excel automatic operation of the RPA. Meanwhile, the Excel data pivot table picking method, the Excel cell format picking method and the Excel custom ordering picking method provide a simple and quick interaction mode for complex Excel automatic operation, reduce parameter configuration complexity, improve accuracy and efficiency, and are high in expansibility, and can be used in a wide application scene.
Claims (4)
1. An Excel automation method based on RPA, which comprises an RPA robot and is characterized in that: newly creating a pivot table and configuring the attribute of the pivot table;
setting a cell format and configuring the attribute of the cell format;
custom ordering, configuring the attribute of the custom ordering;
picking up the data pivot table, the cell format and the custom ordering in the Excel table, converting the picked up relevant configuration into JSON data, and performing Excel automation operation by using the JSON data through the RPA robot;
the attributes of the configuration pivot table comprise a pivot_table attribute and a pivot_field attribute;
the pivot_table attribute comprises a Name attribute, a ColumnGrand attribute, a displayImediateITes attribute, a SubtotalHiddenPageItems attribute, an InGridDropZones attribute, a RowAxisLayout attribute, a displayFieldCaptins attribute, a FieldListSortAssistening attribute, a RowGrand attribute, a ShowDrilIndusters attribute, a SortUsingCurtLists attribute, a displayContextToolts attribute and a ShowValuesRow attribute;
the pivot_field attribute is divided into a filter field attribute, a row field attribute, a column field attribute and a value field attribute; the filter field attribute, the row field attribute, the column field attribute and the value field attribute all comprise an Orientation attribute, a Calculation attribute, a Function attribute, a NumberFormat attribute, an enable multiplexing items attribute, a ShowAllItems attribute, a PivotItem attribute, a Subtotals attribute, a Position attribute and an enable items selection attribute;
the attributes of the configuration cell format comprise a digital attribute, an alignment attribute, a font attribute, a frame attribute, a background color attribute and a protection attribute;
the digital attributes comprise a NumberFormat attribute and a NumberFormat local attribute;
the alignment attribute configuration comprises an index level attribute, a horizontality attribute, a Verticialign attribute, an Orientation attribute, a Mergecells attribute, a SringToFit attribute, a WRPATEX attribute and a ReadingOrder attribute;
the attribute of the font attribute configuration comprises a Name attribute, an Underline attribute, a Bold attribute, an Italic attribute, a Size attribute, a Color attribute, a Strikethrough attribute and Superscript;
the frame attributes comprise Index attributes, color attributes and Weight attributes;
the background Color attribute comprises a Pattern attribute, a Pattern Color attribute and a Color attribute;
the protection attribute comprises a Locked attribute and a formula Hidden attribute;
the attribute of the configuration custom ordering comprises a Header attribute, an Orientation attribute, a Sortmethod attribute, a matchCase attribute and an ordering condition SortField attribute, wherein the ordering condition SortField attribute comprises a Key attribute, a SortOn attribute, an Order attribute, a Customorder attribute and a SortOnValue attribute; the SortOnValue attribute includes Color attribute, pattern attribute, and ColorIndex attribute.
2. The RPA-based Excel automation method of claim 1, characterized in that: the data pivot table port is picked up in the Excel table by the RPA robot, and the process is as follows:
step 1.1, calling an interface provided by a Windows system, and reading attributes from a pivot table;
step 1.2, reading a pivot_table attribute;
step 1.3, reading the field attribute of the filter;
step 1.4, reading row field attributes;
step 1.5, reading column field attributes;
step 1.6, reading the value field attribute;
and step 1.7, serializing all the read attribute data into JSON data.
3. The RPA-based Excel automation method of claim 1, characterized in that: the cell format is picked up in the Excel table by the RPA robot, and the process is as follows:
s2.1, calling an interface provided by a Windows system, and reading cell format attributes from a selected table;
s2.2, reading digital attributes and protection attributes from the selected area attributes;
s2.3, reading font attributes from the selected region attributes;
s2.4, reading an alignment attribute from the selected area attribute;
s2.5, reading frame attributes from the selected region attributes;
s2.6, reading a background color attribute from the selected area attribute;
and step S2.7, serializing all the read attribute data into JSON data.
4. The RPA-based Excel automation method of claim 1, characterized in that: the self-defined sorting is picked up in the Excel table by the RPA robot, and the process is as follows:
s3.1, calling an interface provided by a Windows system to read Excel sequencing attributes;
s3.2, respectively reading a Header attribute, an Orientation attribute, a Sortmethod attribute and a matchCase attribute from the ordering attribute;
s3.3, reading all sort condition SortField attributes from the sort attributes;
and S3.4, serializing all the read attribute data into JSON data.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111160136.5A CN113807068B (en) | 2021-09-30 | 2021-09-30 | Excel automation method based on RPA |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111160136.5A CN113807068B (en) | 2021-09-30 | 2021-09-30 | Excel automation method based on RPA |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113807068A CN113807068A (en) | 2021-12-17 |
CN113807068B true CN113807068B (en) | 2024-01-26 |
Family
ID=78897194
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111160136.5A Active CN113807068B (en) | 2021-09-30 | 2021-09-30 | Excel automation method based on RPA |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113807068B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115983221B (en) * | 2023-03-17 | 2023-06-20 | 杭州实在智能科技有限公司 | Visual RPA table operation recording and automatic executing method and system |
Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2017214665A1 (en) * | 2016-06-14 | 2017-12-21 | Ip Now Pty Ltd | Improvements in or relating to forms |
CN110399420A (en) * | 2019-07-30 | 2019-11-01 | 广州吉信网络科技开发有限公司 | A kind of deriving method, electronic equipment and the medium of configurableization Excel format |
CN112016424A (en) * | 2020-03-31 | 2020-12-01 | 北京来也网络科技有限公司 | Image data processing method and electronic equipment combining RPA and AI |
JP2020197997A (en) * | 2019-06-04 | 2020-12-10 | さくら情報システム株式会社 | Information processing device, method and program |
CN112069206A (en) * | 2020-03-31 | 2020-12-11 | 北京来也网络科技有限公司 | Data query method, device, medium and computing device based on RPA and AI |
CN112099972A (en) * | 2020-09-08 | 2020-12-18 | 中国平安人寿保险股份有限公司 | Office file processing method, device, equipment and storage medium based on RPA robot |
CN112149399A (en) * | 2020-09-25 | 2020-12-29 | 北京来也网络科技有限公司 | Table information extraction method, device, equipment and medium based on RPA and AI |
CN112232198A (en) * | 2020-10-15 | 2021-01-15 | 北京来也网络科技有限公司 | Table content extraction method, device, equipment and medium based on RPA and AI |
CN112558954A (en) * | 2020-12-29 | 2021-03-26 | 北京来也网络科技有限公司 | Information extraction method, device, medium and electronic equipment combining RPA and AI |
CN113011142A (en) * | 2021-03-11 | 2021-06-22 | 南京信息职业技术学院 | Excel document intelligent filling system and method based on RPA |
CN113240392A (en) * | 2021-05-17 | 2021-08-10 | 远光软件股份有限公司 | Report generation method and system based on robot process automation |
CN113391871A (en) * | 2021-08-17 | 2021-09-14 | 杭州实在智能科技有限公司 | RPA element intelligent fusion picking method and system |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US11568666B2 (en) * | 2019-08-06 | 2023-01-31 | Instaknow.com, Inc | Method and system for human-vision-like scans of unstructured text data to detect information-of-interest |
US11200539B2 (en) * | 2019-10-15 | 2021-12-14 | UiPath, Inc. | Automatic completion of robotic process automation workflows using machine learning |
-
2021
- 2021-09-30 CN CN202111160136.5A patent/CN113807068B/en active Active
Patent Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2017214665A1 (en) * | 2016-06-14 | 2017-12-21 | Ip Now Pty Ltd | Improvements in or relating to forms |
JP2020197997A (en) * | 2019-06-04 | 2020-12-10 | さくら情報システム株式会社 | Information processing device, method and program |
CN110399420A (en) * | 2019-07-30 | 2019-11-01 | 广州吉信网络科技开发有限公司 | A kind of deriving method, electronic equipment and the medium of configurableization Excel format |
CN112016424A (en) * | 2020-03-31 | 2020-12-01 | 北京来也网络科技有限公司 | Image data processing method and electronic equipment combining RPA and AI |
CN112069206A (en) * | 2020-03-31 | 2020-12-11 | 北京来也网络科技有限公司 | Data query method, device, medium and computing device based on RPA and AI |
CN112099972A (en) * | 2020-09-08 | 2020-12-18 | 中国平安人寿保险股份有限公司 | Office file processing method, device, equipment and storage medium based on RPA robot |
CN112149399A (en) * | 2020-09-25 | 2020-12-29 | 北京来也网络科技有限公司 | Table information extraction method, device, equipment and medium based on RPA and AI |
CN112232198A (en) * | 2020-10-15 | 2021-01-15 | 北京来也网络科技有限公司 | Table content extraction method, device, equipment and medium based on RPA and AI |
CN112558954A (en) * | 2020-12-29 | 2021-03-26 | 北京来也网络科技有限公司 | Information extraction method, device, medium and electronic equipment combining RPA and AI |
CN113011142A (en) * | 2021-03-11 | 2021-06-22 | 南京信息职业技术学院 | Excel document intelligent filling system and method based on RPA |
CN113240392A (en) * | 2021-05-17 | 2021-08-10 | 远光软件股份有限公司 | Report generation method and system based on robot process automation |
CN113391871A (en) * | 2021-08-17 | 2021-09-14 | 杭州实在智能科技有限公司 | RPA element intelligent fusion picking method and system |
Also Published As
Publication number | Publication date |
---|---|
CN113807068A (en) | 2021-12-17 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20220129476A1 (en) | Enhanced mechanisms for managing multidimensional data | |
US7694278B2 (en) | Data cube script development and debugging systems and methodologies | |
Heer et al. | Graphical histories for visualization: Supporting analysis, communication, and evaluation | |
US6828988B2 (en) | Interactive tooltip | |
US7716253B2 (en) | Centralized KPI framework systems and methods | |
US8271891B1 (en) | Computing environment logbook | |
CN101196963B (en) | Indexing system and method of generic chemical structure | |
CN110442620A (en) | A kind of big data is explored and cognitive approach, device, equipment and computer storage medium | |
CN113807068B (en) | Excel automation method based on RPA | |
CN103279455A (en) | Spreadsheet style processing method and device | |
CN101038583B (en) | Gold report generating and generating method thereof | |
JP7339628B2 (en) | Online report creation system using Excel tools | |
US20080147587A1 (en) | Decision support system | |
CN115269101A (en) | Method for realizing Excel data pivot table pickup based on RPA | |
CN113885855A (en) | RPA instruction intelligent recording method based on input following | |
CN107451283A (en) | The analysis method and device of data | |
CN113419707A (en) | SU plug-in splitting system and method based on automatic crawler | |
CN111145038A (en) | Power grid regulation and control big data interactive analysis method based on visual data flow graph | |
CN111610969B (en) | Robot offline program adding method, system, device and storage medium | |
CN115221849B (en) | Report filling method, computer equipment and storage medium | |
CN112860701B (en) | System and method for modeless frame data transmission based on Revit | |
WO2012108972A2 (en) | System, process and article of manufacture for automatic generation of subsets of existing databases | |
CN110287577A (en) | A kind of acquisition hydrostatic thrust bearing oil film three-dimensional pressure field method | |
CN113590697A (en) | excel import access database system | |
CN117608536A (en) | Gap data online template customization and supplementary recording system and method thereof |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |