CN113378532A - Processing method of table file, processing device and storage medium thereof - Google Patents
Processing method of table file, processing device and storage medium thereof Download PDFInfo
- Publication number
- CN113378532A CN113378532A CN202110624130.2A CN202110624130A CN113378532A CN 113378532 A CN113378532 A CN 113378532A CN 202110624130 A CN202110624130 A CN 202110624130A CN 113378532 A CN113378532 A CN 113378532A
- Authority
- CN
- China
- Prior art keywords
- processing
- component
- processed
- file
- sequence
- 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.)
- Pending
Links
- 238000003860 storage Methods 0.000 title claims abstract description 14
- 238000003672 processing method Methods 0.000 title claims abstract description 10
- 238000000034 method Methods 0.000 claims abstract description 71
- 210000004027 cell Anatomy 0.000 description 30
- 238000010586 diagram Methods 0.000 description 10
- 238000004801 process automation Methods 0.000 description 7
- 238000012552 review Methods 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 210000003850 cellular structure Anatomy 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 230000003252 repetitive effect Effects 0.000 description 2
- 230000000712 assembly Effects 0.000 description 1
- 238000000429 assembly Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000000354 decomposition reaction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
Images
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
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a processing method of a table file, a processing device of the table file and a computer readable storage medium, wherein the method comprises the following steps: acquiring a form file to be processed; acquiring at least one corresponding processing assembly from the assembly library based on the processing items of the to-be-processed form file; wherein each processing element is configured to perform a processing operation; and adding at least one processing component into the business operation flow so as to process the table file to be processed by utilizing the at least one processing component when the business operation flow is executed. By means of the method, the processing efficiency and the processing quality of the table file can be improved.
Description
Technical Field
The present application relates to the field of automation application technologies, and in particular, to a method, an apparatus, and a computer-readable storage medium for processing a form file.
Background
Currently, many real businesses face a lot of form file processing. Due to the large number of files. Each time of statistics needs to be processed by a specially-assigned person, the accuracy of work cannot be guaranteed by a manual processing mode, and the production efficiency is seriously influenced by a large amount of repetitive basic data operation.
For example, when processing a review table and a summary table, there are a large number of formulas, and one data change may affect all reviews; in addition, if special conditions such as operation errors or service requirements exist, a large number of check and review are needed, and even recovery is difficult.
Disclosure of Invention
The technical problem mainly solved by the present application is to provide a method, an apparatus and a computer-readable storage medium for processing a table file, which can improve the processing efficiency and the processing quality of the table file.
In order to solve the technical problem, the application adopts a technical scheme that: a processing method of a table file is provided, and comprises the following steps: acquiring a form file to be processed; acquiring at least one corresponding processing assembly from the assembly library based on the processing items of the to-be-processed form file; wherein each processing element is configured to perform a processing operation; and adding at least one processing component into the business operation flow so as to process the table file to be processed by utilizing the at least one processing component when the business operation flow is executed.
Wherein, based on the processing items of the to-be-processed form file, obtaining at least one corresponding processing component from the component library, and the method comprises the following steps: analyzing the processing items of the table file to be processed to obtain a plurality of sub-processing items; and acquiring a processing component corresponding to each sub-processing item from the component library.
The method for processing the form file to be processed by using the at least one processing component includes the following steps: integrating at least one processing component according to processing items to form a processing component set; and adding the processing component set into the business operation flow so as to process the table file to be processed by utilizing the processing component set when the business operation flow is executed.
The processing assembly comprises at least one of a basic assembly, a comparison assembly, a batch processing assembly and a backup assembly; the system comprises a basic component, a comparison component, a batch processing component and a backup component, wherein the basic component is used for carrying out basic operation on table files, the comparison component is used for carrying out comparison operation on different table files, the batch processing component is used for carrying out the same operation on a plurality of table files, and the backup component is used for carrying out backup operation on the table files.
The basic operation comprises at least one of creating, copying/moving, renaming, reading, writing, inserting, deleting, merging cells and acquiring a table name; or the comparison operation comprises the comparison of the table files of different backup versions in the time interval or the version number interval.
Wherein, adding at least one processing component into the business operation process comprises: acquiring a sequence/logic component; wherein the sequence/logic component comprises a set of operations; carrying out parameter configuration on the sequence/logic component; and inserting at least one processing assembly into the sequence/logic assembly according to a preset sequence, wherein the sequence/logic assembly subjected to parameter configuration is a business operation process.
The processing method of the form file further comprises the following steps: in the process of executing the business operation flow by using the sequence/logic component, if the processing component in the sequence/logic component is interrupted due to an execution error, when the business operation flow is executed again by using the sequence/logic component, the execution is started from the interrupted processing component.
The processing method of the form file further comprises the following steps: and in the process of executing the business operation flow by using the sequence/logic assembly, if the execution is wrong, the sequence/logic assembly is repeatedly used according to the preset requirement to execute the business operation flow.
In order to solve the above technical problem, another technical solution adopted by the present application is: the processing device of the table file comprises a processor and a memory, wherein the processor is used for executing program instructions to realize the processing method of the table file, and the memory is used for storing the program instructions.
In order to solve the above technical problem, another technical solution adopted by the present application is: there is provided a computer-readable storage medium for storing program instructions that can be executed to implement the above-described method of processing a table file.
The beneficial effect of this application is: in contrast to the prior art, the present application provides a method for processing a form file, including: acquiring a form file to be processed; acquiring at least one corresponding processing assembly from the assembly library based on the processing items of the to-be-processed form file; wherein each processing element is configured to perform a processing operation; adding at least one processing component into the business operation flow so as to process the table file to be processed by utilizing the at least one processing component when the business operation flow is executed; the processing assembly capable of finishing the processing items of the form file to be processed is extracted from the assembly library based on the acquired processing items of the form file to be processed, so that the processing assembly can process the form file to be processed more pertinently; and each processing assembly only correspondingly executes one processing operation, and the division of labor among the processing assemblies is clear, so that the processing efficiency and the processing quality of the table file processing service are improved, and missing or repeated operation in the table file processing process is avoided.
Drawings
FIG. 1 is a flowchart illustrating an embodiment of a method for processing a form document provided in the present application;
FIG. 2 is a simplified structural diagram of an embodiment of step S13 shown in FIG. 1;
FIG. 3 is a simplified structural diagram of another embodiment of step S13 shown in FIG. 1;
FIG. 4 is a flowchart illustrating a method for processing a form file according to another embodiment of the present disclosure;
FIG. 5 is a flow diagram of an embodiment of a build business process provided herein;
FIG. 6 is a schematic structural diagram of an embodiment of a processing apparatus for form files provided in the present application;
FIG. 7 is a schematic structural diagram of an embodiment of a computer-readable storage medium provided in the present application.
Detailed Description
In order to make the purpose, technical solution and effect of the present application clearer and clearer, the present application is further described in detail below with reference to the accompanying drawings and examples.
Referring to fig. 1, fig. 1 is a schematic flowchart illustrating a method for processing a table file according to an embodiment of the present disclosure. It should be noted that, if the result is substantially the same, the flow sequence shown in fig. 1 is not limited in this embodiment. As shown in fig. 1, the present embodiment includes:
step S11: and acquiring a to-be-processed form file.
The method of this embodiment is used for processing a form file to be processed, where the form file to be processed may be a single form file or multiple form files, and the form of the form file to be processed may be specifically set according to actual use needs, and is not specifically limited herein. For example, when the content of a cell in a table file needs to be deleted, the table file to be processed is a single table file, and when some table files need to be merged and the like, the table file to be processed is a plurality of table files participating in merging.
In an embodiment, the form file to be processed may be obtained from a local storage or a cloud storage. It is understood that, in other embodiments, the form file currently being processed may also be used as the form file to be processed, and is not limited herein.
Step S12: and acquiring at least one corresponding processing assembly from the assembly library based on the processing items of the to-be-processed form file.
The processing items can be regarded as operation steps for processing the table to be processed. For example, if the content of the cell B in the worksheet a of the to-be-processed form file is deleted, the processing item of the to-be-processed form file is the content of the cell B in the worksheet a of the to-be-processed form file.
In one embodiment, the component library includes at least one of a base component library, a comparison component library, a batch processing component library, and a backup component library. It is understood that in other embodiments, the component library may further include other processing component libraries, which may be specifically configured according to actual use requirements and are not specifically limited herein. The basic component library comprises basic components for performing basic operation on the table file; the comparison component library comprises comparison components for performing comparison operation on different tables; the batch processing component library comprises batch processing components for performing the same operation on a plurality of table files; the backup component library comprises a backup component for performing backup operation on the table file.
In a specific embodiment, the basic component library includes basic components such as new creation, copy/move, rename, write, insert, delete, merge cells, obtain table names, and the like; the comparison component library comprises comparison components for table files of different backup versions in a time interval or a version number interval; the batch processing component library comprises batch processing components such as batch renaming, batch replacement, table file merging and the like; the backup component library includes backup components for file backup. It is to be understood that, in other embodiments, the basic component library may also include other basic components, the comparison component library may also include other comparison components, the batch processing component library may also include other batch processing components, and the backup component library may also include other backup components, which may be specifically set according to actual use needs, and are not specifically limited herein. These components may be based on cells, sheets, or workbooks, for example, copy-by-cell, copy-by-sheet, copy-by-workbook.
In this embodiment, the processing items of the form file to be processed are obtained at the same time as the form file to be processed is obtained, the processing items are analyzed to determine the processing operation required to be performed on the form file to be processed, and at least one processing component capable of completing the processing operation is obtained from the component library, that is, the number of the processing components is determined based on the number of the processing items in this embodiment. For example, when the to-be-processed form file is acquired, the content of the cell B in the worksheet a with the processing items as the to-be-processed form file is deleted and the name of the to-be-processed form file is modified, at this time, the number of the processing items of the to-be-processed form file is 2, two processing components capable of completing the processing items are acquired from the component library based on the acquired processing items, so that the acquired processing components can process the to-be-processed form file in a more targeted manner, and the processing efficiency of the to-be-processed form file is improved.
The processing components corresponding to the processing items of the form file to be processed are also multiple according to the number of the processing items, namely, each processing component is used for executing a processing operation, the division of labor among the processing components is clear, and the processing components are thinned to correspond to each processing operation, so that the processing components can process the form file to be processed more efficiently and accurately, the processing efficiency of form file processing is improved, and omission or repeated operation in the processing process of the form file is avoided.
In one embodiment, each processing item of the form file to be processed may be decomposed into a plurality of sub-processing items, and a processing component is obtained from the component library for each sub-processing item, that is, each sub-processing item corresponds to one processing component, that is, the processing components corresponding to the sub-processing items are combined according to the sub-processing items of the processing item, so that the processing component processes each processing item of the form file to be processed more specifically, and the processing quality and the processing efficiency of the form file to be processed are improved. It is understood that, in other embodiments, the processing items of the to-be-processed form file may also be processed in other manners to implement the refinement processing of the to-be-processed form file.
For convenience of description, the technical solution of the present application will be described below by taking decomposition processing of processing items of a form file to be processed as an example, but the present invention is not limited thereto.
Step S13: and adding at least one processing component into the business operation flow so as to process the table file to be processed by utilizing the at least one processing component when the business operation flow is executed.
And acquiring the table file to be processed and a processing assembly capable of processing the table file to be processed. In this embodiment, at least one processing component capable of performing processing operation on the form file to be processed, which is obtained in the above step, is added to the business operation flow, so that the form file to be processed can be processed by using the at least one processing component when the business operation flow is executed, thereby completing the processing of the form file to be processed by the processing component, and realizing efficient and accurate form file processing. Because the processing component is obtained from the component library based on the processing items of the form file to be processed, that is, the processing component is extracted after the processing logic of the form file to be processed is analyzed, when the form file with complex business logic is processed, the business logic of the form file is analyzed, and the corresponding processing component is extracted, so that the form file with complex business logic can be processed.
In one embodiment, the business operation process added with the processing component for the form file to be processed and the form file to be processed can be input into the process automation application program, and the process automation application program automatically executes the business operation process to complete the processing of the form file to be processed, so that the efficient and convenient form file processing is realized, the heavy repetitive work of business personnel is reduced, and the accuracy and the efficiency of the form file processing are ensured. The process automation application program may be a process automation application platform of the high beam robot, or may be another process automation platform, which is not specifically limited herein. In other embodiments, the process automation application may not only execute the business operation process alone, but also extract, integrate, etc. the process components based on the process items of the to-be-processed form file, that is, in this embodiment, the process automation application may also execute steps S11 to S13.
Alternatively, the business operation flow may be a sequence/logic component, and the sequence/logic component may start execution from the interrupted processing component when the execution error causes the interruption and when the business operation flow is executed by using the sequence/logic component again; the sequence/logic component can also be reused to execute the business operation flow when an error is executed in the process of the business operation flow. The sequence/logic component can be a breakpoint resume component, and the breakpoint resume component can realize that when an execution error causes interruption, execution is started from the interrupted processing component; the sequence/logic component can also be an error retry component, and the error retry component can realize that the business operation flow is repeatedly executed when an error is executed in the process of the business operation flow. It is to be understood that, in other embodiments, the sequence/logic component may also be other components such as a loop, and may be specifically configured according to actual use requirements, and is not specifically limited herein.
For example, please refer to fig. 2, wherein fig. 2 is a simplified structural diagram of an embodiment of step S13 shown in fig. 1. As shown in fig. 2, taking a business operation flow as a flow breakpoint resume component as an example, corresponding processing components extracted from a component library based on processing items of a table file to be processed are an acquire table file name component and a table file backup component, and the two processing components are added to the flow breakpoint resume component, so that the table file to be processed is processed by using the acquire table file name component and the table file backup component when the business operation flow is executed, whereas if an error occurs when the table file backup component is executed after the processing operation for acquiring the table file name is completed, the business operation flow is interrupted at this time, and when the business operation flow is executed again, the acquire table file name component which has completed the processing operation is not executed any more because the business operation flow is the breakpoint resume component, the table file backup component is directly re-executed, that is, the re-execution is directly started from the position of the previous interruption, and the repeated execution of the processing components is avoided, thereby improving the processing efficiency of the form file. When one processing assembly is used, the processing assembly is added into the sequence/logic assembly, and the processing assembly is used for processing the table file to be processed on the basis of the sequence/logic assembly; when the number of the processing components is two or more, the processing components can be added into the sequence/logic component after the placement sequence is determined, so that the table files to be processed are sequentially processed according to the smoothness of the processing components on the basis of the sequence/logic component.
In one embodiment, please refer to fig. 3, wherein fig. 3 is a simplified structural diagram of another embodiment of step S13 shown in fig. 1. As shown in fig. 3, the breakpoint resuming component and the error retry component can also be nested with each other according to actual usage requirements and then used as a sequence/logic component.
In the above embodiment, the processing component capable of completing the processing items of the to-be-processed form file is extracted from the component library based on the acquired processing items of the to-be-processed form file, that is, the processing component is obtained based on the analysis of the processing items, so that the processing component can more effectively and more specifically process the to-be-processed form file, each processing component only correspondingly executes one processing operation, and the division of labor among the processing components is clear, thereby improving the processing efficiency and the processing quality of the form file processing service, and avoiding missing or repeated operations in the processing process of the form file.
Referring to fig. 4, fig. 4 is a schematic flowchart illustrating a processing method of a form file according to another embodiment of the present application. It should be noted that, if the result is substantially the same, the flow sequence shown in fig. 4 is not limited in this embodiment. As shown in fig. 4, in the present embodiment, analyzing each processing item to obtain a plurality of sub-processing items corresponding to each processing item, and executing a business operation flow in a flow automation application program to complete processing of a form file to be processed specifically includes:
step S41: and acquiring a to-be-processed form file.
Step S41 is similar to step S11 in the above embodiment, and is not repeated here.
Step S42: and analyzing the processing items of the table file to be processed to obtain a plurality of sub-processing items.
In this embodiment, the processing item of the form file to be processed may be analyzed to obtain a plurality of sub-processing items, that is, the processing item of the form file to be processed may be refined or decomposed into each operation step. For example, taking 1 processing item of the to-be-processed form file as an example, the processing item of the to-be-processed form file is obtained by copying the contents of the cell B of the worksheet a of the to-be-processed form file into the cell D of the worksheet C, and analyzing the processing item, and the obtained sub-processing items are as follows: reading the content of the cell B of the worksheet A of the to-be-processed sheet file, copying the content of the cell B, and writing the content of the cell B in the cell D of the worksheet C.
Step S43: and acquiring a processing component corresponding to each sub-processing item from the component library.
In this embodiment, based on the analysis of each processing item, a plurality of sub-processing items corresponding to each processing item are obtained, and a processing component corresponding to each sub-processing item is obtained from the component library, that is, each sub-processing item corresponds to a processing component, and each processing component only correspondingly completes one processing operation step, so that the processing component processes each processing step of the form file to be processed more specifically, and further, the processing quality and the processing efficiency of the form file to be processed are improved. For example, each sub-transaction in a transaction in the pending form file is: reading the content of the cell B of the worksheet A of the to-be-processed sheet file, copying the content of the cell B and writing the content of the cell B into the cell D of the worksheet C, wherein the processing component for acquiring each sub-processing item from the component library based on each sub-processing item comprises the following steps: read-per-cell component, copy-per-cell component, write-per-cell component.
When the processing component is acquired from the component library, configuration parameter settings, such as input parameters, output parameters, option parameters, or miscellaneous parameters, are performed on the processing component. For example, the process components for each sub-transaction to obtain from the component library corresponding to each sub-transaction are: read-per-cell component, copy-per-cell component, write-per-cell component. The processing component corresponding to each sub-processing item is directly obtained from the component library, the processing component can process the table file to be processed by utilizing the self action of the processing component, but the processing component does not know which part of the table file to be processed needs to be processed, for example, the processing component reads the part according to the cell component, the table file to be processed comprises a plurality of cells, if the parameter setting is not carried out, the processing component reads the part according to the cell component and does not know which cell content in the table file to be processed, so the processing component can accurately process the table file to be processed according to the requirement by carrying out the parameter setting on the obtained processing component, and the omission or excessive processing of the table file to be processed is avoided. The content of the configuration parameters is not limited, and the configuration parameters can be specifically set according to actual use requirements.
For example, taking the processing component as a read-per-cell component as an example, the configuration parameters corresponding to the read-per-cell component include input parameters, output parameters, and miscellaneous parameters, where the input parameters may include "file path", "worksheet name", "cell location", and "cell content format", the output parameters may include "value/formula of cell", and the miscellaneous parameters may include "display name", where the input parameters "file path", "worksheet name", and "cell location" may make the read-per-cell component know which location in the to-be-processed table file to read, and the input parameter "cell content format" may make the read-per-cell component know the format of the read cell; the output parameter "cell value/formula" may make the read-per-cell component know why the content was output after the content was read; the miscellaneous parameter "display name" may make the user know what processing component is currently being processed, or when the processing component is specifically executed, the miscellaneous parameter "display name" may also be used to display the execution result of the current processing component, and the like.
Step S44: and integrating at least one processing component according to the processing items to form a processing component set.
In the present embodiment, a processing component set is formed by integrating at least one processing component according to processing items. The processing components are integrated according to the processing items of the to-be-processed form file, on one hand, whether the processing components acquired from the component library are correct or not can be determined again in the integration process, namely whether the corresponding processing operation can be processed or not can be determined, and on the other hand, the processing components can be sequentially arranged according to the sequence of the processing items so as to be directly used later. When the number of the processing items is 1, only the processing components corresponding to the sub-processing items can be integrated according to the sequence of the sub-processing items to form a processing component set; when there are a plurality of processing items, after the processing components corresponding to the respective sub-processing items are integrated in the order of the respective sub-processing items, it is necessary to integrate the processing component sets corresponding to the respective processing items in the total processing item so that the processing items can be directly used later.
Step S45: and adding the processing component set into the business operation flow so as to process the table file to be processed by utilizing the processing component set when the business operation flow is executed.
Step S45 is similar to step S13 in the above embodiment, and is not repeated here.
In an embodiment, the business operation process can be constructed according to actual needs, and the constructed business operation process can also be called for use. For the construction of the business operation process and the processing of the to-be-processed form file based on the constructed business operation process, please refer to fig. 5, and fig. 5 is a schematic flow diagram of an embodiment of the construction business operation process provided in the present application. As shown in fig. 5, the details are as follows:
step S51: the sequence/logic components are acquired.
In this embodiment, the component library includes a sequence/logic component library, which can directly obtain the sequence/logic components from the component library, in addition to a basic component library, an alignment component library, a batch processing component library, and a backup component library. The sequence/logic component library comprises a breakpoint resuming component, an error retry component and the like, and the required sequence/logic components can be acquired from the sequence/logic component library according to actual use requirements.
Step S52: and configuring parameters of the sequence/logic component.
In this embodiment, the business operation flow is a sequence/logic component. In this embodiment, the sequence/logic component has configuration parameters as the processing component corresponding to the processing items of the form file to be processed, where the sequence/logic component includes a group of operations, and the sequence/logic component after parameter configuration is a business operation flow, so that the sequence/logic component can perform a series of operations as required. The sequence/logic component can be a breakpoint resuming component, and the breakpoint resuming component can include an option parameter "whether to resume" and a miscellaneous parameter "display name", etc.; the sequence/logic component may also be an error retry component, which may include an option parameter "retry number" and a miscellaneous parameter "display name", among others.
Step S53: and inserting at least one processing component into the sequence/logic component according to a preset sequence so as to process the table file to be processed by utilizing the at least one processing component when the sequence/logic component is executed.
In this embodiment, at least one processing element is inserted into the sequence/logic elements in a predetermined order. If the processing components are integrated according to the above steps to form the processing component set, the processing components in the processing component set are arranged according to the processing items, that is, the processing components in the processing component set are arranged according to the preset sequence, so that the processing components in the processing component set can be inserted into the sequence/logic according to the preset sequence, so that when the form file to be processed is processed, the processing components can be sequentially processed according to the arrangement sequence of the processing components.
Taking a sequence/logic component as an example of an error retry component, the error retry component comprises an option parameter 'retry number' and a miscellaneous parameter 'display name', when a processing item is to copy the content of 5 cells of a table file to be processed, the processing component corresponding to the processing item is added into the error retry component, the flow automation application program reads the error retry component and the processing component and processes the table file to be processed by using the processing component, if an error occurs when copying to a 3 rd cell, the processing component can not perform the copy cell processing any more at this time, but because the processing component is arranged in the error retry component and is based on the option parameter 'retry number' in the error retry component, wherein the option parameter 'retry number' can be regarded as a preset requirement of the retry component, the flow automation application program repeatedly executes the processing component to repeatedly copy the 3 rd cell, and stopping execution until the repetition times exceed the preset requirement, or finishing the processing operation after the repetition is executed within the preset requirement.
It is understood that, the present embodiment constructs a business operation flow, and in other embodiments, a business operation flow that has already been constructed may also be constructed directly, for example, in an embodiment that does not need to construct a business operation flow, the above steps S51-S53 may not be executed.
Referring to fig. 6, fig. 6 is a schematic structural diagram of an embodiment of a processing apparatus for a form file provided in the present application. In the present embodiment, the processing device 60 for form files includes a processor 61 and a memory 63.
The processor 61 may also be referred to as a CPU (Central Processing Unit). The processor 61 may be an integrated circuit chip having signal processing capabilities. The processor 61 may also be a general purpose processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components. A general purpose processor may be a microprocessor or the processor 61 may be any conventional processor 61 or the like.
The memory 63 in the processing means 60 of the form file is used to store program instructions required for the operation of the processor 61.
The processor 61 is configured to execute the program instructions to implement the methods provided by any of the embodiments of the processing method of the form document of the present application and any non-conflicting combinations thereof.
Referring to fig. 7, fig. 7 is a schematic structural diagram of an embodiment of a computer-readable storage medium provided in the present application. The computer readable storage medium 70 of the embodiments of the present application stores program instructions 71, and the program instructions 71, when executed, implement the methods provided by any of the embodiments of the method for processing a form file of the present application and any non-conflicting combinations. The program instructions 71 may form a program file stored in the computer readable storage medium 70 in the form of a software product, so as to enable a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the methods according to the embodiments of the present application. And the aforementioned computer-readable storage medium 70 includes: various media capable of storing program codes, such as a usb disk, a mobile hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, or terminal devices, such as a computer, a server, a mobile phone, and a tablet.
The above description is only for the purpose of illustrating embodiments of the present application and is not intended to limit the scope of the present application, and all modifications of equivalent structures and equivalent processes, which are made by the contents of the specification and the drawings of the present application or are directly or indirectly applied to other related technical fields, are also included in the scope of the present application.
Claims (10)
1. A method for processing a tabular file, the method comprising:
acquiring a form file to be processed;
acquiring at least one corresponding processing assembly from an assembly library based on the processing items of the to-be-processed form file; wherein each processing component is used for executing a processing operation;
and adding the at least one processing component into a business operation flow so as to process the table file to be processed by utilizing the at least one processing component when the business operation flow is executed.
2. The method according to claim 1, wherein the obtaining the corresponding at least one processing component from the component library based on the processing item of the form file to be processed comprises:
analyzing the processing items of the to-be-processed form file to obtain a plurality of sub-processing items;
and acquiring the processing component corresponding to each sub-processing item from a component library.
3. The method according to claim 2, wherein the adding the at least one processing component to a business operation flow to process the table file to be processed by the at least one processing component when the business operation flow is executed comprises:
integrating the at least one processing assembly according to the processing items to form a processing assembly set;
and adding the processing component set into a business operation flow so as to process the table file to be processed by utilizing the processing component set when the business operation flow is executed.
4. The method according to any one of claims 1 to 3,
the processing assembly comprises at least one of a basic assembly, a comparison assembly, a batch processing assembly and a backup assembly;
the system comprises a basic component, a comparison component, a batch processing component and a backup component, wherein the basic component is used for carrying out basic operation on table files, the comparison component is used for carrying out comparison operation on different table files, the batch processing component is used for carrying out the same operation on a plurality of table files, and the backup component is used for carrying out backup operation on the table files.
5. The method of claim 4,
the basic operation comprises at least one of new creation, copy/move, rename, read, write, insert, delete, merge cells and obtain table names; or
The comparison operation comprises comparison of table files of different backup versions in a time interval or a version number interval.
6. The method of claim 1, wherein said adding the at least one processing component to a business process flow comprises:
acquiring a sequence/logic component; wherein the sequence/logic component comprises a set of operations;
performing parameter configuration on the sequence/logic component;
and inserting the at least one processing assembly into the sequence/logic assembly according to a preset sequence, wherein the sequence/logic assembly subjected to parameter configuration is the service operation flow.
7. The method of claim 6, further comprising:
in the process of executing the business operation flow by using the sequence/logic component, if an execution error causes interruption of a processing component in the sequence/logic component, when the sequence/logic component executes the business operation flow again, the execution is started from the interrupted processing component.
8. The method of claim 6, further comprising:
and in the process of executing the business operation flow by using the sequence/logic assembly, if the execution is wrong, the sequence/logic assembly is repeatedly used for executing the business operation flow according to a preset requirement.
9. A processing apparatus for a table file, characterized in that the processing apparatus for a table file comprises a processor and a memory, the processor is used for executing program instructions to realize the processing method for a table file according to any one of claims 1-8, and the memory is used for storing the program instructions.
10. A computer-readable storage medium for storing program instructions executable to implement the method of processing a table file according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110624130.2A CN113378532A (en) | 2021-06-04 | 2021-06-04 | Processing method of table file, processing device and storage medium thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110624130.2A CN113378532A (en) | 2021-06-04 | 2021-06-04 | Processing method of table file, processing device and storage medium thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113378532A true CN113378532A (en) | 2021-09-10 |
Family
ID=77575798
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110624130.2A Pending CN113378532A (en) | 2021-06-04 | 2021-06-04 | Processing method of table file, processing device and storage medium thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113378532A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114693271A (en) * | 2022-04-11 | 2022-07-01 | 中国工商银行股份有限公司 | RPA technology-based account automatic management method and device |
| CN117112432A (en) * | 2023-09-05 | 2023-11-24 | 中电金信软件有限公司 | Flow retry method, device, computer equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110232014A (en) * | 2019-02-25 | 2019-09-13 | 上海蔚来汽车有限公司 | Operation flow automated testing method, device, controller and medium |
| CN110389754A (en) * | 2019-06-18 | 2019-10-29 | 北京奇艺世纪科技有限公司 | Method for processing business, system, server, terminal, electronic equipment and storage medium |
| US10482150B1 (en) * | 2014-09-03 | 2019-11-19 | State Farm Mutual Automobile Insurance Company | Electronic forms interaction framework for a consistent user experience |
| CN110795095A (en) * | 2019-09-20 | 2020-02-14 | 贝壳技术有限公司 | Method and system for establishing business logic component and business component and generating page |
| CN111353286A (en) * | 2020-03-06 | 2020-06-30 | 苏宁云计算有限公司 | Table file processing method and device, computer equipment and storage medium |
| CN112527666A (en) * | 2020-12-18 | 2021-03-19 | 平安银行股份有限公司 | Automatic testing method and device for business process and computer equipment |
-
2021
- 2021-06-04 CN CN202110624130.2A patent/CN113378532A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10482150B1 (en) * | 2014-09-03 | 2019-11-19 | State Farm Mutual Automobile Insurance Company | Electronic forms interaction framework for a consistent user experience |
| CN110232014A (en) * | 2019-02-25 | 2019-09-13 | 上海蔚来汽车有限公司 | Operation flow automated testing method, device, controller and medium |
| CN110389754A (en) * | 2019-06-18 | 2019-10-29 | 北京奇艺世纪科技有限公司 | Method for processing business, system, server, terminal, electronic equipment and storage medium |
| CN110795095A (en) * | 2019-09-20 | 2020-02-14 | 贝壳技术有限公司 | Method and system for establishing business logic component and business component and generating page |
| CN111353286A (en) * | 2020-03-06 | 2020-06-30 | 苏宁云计算有限公司 | Table file processing method and device, computer equipment and storage medium |
| CN112527666A (en) * | 2020-12-18 | 2021-03-19 | 平安银行股份有限公司 | Automatic testing method and device for business process and computer equipment |
Non-Patent Citations (1)
| Title |
|---|
| 杨竑: "银行业信息化年度成果报告 2017", 北京：中国金融出版社, pages: 63 - 64 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114693271A (en) * | 2022-04-11 | 2022-07-01 | 中国工商银行股份有限公司 | RPA technology-based account automatic management method and device |
| CN117112432A (en) * | 2023-09-05 | 2023-11-24 | 中电金信软件有限公司 | Flow retry method, device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108446190B (en) | Interface test method and device | |
| CA2684822C (en) | Data transformation based on a technical design document | |
| CN110209650A (en) | The regular moving method of data, device, computer equipment and storage medium | |
| CN113378532A (en) | Processing method of table file, processing device and storage medium thereof | |
| US8904352B2 (en) | Systems and methods for processing source code during debugging operations | |
| CN108762743B (en) | Data table operation code generation method and device | |
| CN110990274B (en) | Data processing method, device and system for generating test cases | |
| CN102012857A (en) | Device and method for automatically testing web page | |
| WO2022144828A1 (en) | Target environment data seeding | |
| CN114610286A (en) | Development document generation method and device, computer equipment and storage medium | |
| CN108121774B (en) | Data table backup method and terminal equipment | |
| US9824081B2 (en) | Manipulating spreadsheet data using a data flow graph | |
| CN111177119A (en) | Database-based full-data comparison method, device, equipment and storage medium | |
| US10782942B1 (en) | Rapid onboarding of data from diverse data sources into standardized objects with parser and unit test generation | |
| US10592400B2 (en) | System and method for creating variants in a test database during various test stages | |
| CN106980617B (en) | Method and system for operating database based on JSON statement | |
| AU2015265599B2 (en) | System and method for the production of job level pre-processed backup of critical data and/or datasets in a mainframe computing environment | |
| JP6058498B2 (en) | Compiling method, program, and compiling device | |
| CN117094296A (en) | VB language-based form splitting method, intelligent terminal and storage medium | |
| CN116594887A (en) | CFD software-based automatic test method and system | |
| US11604629B1 (en) | Automatic workflow generation based on annotated code statements | |
| CN115295109A (en) | Medical data tracing method and device, storage medium and terminal equipment | |
| CN114461643A (en) | Data writing method, device, storage medium and system | |
| Pröll et al. | Precise Data Identification Services for Long Tail Research Data. | |
| CN110515653B (en) | Document generation method and device, electronic equipment and computer readable storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210910 |