CN111767704B - Excel form template generation method and device - Google Patents
Excel form template generation method and device Download PDFInfo
- Publication number
- CN111767704B CN111767704B CN202010612312.3A CN202010612312A CN111767704B CN 111767704 B CN111767704 B CN 111767704B CN 202010612312 A CN202010612312 A CN 202010612312A CN 111767704 B CN111767704 B CN 111767704B
- Authority
- CN
- China
- Prior art keywords
- template
- data
- target template
- information
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000012545 processing Methods 0.000 claims description 19
- 230000008676 import Effects 0.000 claims description 16
- 238000013506 data mapping Methods 0.000 claims description 11
- 238000013507 mapping Methods 0.000 claims description 11
- 239000000758 substrate Substances 0.000 claims 1
- 238000011161 development Methods 0.000 description 11
- 230000008859 change Effects 0.000 description 9
- 238000007726 management method Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 238000006243 chemical reaction Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000012795 verification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 238000012360 testing method Methods 0.000 description 3
- 230000009466 transformation Effects 0.000 description 3
- 238000009795 derivation Methods 0.000 description 2
- 238000009434 installation Methods 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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)
- Stored Programmes (AREA)
Abstract
The invention provides an Excel form template generation method and device, wherein the method comprises the following steps: receiving a generation instruction of generating an Excel form template by a user-input identifier, wherein the generation instruction comprises basic information of a target template to be generated, and a blank Excel form is newly built according to the generation instruction and the basic information; according to the basic information, at least one piece of data information related to the target template is obtained from a data source, and selection information input by a user is received, wherein the selection information comprises at least one piece of data information selected by the user; and generating the target template according to at least one piece of data information and the blank Excel table. The scheme of the invention can generate the Excel form template more conveniently.
Description
Technical Field
The invention relates to the technical field of computers, in particular to an Excel form template generation method and device.
Background
Excel forms are office software that people often use in their daily lives. When data is processed in a batch in a software system, the data is often required to be processed through an Excel table. When data are processed in batches, an Excel form template is established in advance, and then the data to be processed or arranged are imported or exported into the established Excel form template.
However, when the imported and exported data change, a developer is required to reset the already set Excel table, namely, a blank Excel table is newly built and the data is imported or exported one by one again to generate a new template, and after the new template is generated, test verification is required to be performed again before the template is used, so that the system is very inconvenient to deploy.
Thus, there is a need for a convenient way to generate Excel form templates.
Disclosure of Invention
The embodiment of the invention provides an Excel form template generation method and device, which can generate an Excel form template more conveniently.
In a first aspect, an embodiment of the present invention provides a method for generating an Excel table template, including:
receiving a generation instruction of generating an Excel form template by a user-input identifier, wherein the generation instruction comprises basic information of a target template to be generated, and a blank Excel form is newly built according to the generation instruction and the basic information;
according to the basic information, at least one piece of data information related to the target template is obtained from a data source, and selection information input by a user is received, wherein the selection information comprises at least one piece of data information selected by the user;
and generating the target template according to at least one piece of data information and the blank Excel table.
Preferably, the method comprises the steps of,
the basic information includes: template number, template name, and/or template type;
the template type includes: import or export;
the data information includes: fields, data descriptions, primary keys, must fill, data types, lengths, default values, data associations, and/or data mappings.
Preferably, the method comprises the steps of,
the obtaining at least one data information related to the target template from a data source according to the basic information comprises the following steps: searching at least one data information related to the template name and the template type in the data source, and acquiring at least one data information.
Preferably, the method comprises the steps of,
the generating the target template according to at least one piece of the data information and the blank Excel table comprises the following steps:
and adding a table header information identifier to a cell at a first row position of a first column of the target template, sequentially describing at least one data of the data information as table header information of each row of the target template, and mapping the fields, the primary key, the necessary padding, the data type, the length, the default value, the data association and/or the data as table header information of each column to generate the target template.
Preferably, the method comprises the steps of,
further comprises: determining a first version number of the target template, uploading the target template and storing the target template in a storage server;
receiving an editing instruction aiming at the target template sent by a user, wherein the editing instruction comprises
And acquiring header information corresponding to the data information added, deleted or modified in the target template according to the editing request from the template server to obtain the modified target template, determining a second version number of the modified target template, and storing the modified target template in the storage server.
Preferably, the method comprises the steps of,
further comprises: receiving an enabling or disabling request for the target template sent by a user, setting the target template to be in a downloadable state according to the enabling request, and setting the target template to be in a non-downloadable state according to the disabling request;
preferably, the method comprises the steps of,
further comprises: and receiving a version selection instruction which is sent by a user and aims at a target template, and judging that the target template corresponding to the target version number is downloaded from the template server according to the target version number contained in the version selection instruction.
In a second aspect, an embodiment of the present invention provides an Excel form template generating apparatus, including:
the device comprises a receiving module, an acquisition module and a processing module;
the receiving module is used for receiving a generation instruction of generating an Excel form template by a user-input identifier, wherein the generation instruction comprises basic information of a target template to be generated, and a blank Excel form is newly built according to the generation instruction and the basic information;
the acquisition module is used for acquiring at least one piece of data information related to the target template from a data source according to the basic information and receiving selection information input by a user, wherein the selection information comprises at least one piece of data information selected by the user;
and the processing module is used for generating the target template according to at least one piece of data information and the blank Excel table.
Preferably, the method comprises the steps of,
the basic information includes: template number, template name, and/or template type;
the template type includes: import or export;
the data information includes: fields, data descriptions, primary keys, must fill, data types, lengths, default values, data associations, and/or data mappings.
Preferably, the method comprises the steps of,
the acquiring unit specifically performs, when performing the acquiring, according to the basic information, at least one data information related to the target template from a data source: searching at least one data information related to the template name and the template type in the data source, and acquiring at least one data information.
Preferably, the method comprises the steps of,
the processing module specifically performs when executing the generation of the target template according to at least one piece of the data information and the blank Excel table:
and adding a table header information identifier to a cell at a first row position of a first column of the target template, sequentially describing at least one data of the data information as table header information of each row of the target template, and mapping the fields, the primary key, the necessary padding, the data type, the length, the default value, the data association and/or the data as table header information of each column to generate the target template.
Preferably, the method comprises the steps of,
the processing module is further used for determining a first version number of the target template, uploading the target template and storing the target template in a storage server;
receiving an editing instruction aiming at the target template sent by a user, wherein the editing instruction comprises
And acquiring header information corresponding to the data information added, deleted or modified in the target template according to the editing request from the template server to obtain the modified target template, determining a second version number of the modified target template, and storing the modified target template in the storage server.
The processing module is further used for receiving an enabling or disabling request for the target template sent by a user, setting the target template to be in a downloadable state according to the enabling request, and setting the target template to be in a non-downloadable state according to the disabling request;
preferably, the method comprises the steps of,
the processing module is further configured to receive a version selection instruction sent by a user for a target template, and determine that the target template corresponding to the target version number is downloaded from the template server according to the target version number included in the version selection instruction.
The embodiment of the invention provides an Excel form template generation method and device, wherein the method comprises the following steps: firstly, a blank Excel table is established, the table is the basis of a target template to be generated, basic information of the target template to be generated is determined, a plurality of data information related to the target template is obtained from a data source according to the basic information, a user selects the data information which needs to be filled into the target template from the plurality of data information, and the target template is generated according to the data information selected by the user and the blank Excel table generated before. According to the scheme provided by the invention, in the project proceeding process, the Excel form template can be customized according to different actual requirements, and the data information required by the form generation in the data source is selected according to the requirements to generate the form, so that the code writing and server deployment are not involved, the development of subsequent business is not influenced, the continuously-changing Excel form template generating requirements can be met through flexible configuration, and the user is not required to manually import and export various data in the Excel form template, so that the scheme of the invention can more conveniently generate the Excel form template.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a method for generating an Excel form template according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of data information according to an embodiment of the present invention;
FIG. 3 is a diagram of a payment information derivation template according to an embodiment of the present invention;
fig. 4 is a schematic diagram of an Excel form template generating apparatus according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments, and all other embodiments obtained by those skilled in the art without making any inventive effort based on the embodiments of the present invention are within the scope of protection of the present invention.
Excel forms are office software that people often use in their daily lives. When data is processed in a batch in a software system, the data is often required to be processed through an Excel table. When data are processed in batches, an Excel form template is established in advance, and then the data to be processed or arranged are imported or exported into the established Excel form template. However, when the imported and exported data change, a developer is required to reset the already set Excel table, namely, a blank Excel table is newly built and the data is imported or exported one by one again to generate a new template, and after the new template is generated, test verification is required to be performed again before the template is used, so that the system is very inconvenient to deploy. The solution of the present invention is based on the above-mentioned drawbacks.
As shown in fig. 1, an embodiment of the present invention provides a method for generating an Excel table template, including:
step 101: receiving a generation instruction of generating an Excel form template by a user-input identifier, wherein the generation instruction comprises basic information of a target template to be generated, and a blank Excel form is newly built according to the generation instruction and the basic information.
Step 102: and according to the basic information, at least one piece of data information related to the target template is acquired from a data source, and selection information input by a user is received, wherein the selection information comprises at least one piece of data information selected by the user.
Step 103: and generating the target template according to at least one piece of data information and the blank Excel table.
The embodiment of the invention provides an Excel form template generation method, which comprises the steps of firstly creating a blank Excel form, determining basic information of a target template to be generated on the basis of the target template to be generated, acquiring a plurality of data information related to the target template from a data source according to the basic information, selecting the data information required to be filled into the target template from the plurality of data information by a user, and generating the target template according to the data information selected by the user and the blank Excel form generated before. According to the scheme provided by the invention, in the project proceeding process, the Excel form template can be customized according to different actual requirements, and the data information required by the form generation in the data source is selected according to the requirements to generate the form, so that the code writing and server deployment are not involved, the development of subsequent business is not influenced, the continuously-changing Excel form template generating requirements can be met through flexible configuration, and the user is not required to manually import and export various data in the Excel form template, so that the scheme of the invention can more conveniently generate the Excel form template.
In an embodiment of the present invention, the basic information includes: template number, template name, and/or template type;
the template type includes: import or export;
the data information includes: fields, data descriptions, primary keys, must fill, data types, lengths, default values, data associations, and/or data mappings.
Specifically, the invention is realized by installing the patch package on the file management platform, the patch package for executing the method is subjected to patch installation through a general patch installation tool, and then the template management interface provided on the file management platform can be used for creating and managing the template. The template number is the unique identity number of the template, the template name is the name of the related content of the template, the template type is divided into an import template and an export template, and the basic information of the templates needs to be input by a user when the template is newly built. In general, an export template is obtained from a data source, the import template is self-entry data, and a user can decide whether the template type is an import template or an export template according to contents to be filled in the template. For example, a user needs to acquire a payment application form from the internet, enter a template management interface, first create a blank Excel form with a template type of an export template, then input a template number and a template name of a "payment application form export template", and the template type is the export template.
In an embodiment of the present invention, the obtaining, in step 102, at least one data information related to the target template from a data source according to the basic information includes: searching at least one data information related to the template name and the template type in the data source, and acquiring at least one data information.
Specifically, the user has newly built an export template named "payment application export template" on the template management interface, and then opens the data source configuration interface of the management platform to perform data source configuration. Currently, data sources support databases (SQL, tables, views, stored procedures) and generic data structures (JSON, XML). The following is exemplified by a database.
Setting the number, namely the name, of the data source in the attribute area of the data source configuration interface, namely the corresponding number of the payment information data source, such as DS20200229002; the data source type is selected as the database. The data source then provides data information for all payment information, including document ID, document number, unit number, payment amount, etc., such as a schematic representation of one type of data information including fields, data description, primary key, fill-in, data type, length, default value, data association, and/or data mapping, as shown in fig. 2. The default values can be set according to requirements, texts and functions are supported, and because some templates need default values of a certain parameter in data information, some templates do not need the data information, such as payment date, corresponding dates need to be filled in a form, business types do not need to fill in dates, and in order to unify the format, a column of the default values corresponding to the business types is filled with default values of one date. Default values typically include: GUID: a globally unique identifier; DATE: a current date; TIME: a current time; USER: the current registrant. As with the item of data information of document ID in fig. 2, the document ID may be set to the [ guid# ] double-alarm representative function setting. In addition, data association can be set in the templates, and standard association templates for providing basic data of some columns are provided, for example: units, banks, accounts, customers, etc., and may also customize the associated information. Specifically, each unit, bank, account, guest, etc. has a corresponding associated name because the names of the specific unit, bank, account, guest, etc. cannot be filled in the form. For example, a piece of data information is a bank running water, and then the associated name of the bank corresponding to the bank running water is filled in at the place where the data is associated, and the character is usually a string of letters. Meanwhile, data mapping can be set for data mapping conversion. For example, an account is used for mapping a person, an account is used for mapping a unit, and when information of the person or the unit needs to be filled in a form, the personal information and the unit information are replaced by filling in the corresponding mapped account or account.
In an embodiment of the present invention, the generating the target template according to at least one piece of the data information and the blank Excel table in step 103 includes:
and adding a table header information identifier to a cell at a first row position of a first column of the target template, sequentially describing at least one data of the data information as table header information of each row of the target template, and mapping the fields, the primary key, the necessary padding, the data type, the length, the default value, the data association and/or the data as table header information of each column to generate the target template.
Specifically, the user clicks a column information generation button on the data source configuration interface to generate corresponding column information for each data information, wherein the column information comprises the fields, the primary key, the necessary padding, the data type, the length, the default value, the data association and/or the data mapping, then a blank Excel template newly established before is selected, then the column information is imported into the Excel template, the template attribute is automatically loaded, the header information is loaded on the first row and the first column of the cell of the Excel template, then the column information is imported, the header information is automatically matched, and the corresponding data such as the data type, the length information and the like are loaded. The user can also adjust the mapping field corresponding relation according to the actual situation, provide configuration information such as data mapping, data conversion, format conversion, column width and the like, and meet the conversion of the derived information. A payment information derivation template is shown in FIG. 3, wherein header information of each row is the name of a plurality of data information selected by a user in the payment information, and the name comprises a bill number, a payment unit, a payment amount and a payment abstract. The header information of each column is information included in each data name, including a mapping field, a data type, a length, a default value, data conversion, format conversion, and column width. The template is a derived template of payment information, so that data can be inquired from a data source and directly filled into a form. If it is an import form, the user is required to manually input data to be imported.
In an embodiment of the present invention, the method further includes: determining a first version number of the target template, uploading the target template and storing the target template in a storage server;
receiving an editing instruction aiming at the target template sent by a user, wherein the editing instruction comprises
And acquiring header information corresponding to the data information added, deleted or modified in the target template according to the editing request from the template server to obtain the modified target template, determining a second version number of the modified target template, and storing the modified target template in the storage server.
In an embodiment of the present invention, the method further includes: receiving an enabling or disabling request for the target template sent by a user, setting the target template to be in a downloadable state according to the enabling request, and setting the target template to be in a non-downloadable state according to the disabling request.
In particular, the template management interface may perform operations such as viewing, editing, deleting, enabling, disabling, etc. the template. After a target Excel form template is generated, the target Excel form template is stored in a template server of the template management software, and an initial version is generated. After the user edits or deletes the target Excel form template each time, a new version is generated, the versions are stored in the template server, the user can check and download the historical version, backtrack the historical version of the template, and the problem of data loss during misoperation is avoided.
In addition, the scheme provided by the invention can also provide multi-Sheet page template configuration, and the configuration is carried out by selecting different pages to bind data sources respectively. The paging export attribute is provided, and when the data information is too much, the paging export template can be used for avoiding the performance problem caused by export of a large amount of data. And providing program expansion attributes, and realizing personalized processing by configuring a service logic component.
The data import and export are realized through the template configuration and the data source configuration functions, and the code development is not involved. Compared with the traditional code customization implementation mode, when the import and export scenes change, the configuration tool can be more advantageous.
When the scene is changed, the traditional development mode needs to carry out the transformation of the access logic and the import and export logic, test and verification of testers, user verification and deployment on-line process. Not only affects the normal development of other businesses and increases the development cost, but also has a certain project risk. The configuration tool is realized based on standardized parameter configuration and has certain stability. When the scene is changed, only the template or the data source which needs to be changed is needed to be adjusted, and the scene can be immediately used in effect after being started.
The following list a few common scene changes, implementations using this tool:
scene change: the derived information increases.
When the derived column information increases, the data source is modified first, the corresponding column information is increased, and then the template configuration interface is removed to configure the corresponding column settings.
Scene change: the column information change is derived.
And when the mapping relation, the joint check relation or the format is transformed, corresponding configuration adjustment is carried out on the template configuration interface.
Scene change: the data source changes are derived.
When the export service is completely changed, the template configuration can be carried out again by reformulating the export template and adding a new data source.
The whole process for dealing with scene change is a configuration modification process, does not relate to code transformation and server upgrading deployment, and does not influence service development. Through flexible configuration, users can cope with report requirements changing in real time, and development cost is greatly saved.
As shown in fig. 4, an embodiment of the present invention provides an Excel form template generating apparatus, including: a receiving module 401, an acquiring module 402 and a processing module 403;
the receiving module 401 is configured to receive a generation instruction for generating an Excel form template according to an identifier input by a user, where the generation instruction includes basic information of a target template to be generated, and newly build a blank Excel form according to the generation instruction and the basic information;
the acquiring module 402 is configured to acquire at least one data information related to the target template from a data source according to the basic information, and receive selection information input by a user, where the selection information includes at least one data information selected by the user;
the processing module 403 is configured to generate the target template according to at least one piece of the data information and the blank Excel table.
In an embodiment of the present invention, the basic information includes: template number, template name, and/or template type;
the template type includes: import or export;
the data information includes: fields, data descriptions, primary keys, must fill, data types, lengths, default values, data associations, and/or data mappings.
In an embodiment of the present invention, when the obtaining unit obtains at least one data information related to the target template from a data source according to the basic information, the obtaining unit specifically performs: searching at least one data information related to the template name and the template type in the data source, and acquiring at least one data information.
In an embodiment of the present invention, when executing the generating the target template according to at least one piece of the data information and the blank Excel table, the processing module 403 specifically executes:
and adding a table header information identifier to a cell at a first row position of a first column of the target template, sequentially describing at least one data of the data information as table header information of each row of the target template, and mapping the fields, the primary key, the necessary padding, the data type, the length, the default value, the data association and/or the data as table header information of each column to generate the target template.
In an embodiment of the present invention, the processing module 403 is further configured to determine a first version number of the target template, upload and save the target template to a storage server;
receiving an editing instruction aiming at the target template sent by a user, wherein the editing instruction comprises
And acquiring header information corresponding to the data information added, deleted or modified in the target template according to the editing request from the template server to obtain the modified target template, determining a second version number of the modified target template, and storing the modified target template in the storage server.
The processing module 403 is further configured to receive an enabling or disabling request for the target template sent by a user, set the target template to a downloadable state according to the enabling request, and set the target template to a non-downloadable state according to the disabling request;
in an embodiment of the present invention, the processing module 403 is further configured to receive a version selection instruction sent by a user for a target template, and determine that the target template corresponding to the target version number is downloaded from the template server according to a target version number included in the version selection instruction.
It will be appreciated that the structure illustrated in the embodiments of the present invention does not constitute a specific limitation on the Excel form template generating apparatus. In other embodiments of the invention, the Excel sheet template generation apparatus may include more or fewer components than shown, or combine certain components, or split certain components, or a different arrangement of components. The illustrated components may be implemented in hardware, software, or a combination of software and hardware.
The content of information interaction and execution process between the units in the device is based on the same conception as the embodiment of the method of the present invention, and specific content can be referred to the description in the embodiment of the method of the present invention, which is not repeated here.
Various embodiments of the present invention have at least the following advantages:
1. in the embodiment of the invention, in the project proceeding process, the Excel form template can be customized according to different actual demands, and the data information required by the form generation in the data source is selected according to the demands to generate the form, so that the code writing and the server deployment are not involved, the development of subsequent business is not influenced, the continuously-changing Excel form template generating demands can be met through flexible configuration, and the user is not required to manually import and export various data in the Excel form template, therefore, the scheme of the invention can more conveniently generate the Excel form template.
2. In the embodiment of the invention, the modification of the table for the data change is a configuration modification process, the code transformation and the server upgrading deployment are not involved, and the service development is not influenced. Through flexible configuration, users can cope with report requirements changing in real time, and development cost is greatly saved.
3. In the embodiment of the invention, the template management interface can perform operations such as checking, editing, deleting, enabling and disabling the template, and support backtracking of the historical version of the template, so that the problem of data loss during misoperation is avoided.
4. In the embodiment of the invention, the program set expansion event is supported, and the program set can be specified to be personalized for the requirement that the configuration cannot be realized.
It should be noted that not all the steps and modules in the above flowcharts and the system configuration diagrams are necessary, and some steps or modules may be omitted according to actual needs. The execution sequence of the steps is not fixed and can be adjusted as required. The system structure described in the above embodiments may be a physical structure or a logical structure, that is, some modules may be implemented by the same physical entity, or some modules may be implemented by multiple physical entities, or may be implemented jointly by some components in multiple independent devices.
In the above embodiments, the hardware unit may be mechanically or electrically implemented. For example, a hardware unit may include permanently dedicated circuitry or logic (e.g., a dedicated processor, FPGA, or ASIC) to perform the corresponding operations. The hardware unit may also include programmable logic or circuitry (e.g., a general-purpose processor or other programmable processor) that may be temporarily configured by software to perform the corresponding operations. The particular implementation (mechanical, or dedicated permanent, or temporarily set) may be determined based on cost and time considerations.
While the invention has been illustrated and described in detail in the drawings and in the preferred embodiments, the invention is not limited to the disclosed embodiments, and it will be appreciated by those skilled in the art that the code audits of the various embodiments described above may be combined to produce further embodiments of the invention, which are also within the scope of the invention.
Claims (5)
- An excel form template generation method, which is characterized by comprising the following steps:receiving a generation instruction of generating an Excel form template by a user-input identifier, wherein the generation instruction comprises basic information of a target template to be generated, and a blank Excel form is newly built according to the generation instruction and the basic information;according to the basic information, at least one piece of data information related to the target template is obtained from a data source, and selection information input by a user is received, wherein the selection information comprises at least one piece of data information selected by the user;generating the target template according to at least one piece of data information and the blank Excel table;the basic information includes: template number, template name, and/or template type;the template type includes: import or export;the data information includes: fields, data descriptions, primary keys, padding, data types, lengths, default values, data associations, and/or data mappings;the generating the target template according to at least one piece of the data information and the blank Excel table comprises the following steps:adding a header information identifier to a cell at a first row position of a first column of the target template, sequentially describing at least one data of the data information as header information of each row of the target template, and mapping the field, the primary key, the necessary padding, the data type, the length, the default value, the data association and/or the data as header information of each column to generate the target template;further comprises: determining a first version number of the target template, uploading the target template and storing the target template in a storage server;receiving an editing instruction aiming at the target template sent by a user, wherein the editing instruction comprises an editing request for adding, deleting or modifying at least one piece of data information, acquiring header information corresponding to the corresponding data information added, deleted or modified in the target template according to the editing request from the template server, obtaining the modified target template, determining a second version number of the modified target template, and storing the modified target template in the storage server;and/or the number of the groups of groups,further comprises: receiving an enabling or disabling request for the target template sent by a user, setting the target template to be in a downloadable state according to the enabling request, and setting the target template to be in a non-downloadable state according to the disabling request.
- 2. The method of claim 1, wherein the step of determining the position of the substrate comprises,the obtaining at least one data information related to the target template from a data source according to the basic information comprises the following steps: searching at least one data information related to the template name and the template type in the data source, and acquiring at least one data information.
- 3. The method according to any one of claims 1-2, wherein,further comprises: and receiving a version selection instruction which is sent by a user and aims at a target template, and judging that the target template corresponding to the target version number is downloaded from the template server according to the target version number contained in the version selection instruction.
- An excel form template generation device, characterized by comprising:the device comprises a receiving module, an acquisition module and a processing module;the receiving module is used for receiving a generation instruction of generating an Excel form template by a user-input identifier, wherein the generation instruction comprises basic information of a target template to be generated, and a blank Excel form is newly built according to the generation instruction and the basic information;the acquisition module is used for acquiring at least one piece of data information related to the target template from a data source according to the basic information and receiving selection information input by a user, wherein the selection information comprises at least one piece of data information selected by the user;the processing module is used for generating the target template according to at least one piece of data information and the blank Excel table;the basic information includes: template number, template name, and/or template type;the template type includes: import or export;the data information includes: fields, data descriptions, primary keys, padding, data types, lengths, default values, data associations, and/or data mappings;the processing module specifically performs when executing the generation of the target template according to at least one piece of the data information and the blank Excel table:adding a header information identifier to a cell at a first row position of a first column of the target template, sequentially describing at least one data of the data information as header information of each row of the target template, and mapping the field, the primary key, the necessary padding, the data type, the length, the default value, the data association and/or the data as header information of each column to generate the target template;and/or the number of the groups of groups,the processing module is further used for determining a first version number of the target template, uploading the target template and storing the target template in a storage server;receiving an editing instruction aiming at the target template sent by a user, wherein the editing instruction comprisesObtaining header information corresponding to the data information added, deleted or modified in the target template according to the editing request from the template server to obtain a modified target template, determining a second version number of the modified target template, and storing the modified target template in the storage server;the processing module is further used for receiving an enabling or disabling request for the target template sent by a user, setting the target template to be in a downloadable state according to the enabling request, and setting the target template to be in a non-downloadable state according to the disabling request;and/or the number of the groups of groups,the processing module is further configured to receive a version selection instruction sent by a user for a target template, and determine that the target template corresponding to the target version number is downloaded from the template server according to the target version number included in the version selection instruction.
- 5. The method of claim 4, wherein the step of determining the position of the first electrode is performed,the acquiring unit specifically performs, when performing the acquiring, according to the basic information, at least one data information related to the target template from a data source: searching at least one data information related to the template name and the template type in the data source, and acquiring at least one data information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010612312.3A CN111767704B (en) | 2020-06-30 | 2020-06-30 | Excel form template generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010612312.3A CN111767704B (en) | 2020-06-30 | 2020-06-30 | Excel form template generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111767704A CN111767704A (en) | 2020-10-13 |
| CN111767704B true CN111767704B (en) | 2024-01-26 |
Family
ID=72724219
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010612312.3A Active CN111767704B (en) | 2020-06-30 | 2020-06-30 | Excel form template generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111767704B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112434505A (en) * | 2020-11-24 | 2021-03-02 | 文思海辉智科科技有限公司 | Template generation method and device, computer equipment and storage medium |
| CN112732641A (en) * | 2020-12-30 | 2021-04-30 | 山东浪潮通软信息科技有限公司 | Electronic file filing method, device and medium |
| CN113779943A (en) * | 2021-01-12 | 2021-12-10 | 北京沃东天骏信息技术有限公司 | Table generation method, table generation device, storage medium, and electronic apparatus |
| CN112949267A (en) * | 2021-02-05 | 2021-06-11 | 中国建设银行股份有限公司 | Method and system for generating financial analysis chart |
| CN113011145A (en) * | 2021-03-16 | 2021-06-22 | 深圳市麦谷科技有限公司 | Data export method and device, terminal equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| KR20180004632A (en) * | 2016-07-04 | 2018-01-12 | 한다시스템 주식회사 | Method and computer program for integrating spread sheet with database |
| CN109829141A (en) * | 2018-12-28 | 2019-05-31 | 陈德芹 | A kind of project table generation method and device |
| WO2019205415A1 (en) * | 2018-04-22 | 2019-10-31 | 平安科技（深圳）有限公司 | Data import management method and apparatus, mobile terminal and storage medium |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110295761A1 (en) * | 2010-05-31 | 2011-12-01 | Kabushiki Kaisha Toshiba | Business form management system, method and program |
| MY172251A (en) * | 2014-10-13 | 2019-11-19 | E Manual System Sdn Bhd | System generator module for electronic document and electronic filing |
| CN107153544A (en) * | 2017-05-09 | 2017-09-12 | 合肥汉腾信息技术有限公司 | A kind of Worksheet self-defining method and device |
-
2020
- 2020-06-30 CN CN202010612312.3A patent/CN111767704B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| KR20180004632A (en) * | 2016-07-04 | 2018-01-12 | 한다시스템 주식회사 | Method and computer program for integrating spread sheet with database |
| WO2019205415A1 (en) * | 2018-04-22 | 2019-10-31 | 平安科技（深圳）有限公司 | Data import management method and apparatus, mobile terminal and storage medium |
| CN109829141A (en) * | 2018-12-28 | 2019-05-31 | 陈德芹 | A kind of project table generation method and device |
Non-Patent Citations (2)
| Title |
|---|
| 基于CELL组件的用户自定义报表设计;张蓉;兵工自动化(04);全文 * |
| 基于自定义模板的通用报表设计;金百东;;计算机时代(10);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111767704A (en) | 2020-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111767704B (en) | Excel form template generation method and device | |
| CN107015804B (en) | Method and system for rapidly developing project by configuring API | |
| CN108762743B (en) | Data table operation code generation method and device | |
| CN110716783A (en) | Front-end page generation and deployment method and device, storage medium and equipment | |
| CN101977121A (en) | Configuration file processing method, device and system | |
| CN101499057A (en) | Electronic document generating system and method | |
| CN114981775B (en) | Cloud-based API metadata management method and system for integrated API management | |
| CN109241384B (en) | Scientific research information visualization method and device | |
| CN112364049B (en) | Data synchronization script generation method, system, terminal and storage medium | |
| CN111881042A (en) | Automatic test script generation method and device and electronic equipment | |
| CN111061733B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN110109981B (en) | Information display method and device for work queue, computer equipment and storage medium | |
| CN104885073A (en) | System and method for generating a digital edition | |
| CN106990974B (en) | APP updating method and device and electronic equipment | |
| CN116483344A (en) | Code generation method and device, terminal equipment and computer readable storage medium | |
| EP1122676A1 (en) | Electronic bill creation and presentment system | |
| CN109429260A (en) | A kind of method of calibration and device of northbound data | |
| CN113268232B (en) | Page skin generation method and device and computer readable storage medium | |
| CN115269548A (en) | Method and system for generating data warehouse development model and related equipment | |
| CN114819631A (en) | Multitask visualization method and device, computer equipment and storage medium | |
| CN114386853A (en) | Data auditing processing method, device and equipment based on universal auditing model | |
| CN113822025A (en) | Office file automatic generation method, device, equipment and storage medium | |
| CN114138813A (en) | Attribute configuration method and related device | |
| CN112905178A (en) | Method, device, equipment and medium for generating business function page | |
| CN111523294A (en) | PDF file-based comment separation processing method and device |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20231214 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |