CN111090978B - Document processing method and device and storage medium - Google Patents
Document processing method and device and storage medium Download PDFInfo
- Publication number
- CN111090978B CN111090978B CN201911357389.4A CN201911357389A CN111090978B CN 111090978 B CN111090978 B CN 111090978B CN 201911357389 A CN201911357389 A CN 201911357389A CN 111090978 B CN111090978 B CN 111090978B
- Authority
- CN
- China
- Prior art keywords
- bill
- tab
- template
- document
- fields
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Abstract
The application discloses a bill processing method, which comprises the following steps: and filling the display field included in the first bill into a first tab of the first Excel file according to the position of the display field on the first bill interface, wherein the first tab is used for generating a bill template. Filling all fields contained in the first receipt and preset system parameter fields into a second tab of the first Excel file, wherein the content of the second tab is used for editing the first tab. By the technical scheme provided by the application, the problem that a great deal of time and a great deal of manpower are required to design the cover printing template or the bill report is solved, so that the cost required by printing the bill content by an enterprise is reduced.
Description
Technical Field
The application relates to the technical field of computers, in particular to a bill processing method.
Background
Currently, when the existing content on the bill in the enterprise resource planning (enterprise resource planning, ERP) system needs to be formatted and printed, the existing content on the bill is generally printed through a printing tool provided by the ERP system, and a business person is required to design a printing template or report format suitable for the bill, so that the existing content on the bill is printed according to a certain format.
However, the existing ERP printing tool has complex functions and high difficulty in the hand, and enterprises can design templates or reports capable of meeting the demands of the enterprises after certain training of related personnel by a certain cost is needed. The printing template or the bill report format is complicated to set, cannot be processed in batch, only the simple printing template or the bill report is designed, so that a lot of time is required to be consumed, if the printing requirement of an enterprise is complex, the requirement of the enterprise on rapid change cannot be met, and meanwhile, higher maintenance cost is also brought. In addition, the current printing format or display effect is single, and only the existing contents on the printing template or the bill report can be printed, so that different effects can not be displayed according to different contents of the bill.
Disclosure of Invention
The embodiment of the application provides a receipt processing method, which solves the problem that a great deal of time and a great deal of manpower are required to be consumed for printing receipt contents to design a cover printing template or a receipt report, thereby reducing the cost required by printing the receipt contents for enterprises. The method for printing the bill content solves the problems of inflexibility and high later maintenance cost of the bill content printing method, thereby meeting the requirement of quick change of enterprises and reducing the maintenance cost. The method solves the problem of single printing format or display effect, provides a way for further processing the contents of the printed documents for enterprises, and has richer display effect.
In order to achieve the above purpose, the embodiment of the present application provides the following technical solutions:
the first aspect of the present application provides a document processing method, including: and filling the display field included in the first bill into a first tab of the first Excel file according to the position of the display field on the first bill interface, wherein the first tab is used for generating a bill template. Filling all fields contained in the first receipt and preset system parameter fields into a second tab of the first Excel file, wherein the content of the second tab is used for editing the first tab.
Optionally, with reference to the first aspect, in a first possible implementation manner, the method further includes: traversing the bill, determining N Excel files according to the type of the bill, wherein the bill comprises a first bill, and the N Excel files comprise the first Excel file.
Optionally, with reference to the first aspect or the first possible implementation manner of the first aspect, in a second possible implementation manner, the method may further include: and filling preset related description in a third tab of the first Excel file, wherein the related description is used for prompting a user how to edit the first tab to generate a document template.
Optionally, with reference to the first aspect or the second possible implementation manner of the first aspect, in a third possible implementation manner, the method may further include: and loading the bill to be printed and the bill template, wherein the type of the bill to be printed is the same as that of the first bill. And filling the document to be printed into the document template to generate complete document printing content.
Optionally, with reference to the third possible implementation manner of the first aspect, in a fourth possible implementation manner, the method further includes: and analyzing the bill template and determining the format of each field in the bill template. And processing the data of the document to be printed according to the format of each field. Filling the document to be printed content into a document template to generate complete document printing content, comprising: and replacing the bill data into the bill template in a corresponding format to generate complete bill printing content.
Optionally, with reference to the first aspect or the first possible implementation manner of the first aspect, in a fifth possible implementation manner, the first document interface corresponds to a first coordinate system, and the filling the display field included in the first document into the first tab of the first Excel file according to the position of the display field on the first document interface includes: the coordinates of the display field in a first coordinate system including an X-axis and a Y-axis are confirmed. The X axis is converted into rows of the first tabs and the Y axis is converted into columns of the first tabs according to a preset rule. The location of the display field in the first tab is determined based on the relationship between the X-axis and the row of the first tab and the relationship between the Y-axis and the column in the first tab.
Optionally, with reference to the first aspect or the first possible implementation manner of the first aspect, in a sixth possible implementation manner, the method further includes: it is determined whether all of the fields included in the first document are display fields. And determining the position of a display field in the first bill.
The second aspect of the present application provides a document processing apparatus, including a first filling unit, configured to fill a display field included in a first document into a first tab of a first Excel file according to a position of the display field on a first document interface, where the first tab is used to generate a document template. The second filling unit is used for filling all the fields contained in the first bill and preset system parameter fields into a second tab of the first Excel file, and the content of the second tab is used for editing the first tab.
Optionally, with reference to the second aspect, in a first possible implementation manner, the method further includes: the traversal determining unit is used for traversing the bill, determining N Excel files according to the type of the bill, wherein the bill comprises a first bill, and the N Excel files comprise the first Excel file.
Optionally, with reference to the second aspect or the first possible implementation manner of the second aspect, in a second possible implementation manner, the method further includes: and the third filling unit is used for filling preset related description in a third tab of the first Excel file, and the related description is used for prompting a user how to edit the first tab to generate a document template.
Optionally, with reference to the second aspect or the first or second possible implementation manner of the second aspect, in a third possible implementation manner, the method further includes: the loading unit is used for loading the bill to be printed and the bill template, and the type of the bill to be printed is the same as that of the first bill. And the fourth filling unit is used for filling the document to be printed into the document template to generate complete document printing content.
A third aspect of the present application provides a nesting inspection apparatus, which may include: a memory for storing computer readable instructions. Also included is a processor coupled with the memory for executing computer readable instructions in the memory to perform operations comprising: and filling the display field included in the first bill into a first tab of the first Excel file according to the position of the display field on the first bill interface, wherein the first tab is used for generating a bill template. Filling all fields contained in the first receipt and preset system parameter fields into a second tab of the first Excel file, wherein the content of the second tab is used for editing the first tab.
Optionally, with reference to the third aspect, in a first possible implementation manner, the processor is further configured to traverse a document, determine N Excel files according to a type of the document, where the document includes a first document, and the N Excel files include the first Excel file.
Optionally, with reference to the third aspect or the first possible implementation manner of the third aspect, in a second possible implementation manner, the processor is further configured to populate a third tab of the first Excel file with a preset related description, where the related description is used to prompt a user how to edit the first tab to generate the document template.
Optionally, with reference to the third aspect or the first or the second possible implementation manner of the third aspect, in a third possible implementation manner, the processor is further configured to load a document to be printed and a document template, where a type of the document to be printed is the same as a type of the first document. And filling the document to be printed into the document template to generate complete document printing content.
A fourth aspect of the application provides a computer readable storage medium having instructions stored therein which, when run on a computer, cause the computer to perform the document processing method of the first aspect or any one of the possible implementations of the first aspect.
A fifth aspect of the application provides a computer program product comprising instructions which, when run on a computer, cause the computer to perform the document processing method of the first aspect or any one of the possible implementations of the first aspect.
The document processing method provided by the embodiment of the application has the advantages that a user does not need to manufacture a template from scratch, the ERP system can automatically generate a document template similar to a document interface, and a great deal of time and a great deal of manpower are not required to be consumed to relate to a cover printing template or a document report, so that the cost required by printing document contents by enterprises is reduced. Meanwhile, the problems of inflexible bill content printing method and high later maintenance cost are solved, so that the requirement of enterprises on rapid change is met, and the maintenance cost is reduced. In addition, the problem of single printing format or display effect is solved, a way for further processing the printed bill content is provided for enterprises, and the display effect is richer.
Drawings
FIG. 1 is a schematic diagram of an embodiment of a document processing method according to an embodiment of the present application;
FIG. 2 is a schematic diagram of another embodiment of a document processing method according to an embodiment of the present application;
FIG. 3 is a schematic diagram of another embodiment of a document processing method according to an embodiment of the present application;
FIG. 4 is a schematic diagram of another embodiment of a document processing method according to an embodiment of the present application
FIG. 5 is a schematic diagram of a document processing apparatus according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of a document processing device according to an embodiment of the present application.
Detailed Description
Embodiments of the present application will now be described with reference to the accompanying drawings, in which it is evident that the embodiments described are only some, but not all embodiments of the present application. As one of ordinary skill in the art can know, with the development of technology and the appearance of new scenes, the technical scheme provided by the embodiment of the application is also applicable to similar technical problems.
The embodiment of the application provides a bill processing method, a bill processing device and a storage medium, wherein display fields included in a first bill are filled into a first tab of a first Excel file according to the positions of the display fields on a first bill interface, and the first tab is used for generating a bill template. All fields contained in the first bill and preset system parameter fields are filled into a second tab of the first Excel file, the content of the second tab is used for editing the first tab, a user does not need to manufacture a template from scratch, and the ERP system can automatically generate a bill template similar to a bill interface without consuming a great deal of time and manpower for designing.
And the template or the bill report is printed, so that the cost required by printing bill contents of enterprises is reduced. Meanwhile, the problems of inflexible bill content printing method and high later maintenance cost are solved, so that the requirement of enterprises on rapid change is met, and the maintenance cost is reduced. In addition, the problem of single printing format or display effect is solved, a way for further processing the printed bill content is provided for enterprises, and the display effect is richer. The following will describe in detail.
The terms first, second and the like in the description and in the claims and in the above-described figures, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments described herein may be implemented in other sequences than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or modules is not necessarily limited to those steps or modules that are expressly listed or inherent to such process, method, article, or apparatus. The naming or numbering of the steps in the present application does not mean that the steps in the method flow must be executed according to the time/logic sequence indicated by the naming or numbering, and the execution sequence of the steps in the flow that are named or numbered may be changed according to the technical purpose to be achieved, so long as the same or similar technical effects can be achieved. The division of the modules in the present application is a logical division, and may be implemented in another manner in practical applications, for example, a plurality of modules may be combined or integrated in another system, or some features may be omitted or not implemented, and further, coupling or direct coupling or communication connection between the modules shown or discussed may be through some ports, and indirect coupling or communication connection between the modules may be electrical or other similar manners, which are not limited in the present application. The modules or sub-modules described as separate components may be physically separated or not, or may be distributed in a plurality of circuit modules, and some or all of the modules may be selected according to actual needs to achieve the purpose of the present application.
Currently, when the existing content on the bill in the enterprise resource planning (enterprise resource planning, ERP) system needs to be formatted and printed, the existing content on the bill is generally printed through a printing tool provided by the ERP system, and a business person is required to design a printing template or report format suitable for the bill, so that the existing content on the bill is printed according to a certain format.
However, the existing ERP printing tool has complex functions and high difficulty in the hand, and enterprises can design templates or reports capable of meeting the demands of the enterprises after certain training of related personnel by a certain cost is needed. The printing template or the bill report format is complicated to set, cannot be processed in batch, only the simple printing template or the bill report is designed, so that a lot of time is required to be consumed, if the printing requirement of an enterprise is complex, the requirement of the enterprise on rapid change cannot be met, and meanwhile, higher maintenance cost is also brought. In addition, the current printing format or display effect is single, and only the existing contents on the printing template or the bill report can be printed, so that different effects can not be displayed according to different contents of the bill.
In order to solve the problems, the application provides a bill processing method which solves the problem that a great deal of time and a great deal of manpower are required to print bill contents to design a cover printing template or a bill report, thereby reducing the cost required by printing the bill contents for enterprises. The method for printing the bill content solves the problems of inflexibility and high later maintenance cost of the bill content printing method, thereby meeting the requirement of quick change of enterprises and reducing the maintenance cost. The problem of single printing format or display effect is solved, a way for further processing the printed bill content is provided for enterprises, and the display effect is richer, and the method is described in detail below.
Fig. 1 is a schematic flow chart of a document processing method according to an embodiment of the present application.
As shown in fig. 1, a document processing method may include the following steps:
101. traversing the bill, and determining N Excel files according to the type of the bill.
The ERP system traverses the bill, wherein the bill refers to a written proof which is acquired or filled when the economic service occurs and is used for specifying the actual conditions of the transaction and the item. The documents may include a variety of types, such as documents for purchase, shipping documents, employee debiting documents, and the like. After traversing the documents, the ERP system determines that N types of documents exist, and then derives N Excel files, wherein each type of document corresponds to one Excel file. It should be noted that, after all documents are traversed, the ERP may uniformly export N Excel files, or export Excel files while traversing the documents.
102. And filling the display field included in a first type bill (hereinafter referred to as a first bill) in the N types of bills into a first tab of the first Excel file according to the position of the display field in the first bill interface.
The display field refers to a field presented on the document interface. The ERP system converts the position of the displayed field on the bill interface into a cell position, and fills the displayed field into a first tab of the Excel file, namely, automatically converts the field displayed on the bill into the cell position according to the position of the bill interface and fills the cell position into the first tab of the Excel file. How to convert the fields on the bill into Excel, in one embodiment of the application, each field in the bill has a displayed coordinate, and the X-axis of the coordinate is converted into the row of Excel and the Y-axis of the coordinate is converted into the column of Excel according to a certain rule, so that the fields can be converted according to the displayed position on the bill and then filled into the cells of Excel. The application point of the embodiment of the application is not how to convert the fields in the bill into Excel, but that after converting the fields in the bill into Excel file, the subsequent operation can be performed to achieve the purpose of the embodiment of the application. The user can edit and modify the first tab after filling the display field to obtain a custom document template.
103. And filling all fields contained in the bill into a second tab of the Excel file by using preset system parameter fields.
All fields included in the document may be the same as or more than the display fields included in the document. Besides all the fields included in the bill, a preset system parameter field can be added according to actual requirements, the actual bill interface does not include the preset system parameter field, and the preset system parameter field is customized by a user according to the actual requirements. The following exemplifies all fields in the document and preset system parameters: for example, all fields included in the document are added to the second tab of the Excel file, and in addition, fields not included in the document may be included, for example, name fields of the company may be added according to the requirement. The content of the second tab can be selected by the user, and the user can copy the content of the second tab into the first tab for use.
It should be noted that, in a specific embodiment, step 1 may not be performed. For example, in an actual application scenario, only a template of a certain type of document is needed, the document may not be traversed, and only steps 102 and 03 are needed to be executed, that is, only one Excel file is needed to be derived, the display field of the document of the certain type is filled into a first tab of the Excel file, and all fields of the document and preset system parameter fields are filled into a second tab of the Excel file.
It should be noted that, in a specific embodiment, steps 101 to 103 are a loop execution process, that is, the ERP system exports the Excel file, fills the content of the document into the Excel file, and when the export of the N Excel files is completed, the filling of the N Excel files is completed.
In a specific embodiment, a third tab can be added to the Excel file, and the third tab can be used for recording related descriptions, namely recording how to make a template, for example, prompting a user to copy the content of the second tab in the Excel file into the first tab, or the user can edit the content in the first tab in a self-defined manner, and the like, so that the user can make a bill template faster through the scheme provided by the application.
As can be seen from the corresponding embodiment of fig. 1, the user does not need to make a template from scratch, and the ERP system can automatically generate an Excel template similar to the document interface, that is, the first tab of the above-mentioned Excel file, and the user can perform custom editing on the first tab, for example, fields can be added or deleted, or the format of the fields can be modified, where the format can refer to changing the size of the font, the picture format, the text format, and so on. Of course, the user may not make any modification, and the first tab, i.e., the document template, is generated from the document interface, so that the user may use the document without modification. By the scheme provided by the corresponding embodiment of fig. 1, a great deal of time and a great deal of manpower are not required to design the cover printing template or the bill report, so that the cost required by printing the bill content of an enterprise is reduced. Meanwhile, the problems of inflexible bill content printing method and high later maintenance cost are solved, so that the requirement of enterprises on rapid change is met, and the maintenance cost is reduced. In addition, the problem of single printing format or display effect is solved, a way for further processing the printed bill content is provided for enterprises, and the display effect is richer.
The corresponding embodiment of fig. 1 illustrates how a document template is made, and how document content is printed using the document template is described below.
Fig. 2 is a schematic flow chart of a document processing method according to an embodiment of the present application.
As shown in fig. 2, a document processing method may include the following steps:
201. and loading the document to be printed and the Excel template.
The user introduces the designed Excel template into the ERP system, namely the first tab of the Excel file is introduced into the ERP system, namely the Excel template is registered in the ERP system, and only the template registered in the ERP system can be used. When the bill content is printed, the ERP system loads the data of the bill printed by the user and loads the Excel template selected by the user.
202. And filling the bill data into the Excel template to generate complete bill printing content.
And finally, printing or previewing is started according to the operation selected by the user, or an Excel file generated by the receipt content is stored in a position appointed by the user, so that the user can carry out secondary processing on the receipt printing content.
It should be noted that, in a specific embodiment, the user may need to print a plurality of documents, and the ERP system may circularly replace the data of the plurality of documents into the Excel template.
In a specific embodiment, step 203 may be further included before step 202, traversing all fields in the Excel template, parsing, and processing the data of the document according to the parsed rule.
In the foregoing embodiment corresponding to fig. 1, it is mentioned that, when a user makes a document template, the format of a field may be modified, so different fields may have different formats, so after loading the document data and the document template, the ERP system traverses all the fields in the Excel template, parses, determines the format of each field, processes the corresponding document data according to the format required by each field, and after completing the traversing of all the fields and the processing of the document data, circularly replaces the document data in the Excel template in the corresponding format, thereby generating the complete document print content.
Advantageous effects of the implementation corresponding to fig. 2 will be understood with reference to the effect corresponding to fig. 1, and the detailed description will not be repeated here.
Fig. 3 is a schematic flow chart of a document processing method according to an embodiment of the present application. After the ERP acquires the document field, judging whether the field is visible in the document interface, if so, calculating the cell position of the field, filling the field into an Excel file, and after all the fields are processed, generating an Excel template similar to the document interface.
Fig. 4 is a schematic flow chart of a document processing method according to an embodiment of the present application. After loading bill data and Excel templates selected by users, the ERP system traverses bill fields in the templates, analyzes the fields according to rules, processes the bill data according to the rules if special rules exist, such as different format requirements of the bill fields in the templates, fills the processed bill data into the Excel templates in batches according to a specified format after all the fields are analyzed, and finally starts printing or previewing according to operations selected by the users, or only generates Excel files for the users to store to the specified positions of the users so as to carry out secondary processing on the bill printing content.
FIG. 5 is a schematic structural diagram of a document processing apparatus according to an embodiment of the present application, where the document processing apparatus may include:
and a first filling unit 501, configured to fill a display field included in a first document into a first tab of a first Excel file according to a position of the display field on the first document interface, where the first tab is used to generate a document template.
And a second filling unit 502, configured to fill all fields and preset system parameter fields included in the first document into a second tab of the first Excel file, where the content of the second tab is used to edit the first tab.
In a specific embodiment, the method further includes a traversal determining unit 503, configured to populate all fields and preset system parameter fields included in the first document into a second tab of the first Excel file, where the content of the second tab is used to edit the first tab.
In a specific embodiment, the method further includes a third filling unit 504, configured to fill a preset related description in a third tab of the first Excel file, where the related description is used to prompt a user how to edit the first tab to generate the document template.
In a specific embodiment, the system further includes a loading unit 505, configured to load a document to be printed and the document template, where the type of the document to be printed is the same as the type of the first document;
and a fourth filling unit 506, configured to fill the document to be printed into the document template to generate complete document printing content.
Fig. 6 is a schematic diagram of a hardware structure of a nesting checking apparatus according to an embodiment of the present application, where the nesting checking apparatus includes at least one processor 601, a communication line 607, a memory 603, and at least one communication interface 604.
The processor 601 may be a general purpose central processing unit (central processing unit, CPU), microprocessor, application-specific integrated circuit (server IC), or one or more integrated circuits for controlling the execution of programs in accordance with aspects of the present application.
Communication line 607 may include a path to communicate information between the above components.
The communication interface 604 uses any transceiver-like device for communicating with other devices or communication networks, such as ethernet, radio access network (radio access network, RAN), wireless local area network (wireless local area networks, WLAN), etc.
The memory 603 may be a read-only memory (ROM) or other type of static storage device that may store static information and instructions, a random access memory (random access memory, RAM) or other type of dynamic storage device that may store information and instructions, and the memory may be stand-alone and coupled to the processor via a communication line 607. The memory may also be integrated with the processor.
The memory 603 is used for storing computer-executable instructions for executing the present application, and is controlled by the processor 601 for execution. The processor 601 is configured to execute computer-executable instructions stored in the memory 603, thereby implementing the document processing method provided in the above embodiment of the present application.
Alternatively, the computer-executable instructions in the embodiments of the present application may be referred to as application program codes, which are not particularly limited in the embodiments of the present application.
In a specific implementation, as an embodiment, the communication device may include a plurality of processors, such as processor 601 and processor 602 in fig. 6. Each of these processors may be a single-core (single-CPU) processor or may be a multi-core (multi-CPU) processor. A processor herein may refer to one or more devices, circuits, and/or processing cores for processing data (e.g., computer program instructions).
In a specific implementation, as an embodiment, the communication device may further include an output device 605 and an input device 606. The output device 605 communicates with the processor 601 and may display information in a variety of ways. The input device 606 is in communication with the processor 601 and may receive user input in a variety of ways. For example, the input device 606 may be a mouse, a touch screen device, a sensing device, or the like.
The communication device may be a general purpose device or a special purpose device. In a specific implementation, the communication device may be a desktop, laptop, web server, palmtop (personal digital assistant, PDA), mobile handset, tablet, wireless terminal device, embedded device, or a device having a similar structure as in fig. 6. The embodiments of the present application are not limited to the type of communication device.
In the above embodiments, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product.
The computer program product includes one or more computer instructions. When loaded and executed on a computer, produces a flow or function in accordance with embodiments of the present application, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by a wired (e.g., coaxial cable, fiber optic, digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer readable storage medium may be any available medium that can be stored by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., solid State Disk (SSD)), etc.
Those of ordinary skill in the art will appreciate that all or part of the steps in the various methods of the above embodiments may be implemented by a program to instruct related hardware, the program may be stored in a computer readable storage medium, and the storage medium may include: ROM, RAM, magnetic or optical disks, etc.
The document processing method, the document processing device and the storage medium provided by the embodiments of the present application are described in detail, and specific examples are applied to illustrate the principles and the embodiments of the present application, and the description of the above embodiments is only used to help understand the method and the core idea of the present application; meanwhile, as those skilled in the art will have variations in the specific embodiments and application scope in accordance with the ideas of the present application, the present description should not be construed as limiting the present application in view of the above.
Claims (5)
1. A document processing method, comprising:
filling display fields included in a first bill into a first tab of a first Excel file according to the positions of the display fields on the first bill interface, wherein the first tab is used for generating a bill template;
filling all fields contained in the first bill and preset system parameter fields into a second tab of the first Excel file, wherein the content of the second tab is used for editing the fields in the first tab, and the preset system parameter fields are customized by a user according to actual requirements;
loading a bill to be printed and the bill template, wherein the type of the bill to be printed is the same as that of the first bill; filling the content of the receipt to be printed into the receipt template to generate complete receipt printing content;
the method further comprises the steps of: after loading the bill data and the bill template, traversing all fields in the bill template, analyzing all fields, determining the format of each field, processing the bill data to be printed according to the format of each field, and processing the bill data to be printed according to the preset rule if the bill field of the bill template has the preset rule;
the filling the document to be printed into the document template to generate complete document printing content comprises the following steps: replacing the bill data into the bill template in a corresponding format to generate complete bill printing content;
the first bill interface corresponds to a first coordinate system, and the filling the display field included in the first bill into the first tab of the first Excel file according to the position of the display field on the first bill interface includes: confirming coordinates of the display field in the first coordinate system, wherein the first coordinate system comprises an X axis and a Y axis; converting the X axis into the row of the first tab according to a preset rule, and converting the Y axis into the column of the first tab; determining the position of the display field in the first tab according to the relation between the X axis and the row of the first tab and the relation between the Y axis and the column in the first tab;
the method further comprises the steps of: determining whether all fields included in the first document are display fields; and determining the position of a display field in the first bill.
2. The document processing method according to claim 1, further comprising:
traversing the bill, and determining N Excel files according to the type of the bill, wherein the bill comprises the first bill, and the N Excel files comprise the first Excel file.
3. A document processing method according to claim 1 or 2, further comprising:
and filling a preset related description in a third tab of the first Excel file, wherein the related description is used for prompting a user how to edit the first tab to generate the document template.
4. A document processing apparatus, comprising:
the first filling unit is used for filling display fields included in a first bill into a first tab of a first Excel file according to the positions of the display fields on the first bill interface, and the first tab is used for generating a bill template;
the second filling unit is used for filling all fields contained in the first bill and preset system parameter fields into a second tab of the first Excel file, wherein the content of the second tab is used for editing the fields in the first tab, and the preset system parameter fields are customized by a user according to actual requirements;
the apparatus further comprises: loading a bill to be printed and the bill template, wherein the type of the bill to be printed is the same as that of the first bill; filling the content of the receipt to be printed into the receipt template to generate complete receipt printing content;
the apparatus further comprises: after loading the bill data and the bill template, traversing all fields in the bill template, analyzing all fields, determining the format of each field, processing the bill data to be printed according to the format of each field, and processing the bill data to be printed according to the preset rule if the bill field of the bill template has the preset rule;
the filling the document to be printed into the document template to generate complete document printing content comprises the following steps: replacing the bill data into the bill template in a corresponding format to generate complete bill printing content;
the first bill interface corresponds to a first coordinate system, and the first filling unit is specifically configured to confirm coordinates of the display field in the first coordinate system, where the first coordinate system includes an X axis and a Y axis; converting the X axis into the row of the first tab according to a preset rule, and converting the Y axis into the column of the first tab; determining the position of the display field in the first tab according to the relation between the X axis and the row of the first tab and the relation between the Y axis and the column in the first tab;
the apparatus further comprises: determining whether all fields included in the first document are display fields; and determining the position of a display field in the first bill.
5. A computer readable storage medium, characterized in that instructions, when run on a computer device, cause the computer device to perform the method of any of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911357389.4A CN111090978B (en) | 2019-12-25 | 2019-12-25 | Document processing method and device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911357389.4A CN111090978B (en) | 2019-12-25 | 2019-12-25 | Document processing method and device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111090978A CN111090978A (en) | 2020-05-01 |
| CN111090978B true CN111090978B (en) | 2023-09-19 |
Family
ID=70397230
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911357389.4A Active CN111090978B (en) | 2019-12-25 | 2019-12-25 | Document processing method and device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111090978B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112464625B (en) * | 2020-11-30 | 2024-03-29 | 金蝶云科技有限公司 | Document generation method, device, computer equipment and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101364293A (en) * | 2008-09-24 | 2009-02-11 | 金蝶软件（中国）有限公司 | Method for implementing service data interchange in ERP system, device and system |
| US7499871B1 (en) * | 2002-05-20 | 2009-03-03 | Honda Motor Co., Ltd. | System and method for procurement of products |
| CN101388087A (en) * | 2008-10-23 | 2009-03-18 | 金蝶软件（中国）有限公司 | Method and apparatus for generating service document voucher |
| CN101504640A (en) * | 2009-03-23 | 2009-08-12 | 金蝶软件（中国）有限公司 | Data sheet editing method and apparatus |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN104503955A (en) * | 2014-12-03 | 2015-04-08 | 中建材国际贸易有限公司 | Method for generating personalized excel form |
| CN108509400A (en) * | 2018-02-07 | 2018-09-07 | 平安普惠企业管理有限公司 | Document template generation method, device, computer equipment and storage medium |
| CN109918416A (en) * | 2019-02-28 | 2019-06-21 | 生活空间(沈阳)数据技术服务有限公司 | A kind of method, device and equipment of document entry |
| CN110221790A (en) * | 2019-05-28 | 2019-09-10 | 迈克医疗电子有限公司 | Universal printing method and device, analysis instrument and storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7546522B2 (en) * | 2004-12-20 | 2009-06-09 | Microsoft Corporation | Method, system, and computer-readable medium for applying a global formatting scheme to a chart in an electronic document |
| CN104182427A (en) * | 2013-05-28 | 2014-12-03 | 纬创资通股份有限公司 | Electronic document production system and electronic document production method thereof |
-
2019
- 2019-12-25 CN CN201911357389.4A patent/CN111090978B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7499871B1 (en) * | 2002-05-20 | 2009-03-03 | Honda Motor Co., Ltd. | System and method for procurement of products |
| CN101364293A (en) * | 2008-09-24 | 2009-02-11 | 金蝶软件（中国）有限公司 | Method for implementing service data interchange in ERP system, device and system |
| CN101388087A (en) * | 2008-10-23 | 2009-03-18 | 金蝶软件（中国）有限公司 | Method and apparatus for generating service document voucher |
| CN101504640A (en) * | 2009-03-23 | 2009-08-12 | 金蝶软件（中国）有限公司 | Data sheet editing method and apparatus |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN104503955A (en) * | 2014-12-03 | 2015-04-08 | 中建材国际贸易有限公司 | Method for generating personalized excel form |
| CN108509400A (en) * | 2018-02-07 | 2018-09-07 | 平安普惠企业管理有限公司 | Document template generation method, device, computer equipment and storage medium |
| CN109918416A (en) * | 2019-02-28 | 2019-06-21 | 生活空间(沈阳)数据技术服务有限公司 | A kind of method, device and equipment of document entry |
| CN110221790A (en) * | 2019-05-28 | 2019-09-10 | 迈克医疗电子有限公司 | Universal printing method and device, analysis instrument and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 在管理信息系统中单据设计的新方法;邓春燕等;《吉林大学学报(信息科学版)》(第02期);全文 * |
| 如何将PDF表单转换为excel表格;天降猛男;《https://blog.csdn.net/zbzcb/artical/details/83028889》;正文第1-5页，以及图1-2 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111090978A (en) | 2020-05-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107832045B (en) | Method and apparatus for cross programming language interface conversion | |
| US20210232490A1 (en) | Customizable Enterprise Automation Test Framework | |
| US8555248B2 (en) | Business object change management using release status codes | |
| US20110264591A1 (en) | Method and platform for integrating a heterogeneous workgroup collaborative design system and a plm system | |
| US20130159840A1 (en) | Document template dynamic token population | |
| US11256743B2 (en) | Intermixing literal text and formulas in workflow steps | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| WO2011062742A2 (en) | Validation pipeline | |
| CN105975446A (en) | Method and system for displaying word document content by modules in mobile phone terminal | |
| CN111090978B (en) | Document processing method and device and storage medium | |
| CN115115062B (en) | Machine learning model building method, related device and computer program product | |
| CN115964054A (en) | Application service deployment method and device | |
| CN113138760B (en) | Page generation method and device, electronic equipment and medium | |
| CN113177059A (en) | Method and device for generating matching platform SQL script | |
| CN112507677A (en) | Method and device for inputting and displaying electronic form | |
| CN112926294A (en) | Template file generation method and device | |
| CN112835574B (en) | Method and device for processing scalable vector graphic icons | |
| CN117008890B (en) | Extended application development system and method | |
| CN111143408B (en) | Event processing method and device based on business rule | |
| CN117608839A (en) | Task processing method, device, electronic equipment and storage medium | |
| CN116974551A (en) | Application construction method and device, electronic equipment and storage medium | |
| CN113296670A (en) | Regularization expression method of editable parameters | |
| CN114780580A (en) | SQL statement generation method, device, equipment, storage medium and product | |
| CN113111051A (en) | Data migration method and device | |
| CN117896373A (en) | File uploading method, device, equipment and 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |