CN112183040A - Voucher generation method and related device - Google Patents
Voucher generation method and related device Download PDFInfo
- Publication number
- CN112183040A CN112183040A CN202011033332.1A CN202011033332A CN112183040A CN 112183040 A CN112183040 A CN 112183040A CN 202011033332 A CN202011033332 A CN 202011033332A CN 112183040 A CN112183040 A CN 112183040A
- Authority
- CN
- China
- Prior art keywords
- subject
- cell data
- selection
- target
- target area
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 230000006870 function Effects 0.000 claims description 8
- 230000014509 gene expression Effects 0.000 claims description 8
- 230000008569 process Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 230000004044 response Effects 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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application discloses a voucher generation method and a related device, which are used for meeting the requirement that a voucher template can flexibly acquire cell data from an EXCEL form. The method in the embodiment of the application comprises the following steps: acquiring an EXCEL form and a certificate template; determining a target area to be associated in the EXCEL table; determining the subjects needing to be associated in the certificate template and subject filling areas corresponding to the subjects; associating the target area with the subject; receiving a selection operation of the subject in the credential template; receiving a selection of target data in the target area associated with the subject; and filling the subject filling area in the certificate template with the target data to generate a certificate.
Description
Technical Field
The embodiment of the application relates to the technical field of data processing, in particular to a certificate generation method and a related device.
Background
EXCEL, also called EXCEL form, is a spreadsheet software developed by Microsoft corporation, and is mainly used for processing computer data. EXCEL has an intuitive interface, excellent computing functionality and graphical tools, coupled with successful marketing, making EXCEL the most popular computer data processing software today.
At present, the calculation processing of business data in many enterprises is performed by EXCEL, and particularly in the financial aspect of the enterprises, financial staff need to perform a large amount of data calculation processing by using EXCEL every month, and then obtain a corresponding processing result in an EXCEL form, and then can fixedly read cell data fixed in the EXCEL form through a credential template preset by an Enterprise Resource Planning (ERP) system of the company to generate a required credential.
However, this kind of credential template can only fix the method for obtaining the cell data, and cannot satisfy the requirement of flexibly obtaining the required cell data from the EXCEL form.
Disclosure of Invention
The embodiment of the application provides a voucher generation method and a related device, so as to meet the requirement that a voucher template can flexibly acquire cell data from an EXCEL form.
A first aspect of the present application provides a credential generation method, including:
acquiring an EXCEL form and a certificate template;
determining a target area to be associated in the EXCEL table;
determining the subjects needing to be associated in the certificate template and subject filling areas corresponding to the subjects;
associating the target area with the subject;
receiving a selection operation of the subject in the credential template;
receiving a selection of target data in the target area associated with the subject;
and filling the subject filling area in the certificate template with the target data to generate a certificate.
Optionally, after receiving the selection operation of the subject in the credential template, before receiving the selection of the subject-associated target data in the target area, the method further comprises:
and popping up the target area associated with the subject according to the selection operation.
Optionally, the determining a target area to be associated in the EXCEL table includes:
determining a plurality of continuous rows and/or columns to be associated in the EXCEL table;
or the like, or, alternatively,
and determining a plurality of rows and/or columns to be associated in the EXCEL table through function expressions.
Optionally, when the target area is a table area with M consecutive rows and N consecutive columns, and a first row of the table area is a header row, where M is a positive integer greater than zero, and N is a positive integer greater than zero;
the associating the target area with the subject comprises:
associating cell data of x cells in the title row with the subject for the first time, wherein x is a positive integer greater than 0 and less than or equal to M;
performing second association on each unit cell data and the corresponding N-1 column unit cell data;
the popping up the target area associated with the subject according to the selection operation comprises:
popping up the x cell data according to the first selection of the selection operation;
receiving a second selection of a target cell data of the x cell data;
popping up the N-1 column unit cell data associated with the target unit cell data for the second time according to the second selection;
the receiving a selection of target data in the target area associated with the subject comprises:
receiving a selection of a number of the N-1 columns of cell data.
Optionally, when the target area is a table area with M consecutive rows and N consecutive columns, and a first column of the table area is a header column, where M is a positive integer greater than zero, and N is a positive integer greater than zero;
the associating the target area with the subject comprises:
associating cell data of y cells in the title column with the subject for the first time, wherein y is a positive integer which is greater than 0 and less than or equal to N;
performing second association on each cell data and the corresponding M-1 rows of cell data;
the popping up the target area associated with the subject according to the selection operation comprises:
popping up the y cell data according to the first selection of the selection operation;
receiving a second selection of a target cell data of the y cell data;
popping up the M-1 row cell data associated with the target cell data for the second time according to the second selection;
the receiving a selection of target data in the target area associated with the subject comprises:
a selection of a number of the M-1 rows of cell data is received.
Optionally, after receiving the selection of the target data in the target area, the method further comprises:
storing the selected target data to form an array;
and when the selection operation of the subjects in the certificate template is received again, displaying the array, receiving the selection of the array, triggering the step of filling the subject filling area in the certificate template with the target data and generating the certificate.
Optionally, after forming the array, before receiving a selection operation of the subject in the credential template again, the method further includes:
judging whether the memory occupancy rate exceeds a preset threshold value or not;
if the memory occupancy rate does not exceed the preset threshold value, loading the array into a memory;
and if the memory occupancy exceeds a preset threshold, triggering a step of displaying the array when the selection operation of the subjects in the certificate template is received again.
A second aspect of the present application provides a credential generation system, including:
the acquiring unit is used for acquiring the EXCEL form and the certificate template;
the first determining unit is used for determining a target area to be associated in the EXCEL table;
the second determining unit is used for determining the subjects needing to be associated in the certificate template and the subject filling areas corresponding to the subjects;
the association unit is used for associating the target area with the subject;
a first receiving unit, configured to receive a selection operation on the subject in the credential template;
a second receiving unit, configured to receive a selection of target data in the target area associated with the subject;
and the filling unit is used for filling the subject filling area in the certificate template with the target data to generate a certificate.
Optionally, the system further comprises:
and the ejection unit is used for ejecting the target area associated with the subject according to the selection operation.
Optionally, when determining the target area to be associated in the EXCEL table, the first determining unit is specifically configured to:
determining a plurality of continuous rows and/or columns to be associated in the EXCEL table;
or the like, or, alternatively,
and determining a plurality of rows and/or columns to be associated in the EXCEL table through function expressions.
Optionally, when the target area is a table area with M consecutive rows and N consecutive columns, and a first row of the table area is a header row, where M is a positive integer greater than zero, and N is a positive integer greater than zero;
when the associating unit associates the target area with the subject, the associating unit is specifically configured to:
associating cell data of x cells in the title row with the subject for the first time, wherein x is a positive integer greater than 0 and less than or equal to M;
performing second association on each unit cell data and the corresponding N-1 column unit cell data;
when the popup unit pops up the target area associated with the subject according to the selection operation, the popup unit is specifically configured to:
popping up the x cell data according to the first selection of the selection operation;
receiving a second selection of a target cell data of the x cell data;
popping up the N-1 column unit cell data associated with the target unit cell data for the second time according to the second selection;
the second receiving unit, when receiving the selection of the target data in the target area associated with the subject, is specifically configured to:
receiving a selection of a number of the N-1 columns of cell data.
Optionally, when the target area is a table area with M consecutive rows and N consecutive columns, and a first column of the table area is a header column, where M is a positive integer greater than zero, and N is a positive integer greater than zero;
when the target area is associated with the subject, the associating unit is specifically configured to:
associating cell data of y cells in the title column with the subject for the first time, wherein y is a positive integer which is greater than 0 and less than or equal to N;
performing second association on each cell data and the corresponding M-1 rows of cell data;
when the popup unit pops up the target area associated with the subject according to the selection operation, the popup unit is specifically configured to:
popping up the y cell data according to the first selection of the selection operation;
receiving a second selection of a target cell data of the y cell data;
popping up the M-1 row cell data associated with the target cell data for the second time according to the second selection;
the second receiving unit, when receiving the selection of the target data in the target area associated with the subject, is specifically configured to:
a selection of a number of the M-1 rows of cell data is received.
Optionally, the system further comprises:
the storage unit is used for storing the selected target data to form an array;
the display unit is used for displaying the array when the selection operation of the subjects in the certificate template is received again;
a third receiving unit for receiving a selection of the array;
and the triggering unit is used for triggering the filling unit to fill the subject filling area in the certificate template with the target data to generate a certificate.
Optionally, the system further comprises:
the judging unit is used for judging whether the memory occupancy rate exceeds a preset threshold value or not;
the loading unit is used for loading the array into the memory when the judging unit determines that the memory occupancy rate does not exceed a preset threshold value;
and the triggering unit is further used for triggering the step of displaying the array when the judging unit determines that the memory occupancy exceeds the preset threshold value and receives the selection operation of the subjects in the certificate template again.
A third aspect of the present application provides a computer device comprising:
a processor, a memory;
the processor, when executing a program stored in the memory, performs a method as set forth in any one of the preceding first aspects.
A fourth aspect of the present application provides a computer storage medium having stored therein instructions that, when executed on a computer, cause the computer to perform the method of any of the preceding first aspects.
A fifth aspect of the present application provides a computer program product, which, when executed on a computer, causes the computer to perform the method of any of the preceding first aspects.
According to the technical scheme, the embodiment of the application has the following advantages:
according to the method and the device, the target area of the EXCEL form is associated with the subject of the certificate template one by one, so that when the certificate template of the enterprise resource planning system is used for generating the certificate, the subject in the certificate template is selected, and the target data in the target area associated with the subject is selected again, so that the subject filling area in the certificate can be quickly filled, the certificate can be efficiently generated, and the requirement that the certificate template can flexibly acquire the cell data from the EXCEL form can be met.
Drawings
FIG. 1 is a flowchart illustrating a credential generation method according to an embodiment of the present application;
FIG. 2 is a flowchart illustrating a credential generation method according to another embodiment of the present application;
FIG. 3 is a schematic structural diagram of an embodiment of a credential generation system of the present application;
FIG. 4 is a schematic structural diagram of another embodiment of the credential generation system of the present application;
fig. 5 is a schematic structural diagram of an embodiment of a credential generation apparatus of the present application.
Detailed Description
The embodiment of the application provides a voucher generation method and a related device, so as to meet the requirement that a voucher template can flexibly acquire cell data from an EXCEL form.
The technical scheme of the application can effectively realize that various preset voucher templates in an Enterprise Resource Planning (ERP) system and an excel (micro office excel) form of a Microsoft company are coordinated to carry out joint cooperation so as to improve the generation efficiency of various vouchers.
Referring to fig. 1, an embodiment of a credential generation method of the present application includes:
101. the EXCEL form is obtained, along with the credential template.
According to the embodiment of the application, an EXCEL table is required to be obtained, and the EXCEL table stores data required by the to-be-generated voucher. The embodiment of the present application further requires obtaining a preset credential template from an Enterprise Resource Planning (ERP) system. The certificate template has a fixed format part, such as the certificate name, subject, etc. of the certificate template, and a part to be supplemented, such as a subject filling area corresponding to the subject in the certificate template, etc. The subject filling area is a place which needs to acquire corresponding data from the EXCEL form for filling. It is understood that different credential templates may have different names and subjects, and that there may be multiple subjects on one credential template, and the specific style of the credential template is not further limited herein.
102. And determining a target area to be associated in the EXCEL table.
And assigning the target area to be associated to the EXCEL table acquired in the step 101 so as to improve the searching efficiency of the subsequent steps. The target area should be: and covering a cell of data required by the certificate to be generated in the EXCEL table.
Specifically, the determination process of the target area may be performed by selecting a number of consecutive rows and/or columns in the EXCEL table; alternatively, a number of rows and/or columns may be selected through a function expression in the EXCEL table, or a target area may be selected in the EXCEL table through other methods, which is not further limited herein.
103. And determining the subject needing to be associated in the certificate template and a subject filling area corresponding to the subject.
And confirming the certificate template acquired in the step 101, and knowing the subject on the certificate template and the subject filling area corresponding to the subject. It can be understood that there are various credential templates preset in an Enterprise Resource Planning (ERP) system, and different credential templates need to be the same for related subjects and subject filling areas corresponding to the subjects.
104. The target area is associated with a subject.
The target area determined in step 102 is associated with the subject determined in step 103. Specifically, the subject here may refer to a subject name on the credential template or a subject filling area corresponding to the subject. The association here may be to set a hyperlink or to set a mapping relationship, etc., and is not limited further here.
In another embodiment, when the target area determined in step 102 is M consecutive rows and N consecutive columns in the EXCEL table, and the first row of the table area composed of the M rows and N consecutive columns is a header row, where M is a positive integer greater than zero and N is a positive integer greater than zero; firstly, carrying out first association on x unit cell data in a title line and corresponding subjects in a certificate template, wherein x is a positive integer which is greater than 0 and less than or equal to M; and then, performing second association on each cell data in the x cell data of the title row and N-1 column cell data corresponding to the lower part of the x cell data of the title row, wherein the N-1 column cell data refers to the N-1 row-column cell data corresponding to the lower part of one cell data of the title row in the target area when the cell data of the title row in the target area is removed from the 1 row of the cell data of the title row. When the target area determined in step 102 is M rows and N columns in succession in the EXCEL table, and the M row and N columns form the M-th row header row of the table area, where M is a positive integer greater than zero, and N is a positive integer greater than zero; firstly, associating x unit form data in the title row with corresponding subjects in the voucher template for the first time, wherein x is a positive integer which is more than 0 and less than or equal to M; and then, performing second association on each cell data in the x cell data of the title row and the N-1 column cell data corresponding to the upper part of the x cell data of the title row, wherein the N-1 column cell data refers to the N-1 row-column cell data corresponding to the upper part of one cell data of the title row in the target area when the cell data of the title row in the target area is removed from the 1 row of the cell data of the title row. Performing the second association between each cell data in the x cell data of the header row and the corresponding N-1 columns of cell data means: and performing second association on each cell data in the x cell data of the title row and the N-1 columns of cell data corresponding to the lower part of the cell data, or performing second association on each cell data in the x cell data of the title row and the N-1 columns of cell data corresponding to the upper part of the cell data.
In another embodiment, when the target area determined in step 102 is M consecutive rows and N consecutive columns in the EXCEL table, and the first column of the table area composed of the M rows and N consecutive columns is a heading column, where M is a positive integer greater than zero and N is a positive integer greater than zero; firstly, carrying out first association on y unit cell data in a title column and corresponding subjects in a certificate template, wherein y is a positive integer which is more than 0 and less than or equal to N; and then, performing second association on each cell data in the y cell data of the title column and M-1 row cell data corresponding to the left side of the y cell data, wherein the M-1 row cell data refers to the M-1 row cell data corresponding to one side of one cell data of the title column in the target area when the cell data of the title column is removed from the 1 column of the cell data. When the target area determined in step 102 is M rows and N columns in succession in the EXCEL table, and the nth column of the table area composed of the M rows and N columns is a header column, where M is a positive integer greater than zero, and N is a positive integer greater than zero; firstly, carrying out first association on y unit cell data in a title column and corresponding subjects in a certificate template, wherein y is a positive integer which is more than 0 and less than or equal to N; and then, performing second association on each cell data in the y cell data of the title column and M-1 row cell data corresponding to the right side of the y cell data, wherein the M-1 row cell data refers to the M-1 row cell data corresponding to one side of one cell data of the title column in the target area when the cell data of the title column is removed from the 1 column of the cell data. Performing second association on each of the y cell data in the title column and the M-1 row cell data corresponding to the cell data refers to: and secondly associating each cell data in the y cell data of the title column with the M-1 row cell data corresponding to the left side of the cell data, or associating each cell data in the y cell data of the title column with the M-1 row cell data corresponding to the right side of the cell data.
105. And receiving a selection operation of the subjects in the certificate template.
After the target area is associated with the subject in step 104, a corresponding required credential template is selected according to the requirement of the credential to be generated, and the subject in the credential template is selected. For example, the selection operation may be: mouse click, program selection, etc., and the details are not limited herein.
106. A selection of target data in a target area associated with a subject is received.
After the department in the credential template is selected in step 105, that is, after the data filling is performed on the department filling area corresponding to the department, the selection of the target data in the target area associated with the department may be selected and received, where the selection may be a function expression, so that the credential template may extract the target data from the EXCEL table according to the function expression; the selection can also be a specific cell position identification of the EXCEL form, so that the voucher template can extract target data from the EXCEL form according to the specific cell position identification; the other may be used in practical applications, and is not limited herein.
107. And filling a subject filling area in the certificate template with the target data to generate the certificate.
Namely, the target data selected from the target area in the EXCEL form in step 106 is filled into the subject filling area in the certificate template, and then the required certificate is generated through the certificate template.
According to the method and the device, the target area of the EXCEL form is associated with the subject of the certificate template one by one, so that when the certificate template of the enterprise resource planning system is used for generating the certificate, the subject in the certificate template is selected, and the target data in the target area associated with the subject is selected again, so that the subject filling area in the certificate can be quickly filled, the certificate can be efficiently generated, and the requirement that the certificate template can flexibly acquire the cell data from the EXCEL form can be met.
After step 105 in the embodiment of fig. 1, and before step 106, the embodiment may further include the following steps: and popping up the target area associated with the subject according to the selection operation.
I.e. to pop up the target area associated with the subject of the credential template in step 104 in response to the selection operation in step 105. Such as selecting a number of consecutive rows and/or columns in the EXCEL table in the pop-up step 104 according to the selection operation; alternatively, a function expression in the EXCEL table is popped up to select a number of rows and/or columns.
In another embodiment, when the target area is M rows and N columns in the EXCEL table, and the M rows and N columns form a first row or an M-th row header row of the table area, the selecting operation needs to be performed multiple times, first, x pieces of cell data in the header row associated with the subject of the pop-up voucher template for the first time are selected according to the first time of the selecting operation, then, a selection of a user for one piece of cell data in the x pieces of cell data is received, where the selection is a second time of the selecting operation, and the second time of selecting the selected cell data may be referred to as target cell data; and then, the second time of selection pops up the N-1 column unit cell data associated with the target unit cell data for the second time.
In another embodiment, when the target area is M rows and N columns that are consecutive in the EXCEL table, and the first column or the nth column of the table area that is composed of the M rows and N columns is a title column, the selection operation needs to be performed multiple times, first y cell data in the title column that is associated with the subject of the pop-up voucher template for the first time is selected according to the first time of the selection operation, then the selection of the user for one cell data in the y cell data is received, where the selection is the second time of the selection operation, and the cell data selected for the second time selection may be referred to as target cell data; and then, the M-1 lines of cell data related to the target cell data for the second time are popped up by the second selection.
Specifically, the step 106 of receiving the selection of the target data in the target area may specifically include:
and receiving the selection of the user on the cell data in the target area popped up in the step, wherein the selected cell data is the target data.
In another embodiment, when the target area is M rows and N columns in the EXCEL table, and the first row or the M-th row of the table area is composed of the M rows and N columns, after the N-1 columns of cell data associated with the target cell data for the second time is popped up by the second selection of the selection operation in the above step, the selection of the user for several columns of cell data in the N-1 columns of cell data is received, and the selected column of cell data is the target data. The user can select one or more column unit cell data according to the actual situation so as to meet the requirement of the voucher to be generated on filling one or more field information under one subject.
In another embodiment, when the target area is M rows and N columns in the EXCEL table, and the first column or the nth column of the table area composed of the M rows and N columns is a header column, after the M-1 rows of cell data associated with the target cell data for the second time is popped up by the second selection of the selection operation in the above step, the selection of the user for a plurality of rows of cell data in the M-1 rows of cell data is received, and the selected row of cell data is the target data. The user can select one or more row unit cell data according to the actual situation so as to meet the requirement of the voucher to be generated on filling one or more field information under one subject.
According to the method and the device, the target area of the EXCEL form is associated with the subject of the certificate template one by one, so that when the certificate template of the enterprise resource planning system is used for generating the certificate, the subject in the certificate template is selected, the associated target area of the EXCEL form is popped up, target data in the target area is selected again, the subject filling area in the certificate can be filled quickly, the certificate is generated efficiently, and the requirement that the certificate template can acquire cell data from the EXCEL form flexibly is met.
Referring to fig. 2, after step 107 according to the above embodiment, another embodiment of the credential generating method of the present application includes:
201. and storing the selected target data to form an array.
The target data selected by the user in step 107 is backed up and saved, and the target data is regarded as a data combination called an array. In another embodiment, several columns of cell data selected from the N-1 columns of cell data by the user in step 107 are backed up and saved, and the several columns of cell data are regarded as a data combination, which is called an array. In another embodiment, the cell data of a plurality of rows selected from the cell data of M-1 rows by the user in step 107 are backed up and saved, and the cell data of a plurality of rows are regarded as a data combination, which is called an array.
For example, by representing an array by using a flexible field (flexfield), the flexible field has an identification ID, and after associating the identification ID of the flexible field with a subject of the credential template, when a selection operation for the subject in the credential template is received again, the array stored in the flexible field can be displayed. Specifically, for example: { "employee": 'Zhang three' and 'Liqu' ] } can be converted into id1 and stored in a database, so that the id1 can be reused when a staff combination of Zhang three and Liqu is also encountered next time, and the id1 is an array. This step may utilize the microservice architecture to provide array storage services.
202. Judging whether the memory occupancy rate exceeds a preset threshold value, if not, executing step 210; if the memory occupancy rate exceeds the preset threshold, step 211 is executed.
It can be understood that the technical solution of the embodiment of the present application is mainly executed in a computer, and when the technical solution of the present application is executed in a computer, it may further be determined whether the memory occupancy rate of the computer exceeds a preset threshold, for example, the preset threshold of the memory occupancy rate is 60%, or 70%, and the like, that is, it is determined whether the memory occupancy rate of the current computer exceeds the preset threshold by 60%, or 70%, and the like; if it is determined that the memory occupancy rate of the current computer does not exceed the preset threshold, the current computer is considered to be in a good running state, and then step 210 is executed; if it is determined that the memory occupancy rate of the current computer exceeds the preset threshold, it can be considered that the current computer operating state is full, then step 211 is executed.
203. And loading the array into the memory.
When it is determined in step 202 that the memory occupancy rate of the current computer does not exceed the preset threshold, the array backed up and saved in step 201 may be loaded into the memory of the computer, so as to respond to the selection operation of the user at any time, thereby improving the efficiency.
204. And when the selection operation of the subjects in the certificate template is received again, displaying the array.
When a user uses the credential template again and performs a selection operation on the subject in the credential template, the array backed up and saved in step 201 is displayed to the user, so that the user can observe the array in the history. In this step, the micro service architecture can be used to provide array display services.
205. A selection of an array, i.e., target data, is received.
Based on the array displayed in step 204, the user can quickly select the stored array based on the historical operation experience, and the tedious operations caused by multiple selections of selection operations are reduced.
206. And filling a subject filling area in the certificate template with the target data to generate the certificate.
That is, the selected array from the arrays in step 205 is filled into the subject filling area in the credential template, and then the required credential is generated through the credential template.
In the embodiment, the selected target data is stored to form the array, so that when the template is used again in the following process, the array stored based on the history can be quickly selected, the array is filled in the voucher template, and the generation of the required voucher is realized. It is understood that, of course, the user may not select the array in step 205, and then jump to step 105 in the embodiment of fig. 1 to select the target data of the target area, so that the implementation is more flexible.
The above describes an embodiment of the credential generating method of the present application, and an embodiment of the credential generating system of the present application is described below with reference to fig. 3, which includes:
an acquiring unit 301, configured to acquire an EXCEL form and a credential template;
a first determining unit 302, configured to determine a target area to be associated in the EXCEL table;
a second determining unit 303, configured to determine a subject to be associated in the credential template and a subject filling area corresponding to the subject;
an associating unit 304, configured to associate the target area with the subject;
a first receiving unit 305, configured to receive a selection operation on the subject in the credential template;
a second receiving unit 306, configured to receive a selection of target data in the target area associated with the subject;
a filling unit 307, configured to fill the subject filling area in the credential template with the target data, so as to generate a credential.
The execution of the credential generating system of this embodiment is similar to the operation executed in fig. 1, and is not described herein again.
According to the method and the device, the target area of the EXCEL form is associated with the subject of the certificate template one by one, so that when the certificate template of the enterprise resource planning system is used for generating the certificate, the subject in the certificate template is selected, and the target data in the target area associated with the subject is selected again, so that the subject filling area in the certificate can be quickly filled, the certificate is efficiently generated, and the requirement that the certificate template can flexibly acquire cell data from the EXCEL form is met.
Another embodiment of the credential generation system of the present application, please refer to fig. 4, which includes:
an obtaining unit 401, configured to obtain an EXCEL form and a credential template;
a first determining unit 402, configured to determine a target area to be associated in the EXCEL table;
a second determining unit 403, configured to determine a subject to be associated in the credential template and a subject filling area corresponding to the subject;
an associating unit 404, configured to associate the target area with the subject;
a first receiving unit 405, configured to receive a selection operation on the subject in the credential template;
a second receiving unit 407, configured to receive a selection of target data in the target area associated with the subject;
a filling unit 408, configured to fill the subject filling area in the credential template with the target data, so as to generate a credential.
Optionally, the system further comprises:
an ejection unit 406, configured to eject the target area associated with the subject according to the selection operation.
Optionally, when determining the target area to be associated in the EXCEL table, the first determining unit 402 is specifically configured to:
determining a plurality of continuous rows and/or columns to be associated in the EXCEL table;
or the like, or, alternatively,
and determining a plurality of rows and/or columns to be associated in the EXCEL table through function expressions.
Optionally, when the target area is a table area with M consecutive rows and N consecutive columns, and a first row of the table area is a header row, where M is a positive integer greater than zero, and N is a positive integer greater than zero;
when associating the target area with the subject, the associating unit 404 is specifically configured to:
associating cell data of x cells in the title row with the subject for the first time, wherein x is a positive integer which is greater than 0 and less than or equal to M;
performing second association on each unit cell data and the corresponding N-1 column unit cell data;
when the pop-up unit 406 pops up the target area associated with the subject according to the selection operation, specifically configured to:
popping up the x cell data according to the first selection operation of the selection operations;
receiving a second selection of a target cell data of the x cell data;
popping up the N-1 column unit cell data associated with the target unit cell data for the second time according to the second selection;
the second receiving unit 407 receiving a selection of target data in the target area associated with the subject comprises:
receiving a selection of a number of the N-1 columns of cell data.
Optionally, when the target area is a table area with M consecutive rows and N consecutive columns, and a first column of the table area is a header column, where M is a positive integer greater than zero, and N is a positive integer greater than zero;
the associating unit 404 is specifically configured to, when the target area is associated with the subject:
associating cell data of y cells in the title column with the subject for the first time, wherein y is a positive integer which is greater than 0 and less than or equal to N;
performing second association on each cell data and the corresponding M-1 rows of cell data;
when the pop-up unit 406 pops up the target area associated with the subject according to the selection operation, specifically configured to:
popping up the y cell data according to the first selection operation of the selection operations;
receiving a second selection of a target cell data of the y cell data;
popping up the M-1 row cell data associated with the target cell data for the second time according to the second selection;
when the second receiving unit 406 receives the selection of the target data in the target area associated with the subject, the second receiving unit is specifically configured to:
a selection of a number of the M-1 rows of cell data is received.
Optionally, the system further comprises:
a storage unit 409, configured to store the selected target data to form an array;
the display unit 410 is used for displaying the array when the selection operation of the subject in the certificate template is received again;
a third receiving unit 411, configured to receive a selection of the array;
a triggering unit 412, configured to trigger the filling unit to fill the subject filling area in the credential template with the target data, so as to generate a credential.
Optionally, the system further comprises:
a determining unit 413, configured to determine whether the memory occupancy rate exceeds a preset threshold;
the loading unit 414 is configured to load the array into the memory when the determining unit determines that the memory occupancy rate does not exceed the preset threshold;
the triggering unit 412 is further configured to trigger the step of displaying the array when the determining unit determines that the memory occupancy exceeds the preset threshold and receives a selection operation on the subject in the credential template again.
The execution of the credential generating system of this embodiment is similar to the operation executed in fig. 2, and is not described herein again.
In the embodiment, the selected target data is stored to form the array, so that when the template is used again in the following process, the array stored based on the history can be quickly selected, the array is filled in the voucher template, and the generation of the required voucher is realized.
One embodiment of a computer device of the present application is described below with reference to fig. 5, which includes:
the computer device 500 may include one or more Central Processing Units (CPUs) 501 and a memory 502, where the memory 502 stores one or more applications or data. Memory 502 may be volatile storage or persistent storage, among others. The program stored in memory 502 may include one or more modules, each of which may include a sequence of instructions operating on a computer device. Still further, the central processor 501 may be arranged in communication with the memory 502 to execute a series of instruction operations in the memory 502 on the computer device 500. The central processing unit 501 may perform the operations in the embodiments shown in fig. 1 or fig. 2, which are not described herein again.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing 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 method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and the like.
Claims (10)
1. A credential generation method, comprising:
acquiring an EXCEL form and a certificate template;
determining a target area to be associated in the EXCEL table;
determining the subjects needing to be associated in the certificate template and subject filling areas corresponding to the subjects;
associating the target area with the subject;
receiving a selection operation of the subject in the credential template;
receiving a selection of target data in the target area associated with the subject;
and filling the subject filling area in the certificate template with the target data to generate a certificate.
2. The credential generation method of claim 1, wherein after receiving the selection operation of the subject in the credential template, prior to receiving the selection of the subject-associated target data in the target area, the method further comprises:
and popping up the target area associated with the subject according to the selection operation.
3. The credential generation method of claim 2, wherein said determining the target area to be associated in the EXCEL form comprises:
determining a plurality of continuous rows and/or columns to be associated in the EXCEL table;
or the like, or, alternatively,
and determining a plurality of rows and/or columns to be associated in the EXCEL table through function expressions.
4. The credential generating method according to claim 3, wherein when the target area is a table area with M consecutive rows and N consecutive columns, and a first row of the table area is a header row, M is a positive integer greater than zero, and N is a positive integer greater than zero;
the associating the target area with the subject comprises:
associating cell data of x cells in the title row with the subject for the first time, wherein x is a positive integer greater than 0 and less than or equal to M;
performing second association on each unit cell data and the corresponding N-1 column unit cell data;
the popping up the target area associated with the subject according to the selection operation comprises:
popping up the x cell data according to the first selection of the selection operation;
receiving a second selection of a target cell data of the x cell data;
popping up the N-1 column unit cell data associated with the target unit cell data for the second time according to the second selection;
the receiving a selection of target data in the target area associated with the subject comprises:
receiving a selection of a number of the N-1 columns of cell data.
5. The credential generating method according to claim 3, wherein when the target area is a table area with M rows and N columns in succession, and a first column of the table area is a header column, M is a positive integer greater than zero, and N is a positive integer greater than zero;
the associating the target area with the subject comprises:
associating cell data of y cells in the title column with the subject for the first time, wherein y is a positive integer which is greater than 0 and less than or equal to N;
performing second association on each cell data and the corresponding M-1 rows of cell data;
the popping up the target area associated with the subject according to the selection operation comprises:
popping up the y cell data according to the first selection of the selection operation;
receiving a second selection of a target cell data of the y cell data;
popping up the M-1 row cell data associated with the target cell data for the second time according to the second selection;
the receiving a selection of target data in the target area associated with the subject comprises:
a selection of a number of the M-1 rows of cell data is received.
6. The credential generation method according to claim 4 or 5, wherein after receiving the selection of the target data in the target area, the method further comprises:
storing the selected target data to form an array;
and when the selection operation of the subjects in the certificate template is received again, displaying the array, receiving the selection of the array, triggering the step of filling the subject filling area in the certificate template with the target data and generating the certificate.
7. The method of claim 6, wherein after forming the array, before receiving again the selection operation for the subject in the credential template, the method further comprises:
judging whether the memory occupancy rate exceeds a preset threshold value or not;
if the memory occupancy rate does not exceed the preset threshold value, loading the array into a memory;
and if the memory occupancy exceeds a preset threshold, triggering a step of displaying the array when the selection operation of the subjects in the certificate template is received again.
8. A credential generation system, comprising:
the acquiring unit is used for acquiring the EXCEL form and the certificate template;
the first determining unit is used for determining a target area to be associated in the EXCEL table;
the second determining unit is used for determining the subjects needing to be associated in the certificate template and the subject filling areas corresponding to the subjects;
the association unit is used for associating the target area with the subject;
a first receiving unit, configured to receive a selection operation on the subject in the credential template;
a second receiving unit, configured to receive a selection of target data associated with the subject in the target area;
and the filling unit is used for filling the subject filling area in the certificate template with the target data to generate a certificate.
9. A computer device, comprising:
a processor, a memory;
the processor, when executing a program stored in the memory, performs the method of any of claims 1 to 7.
10. A computer storage medium having stored therein instructions that, when executed on a computer, cause the computer to perform the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011033332.1A CN112183040B (en) | 2020-09-27 | 2020-09-27 | Voucher generation method and related device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011033332.1A CN112183040B (en) | 2020-09-27 | 2020-09-27 | Voucher generation method and related device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112183040A true CN112183040A (en) | 2021-01-05 |
| CN112183040B CN112183040B (en) | 2024-06-14 |
Family
ID=73944270
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011033332.1A Active CN112183040B (en) | 2020-09-27 | 2020-09-27 | Voucher generation method and related device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112183040B (en) |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040117205A1 (en) * | 2002-12-17 | 2004-06-17 | Reardan Dayton T. | Sensitive drug distribution system and method |
| KR20100027707A (en) * | 2008-09-03 | 2010-03-11 | 김선규 | Pasting inputable accounting processing system and the method |
| CN101706903A (en) * | 2009-12-15 | 2010-05-12 | 邓锦威 | Method for quickly generating tax account voucher |
| KR20110051463A (en) * | 2009-11-10 | 2011-05-18 | 윤상봉 | Automatic entry generation appartus and method thereof |
| CN103699387A (en) * | 2013-12-27 | 2014-04-02 | 金蝶软件（中国）有限公司 | Table processing method and system |
| CN107437219A (en) * | 2017-08-28 | 2017-12-05 | 山东浪潮通软信息科技有限公司 | The voucher generation method and device of a kind of business paper |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
| CN110119977A (en) * | 2019-05-10 | 2019-08-13 | 极智(上海)企业管理咨询有限公司 | Financial accounting voucher automatic generation method, system, medium and electronic equipment |
| CN110276682A (en) * | 2019-06-24 | 2019-09-24 | 深圳乐信软件技术有限公司 | A kind of information calculates processing method and system |
| CN110458674A (en) * | 2018-05-07 | 2019-11-15 | 北京中海汇银财税服务有限公司 | A kind of method and system generating bookkeeping voucher |
| CN110516220A (en) * | 2019-08-28 | 2019-11-29 | 金蝶软件（中国）有限公司 | A kind of report data input method, system and relevant device |
| CN110930236A (en) * | 2019-12-06 | 2020-03-27 | 北京中电普华信息技术有限公司 | Voucher-based payment order generation method and device |
| CN110941750A (en) * | 2019-11-28 | 2020-03-31 | 金蝶软件（中国）有限公司 | Data linkage method and related device |
| CN111445319A (en) * | 2020-02-17 | 2020-07-24 | 深圳壹账通智能科技有限公司 | Voucher generation method and device, computer equipment and storage medium |
| WO2020186783A1 (en) * | 2019-03-21 | 2020-09-24 | 平安国际智慧城市科技股份有限公司 | Data importing method and apparatus, and computer device and storage medium |
-
2020
- 2020-09-27 CN CN202011033332.1A patent/CN112183040B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040117205A1 (en) * | 2002-12-17 | 2004-06-17 | Reardan Dayton T. | Sensitive drug distribution system and method |
| KR20100027707A (en) * | 2008-09-03 | 2010-03-11 | 김선규 | Pasting inputable accounting processing system and the method |
| KR20110051463A (en) * | 2009-11-10 | 2011-05-18 | 윤상봉 | Automatic entry generation appartus and method thereof |
| CN101706903A (en) * | 2009-12-15 | 2010-05-12 | 邓锦威 | Method for quickly generating tax account voucher |
| CN103699387A (en) * | 2013-12-27 | 2014-04-02 | 金蝶软件（中国）有限公司 | Table processing method and system |
| CN107437219A (en) * | 2017-08-28 | 2017-12-05 | 山东浪潮通软信息科技有限公司 | The voucher generation method and device of a kind of business paper |
| CN110458674A (en) * | 2018-05-07 | 2019-11-15 | 北京中海汇银财税服务有限公司 | A kind of method and system generating bookkeeping voucher |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
| WO2020186783A1 (en) * | 2019-03-21 | 2020-09-24 | 平安国际智慧城市科技股份有限公司 | Data importing method and apparatus, and computer device and storage medium |
| CN110119977A (en) * | 2019-05-10 | 2019-08-13 | 极智(上海)企业管理咨询有限公司 | Financial accounting voucher automatic generation method, system, medium and electronic equipment |
| CN110276682A (en) * | 2019-06-24 | 2019-09-24 | 深圳乐信软件技术有限公司 | A kind of information calculates processing method and system |
| CN110516220A (en) * | 2019-08-28 | 2019-11-29 | 金蝶软件（中国）有限公司 | A kind of report data input method, system and relevant device |
| CN110941750A (en) * | 2019-11-28 | 2020-03-31 | 金蝶软件（中国）有限公司 | Data linkage method and related device |
| CN110930236A (en) * | 2019-12-06 | 2020-03-27 | 北京中电普华信息技术有限公司 | Voucher-based payment order generation method and device |
| CN111445319A (en) * | 2020-02-17 | 2020-07-24 | 深圳壹账通智能科技有限公司 | Voucher generation method and device, computer equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 刘宇琛等: "基于excel的账务处理流程实现", 《企业科技与发展》, no. 8, pages 95 - 99 * |
| 李宏: "基于ERP的应付业务自动核算的实现", 《信息与电脑》, pages 25 - 37 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112183040B (en) | 2024-06-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TW201232294A (en) | Formatting data by example | |
| US8521579B2 (en) | Predicting marketing campaigns having more than one step | |
| WO2004090766A2 (en) | Predicting marketing campaigns having more than one step | |
| CN112068936A (en) | Workflow management platform and workflow management system | |
| EP3462386A2 (en) | Learning data selection program, learning data selection method, and learning data selection device | |
| EP3885915A1 (en) | Failure cause identifying program, failure cause identifying apparatus, and failure cause identifying method | |
| CN107688488A (en) | A kind of optimization method and device of the task scheduling based on metadata | |
| CN108875853A (en) | The processing method and processing device of data label printing | |
| CN111461776A (en) | Resource distribution method, device, equipment and storage medium | |
| CN112258213A (en) | Method, device, equipment and storage medium for determining advertisement putting position | |
| JP6773972B2 (en) | Data conversion program, data conversion method, and data conversion device | |
| CN101446906A (en) | Dispatching method for multi-batch processing tasks and system thereof | |
| CN106293922A (en) | Asynchronous task processing method and system | |
| CN112183040A (en) | Voucher generation method and related device | |
| CN108920278B (en) | Resource allocation method and device | |
| CN111105194A (en) | Commodity distribution method, intelligent device and computer readable storage medium | |
| JP5515117B2 (en) | Data processing device | |
| US20110185167A1 (en) | Change impact research support device and change impact research support method | |
| CN114266233A (en) | Form generation method, device, equipment and medium | |
| CN114168624A (en) | Data analysis method, computing device and storage medium | |
| CN110188069A (en) | A kind of csv file storage method, device and computer equipment | |
| CN111553749A (en) | Activity push strategy configuration method and device | |
| CN112288206A (en) | Resource allocation method and device, computer storage medium and electronic equipment | |
| CN111538716B (en) | Method and related device for maintaining database across systems | |
| CN111581093B (en) | Method, device, equipment and medium for generating test record list |
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 |