CN117971945A - Data export method, device and medium based on Excel template - Google Patents

Abstract

The application discloses a data export method, equipment and medium based on an Excel template, wherein the method comprises the following steps: determining a preset template rule, determining template parameters, and dynamically binding the template rule and the template parameters to receive data so as to determine a derived template; determining template content of an export template, encrypting the template content, and storing the encrypted export template into a predetermined database; and determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule. The application can rapidly meet the personalized requirements of users through simple configuration, greatly improve the user efficiency and the use experience, analyze and display the exported data from multiple dimensions and angles, enhance the flexibility of functions, reduce the repeated operation of users and improve the office efficiency.

Description

Data export method, device and medium based on Excel template

Technical Field

The present application relates to the field of computer technologies, and in particular, to a method, an apparatus, and a medium for exporting data based on an Excel template.

Background

With the development of digital economies, statistical analysis of data has become a key hub for the value of data generation, but if data is simply collected and stored, the data is only 0 and 1 in the database, and it is difficult to speak what value is worth. The data itself is of little or no value, the value being conferred, the value of the data being derived from our analysis and application of the data.

As data values are mined, requirements for analysis calculations of derived data and presentation of data are becoming increasingly complex. Even different enterprises within the same industry will have a difference in their requirements for deriving Excel.

Disclosure of Invention

In order to solve the above problems, the present application provides a data export method based on an Excel template, including: determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template; determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database; and determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.

In one example, after receiving the data, the method further comprises: determining the template rule, determining a plurality of template data tables, and filling the data into the plurality of template data tables; and determining a preset analysis table, and configuring the plurality of template data tables through the analysis table to obtain a pivot table.

In one example, determining the derived templates specifically includes: and packaging the plurality of template data tables and the pivot table to form the export template, encrypting the export template, and uploading the encrypted export template to a predetermined server.

In one example, the method further comprises: determining a template export application of a user, and determining export options according to the template export application; and determining a deletion data table corresponding to the export template according to the export option, and deleting the deletion data table.

In one example, determining, by the database, a default derived template specifically includes: determining history export data through the database, and determining the history export quantity of the template parameters according to the history export data; determining a preset default index, and screening the template parameters according to the default index to obtain default parameters; and determining the default export template according to the default parameters.

In one example, assigning the decrypted default derived template according to the template rule specifically includes: determining the analysis table according to the assigned default export template, and extracting data according to the analysis table to obtain export data; and carrying out data processing on the export data according to the pivot table, and downloading the export data after data processing.

In one example, the data processing for the derived data according to the pivot table specifically includes: determining table parameters of the pivot table, and screening the derived data according to the table parameters; updating the pivot table according to the filtered derived data, and performing POI analysis on the updated pivot table so as to assign a value to the pivot table according to the content of the POI analysis.

In one example, after assigning the decrypted default derived template according to the template rule, the method further comprises: and determining a plurality of pivot tables after assignment, and downloading the pivot tables to finish data export.

On the other hand, the application also provides a data export device based on the Excel template, which comprises: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the Excel template-based data export device to perform: determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template; determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database; and determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.

In another aspect, the present application also provides a non-volatile computer storage medium storing computer-executable instructions configured to: determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template; determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database; and determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.

The application improves the flexibility of inquiring and exporting by carrying out repeated utilization for multiple times through the one-time configuration of the exporting template. The application can rapidly meet the personalized requirements of users through simple configuration, greatly improve the user efficiency and the use experience, analyze and display the exported data from multiple dimensions and angles, enhance the flexibility of functions, reduce the repeated operation of users and improve the office efficiency.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute a limitation on the application. In the drawings:

Fig. 1 is a schematic flow chart of a data export method based on an Excel template in an embodiment of the present application;

fig. 2 is a schematic diagram of a data deriving device based on an Excel template in an embodiment of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

The following describes in detail the technical solutions provided by the embodiments of the present application with reference to the accompanying drawings.

At present, under certain demand scenes, an Excel file derived from a simple standard query report cannot completely meet the actual demands of users, and when the users need to analyze the derived file in data perspective, statistics and the like, the Excel file can be used by secondary processing.

As shown in fig. 1, in order to solve the above problem, the method for exporting data based on an Excel template according to the embodiment of the present application includes:

S101, determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template.

When uploading the export template, providing standard template rules, wherein the template rules are to create corresponding templates according to a preset mode, for example, if the template is title information, the template is corresponding to: "t_header field to be acquired", if column information, corresponds to: "field corresponding to column c_to be obtained", a field may be understood as a title in an Excel table, for example, a name, a class, etc. The user determines template parameters according to the rules, for example, dynamically binds information of columns, titles, variables and the like of the data according to the rules, for example, the column information is 'name', the data acquired from the database has the dynamic binding of the small brightness, the small red and the like, and the acquired name is assigned to the column of 'name'. Sheet1, the analytical table, of data reception was finally determined in Excel. Meanwhile, analyzing and processing data received by Sheet 1in other Sheet pages, making a universal pivot table in Excel according to respective requirements in a template, analyzing the data by using the pivot table), acquiring the data in the template, assigning the data to the pivot table, and generating partial data required by customers through self-defined analysis in the Excel. And creating a corresponding pivot table according to the configuration of the data Sheet, setting query conditions, pivot fields and the like to form a complete export template, wherein the export template comprises the pivot table and Sheet pages configured according to template rules, encrypting and uploading the Sheet pages to a server.

S102, determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database.

And (5) carrying out encryption processing and deletion on the content of the export template, and setting a default export template. The template content is a pivot table and a sheet page configured according to the template rule. The template content is processed, for example, RSA encrypted, and stored in a predetermined database. Meanwhile, the template has the information of names, uploading people, uploading time and the like, and a user judges whether to continue to use or not according to the information and deletes the unused template.

S103, determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.

And setting a default export template through the database, and exporting the query report according to the default template when exporting the query report according to the template.

In one embodiment, the historical export data is determined by a database, and the historical export quantity of the template parameters is determined from the historical export data; determining a preset default index, screening template parameters according to the default index, and selecting parameters with history derived quantity larger than that of a default value table to form default parameters; a default export template is generated based on the default parameters for provision to the first-time user.

Decrypting the content of the template based on the default derived template, and performing data assignment according to the template rule, wherein the data assignment comprises title, column information and the like. And after the assignment is successful, acquiring information which needs to be counted by a user according to the data statistics pivot table, and carrying out data updating processing, wherein the updated data is data configured in the pivot table, and the unconfigured data do not need to be updated, the updating mode is that the whole pivot table is acquired in a program, the pivot table is analyzed through a POI method, and finally the analyzed content is assigned in the program, wherein the POI is a high-performance component API provided by a programming language. After the update processing is completed, the data is downloaded and exported, and in practical application, a plurality of perspective tables can be configured in the template, namely, a plurality of different data perspective tables can be supported.

In one embodiment, a user submits a template export application, and a database determines export options according to the template export application; and determining a deletion data table corresponding to the export template according to the export option, and deleting the deletion data table.

As shown in fig. 2, the embodiment of the present application further provides an Excel template-based data export device, including:

At least one processor; and

A memory communicatively coupled to the at least one processor; wherein,

The memory stores instructions executable by the at least one processor to enable an Excel template-based data export device to perform:

Determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template;

Determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database;

And determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.

The embodiment of the application also provides a nonvolatile computer storage medium, which stores computer executable instructions, wherein the computer executable instructions are configured to:

Determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template;

Determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database;

And determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.

In the 90 s of the 20 th century, improvements to one technology could clearly be distinguished as improvements in hardware (e.g., improvements to circuit structures such as diodes, transistors, switches, etc.) or software (improvements to the process flow). However, with the development of technology, many improvements of the current method flows can be regarded as direct improvements of hardware circuit structures. Designers almost always obtain corresponding hardware circuit structures by programming improved method flows into hardware circuits. Therefore, an improvement of a method flow cannot be said to be realized by a hardware entity module. For example, a programmable logic device (Programmable Logic Device, PLD) (e.g., field programmable gate array (Field Programmable GATE ARRAY, FPGA)) is an integrated circuit whose logic functions are determined by user programming of the device. A designer programs to "integrate" a digital system onto a PLD without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Moreover, nowadays, instead of manually manufacturing integrated circuit chips, such programming is mostly implemented with "logic compiler (logic compiler)" software, which is similar to the software compiler used in program development and writing, and the original code before being compiled is also written in a specific programming language, which is called hardware description language (Hardware Description Language, HDL), but HDL is not just one, but a plurality of kinds, such as ABEL(Advanced Boolean Expression Language)、AHDL(Altera Hardware Description Language)、Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL(Ruby Hardware Description Language), and VHDL (Very-High-SPEED INTEGRATED Circuit Hardware Description Language) and Verilog are currently most commonly used. It will also be apparent to those skilled in the art that a hardware circuit implementing the logic method flow can be readily obtained by merely slightly programming the method flow into an integrated circuit using several of the hardware description languages described above.

The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer readable medium storing computer readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, application SPECIFIC INTEGRATED Circuits (ASICs), programmable logic controllers, and embedded microcontrollers, examples of controllers include, but are not limited to, the following microcontrollers: ARC 625D, atmel AT91SAM, microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic of the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller in a pure computer readable program code, it is well possible to implement the same functionality by logically programming the method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers, etc. Such a controller may thus be regarded as a kind of hardware component, and means for performing various functions included therein may also be regarded as structures within the hardware component. Or even means for achieving the various functions may be regarded as either software modules implementing the methods or structures within hardware components.

The system, apparatus, module or unit set forth in the above embodiments may be implemented in particular by a computer chip or entity, or by a product having a certain function. One typical implementation is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.

For convenience of description, the above devices are described as being functionally divided into various units, respectively. Of course, the functions of each element may be implemented in one or more software and/or hardware elements when implemented in the present specification.

The embodiments of the present application are described in a progressive manner, and the same and similar parts of the embodiments are all referred to each other, and each embodiment is mainly described in the differences from the other embodiments. In particular, for the apparatus and medium embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, with reference to the section of the method embodiments being relevant.

The devices and media provided in the embodiments of the present application are in one-to-one correspondence with the methods, so that the devices and media also have similar beneficial technical effects as the corresponding methods, and since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media are not repeated here.

It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.

Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.

It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises an element.

The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and variations of the present application will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. which come within the spirit and principles of the application are to be included in the scope of the claims of the present application.

Claims (10)

1. The data export method based on the Excel template is characterized by comprising the following steps of:

Determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template;

Determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database;

And determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.

2. The method of claim 1, wherein after receiving the data, the method further comprises:

determining the template rule, determining a plurality of template data tables, and filling the data into the plurality of template data tables;

And determining a preset analysis table, and configuring the plurality of template data tables through the analysis table to obtain a pivot table.

3. The method according to claim 2, characterized in that determining the derived template comprises in particular:

And packaging the plurality of template data tables and the pivot table to form the export template, encrypting the export template, and uploading the encrypted export template to a predetermined server.

4. The method according to claim 1, wherein the method further comprises:

Determining a template export application of a user, and determining export options according to the template export application;

And determining a deletion data table corresponding to the export template according to the export option, and deleting the deletion data table.

5. The method according to claim 1, characterized in that determining a default derived template by means of the database, in particular comprises:

determining history export data through the database, and determining the history export quantity of the template parameters according to the history export data;

Determining a preset default index, and screening the template parameters according to the default index to obtain default parameters;

And determining the default export template according to the default parameters.

6. The method according to claim 2, wherein assigning the decrypted default derived template according to the template rules comprises:

Determining the analysis table according to the assigned default export template, and extracting data according to the analysis table to obtain export data;

And carrying out data processing on the export data according to the pivot table, and downloading the export data after data processing.

7. The method according to claim 6, wherein the data processing of the derived data according to the pivot table specifically comprises:

Determining table parameters of the pivot table, and screening the derived data according to the table parameters;

updating the pivot table according to the filtered derived data, and performing POI analysis on the updated pivot table so as to assign a value to the pivot table according to the content of the POI analysis.

8. The method of claim 7, wherein after assigning the decrypted default derived template according to the template rules, the method further comprises:

And determining a plurality of pivot tables after assignment, and downloading the pivot tables to finish data export.

9. An Excel template-based data export device, comprising:

At least one processor; and

A memory communicatively coupled to the at least one processor; wherein,

The memory stores instructions executable by the at least one processor to enable the Excel template-based data export device to perform:

Determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template;

Determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database;

And determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.

10. A non-transitory computer storage medium storing computer-executable instructions, the computer-executable instructions configured to:

Determining a preset template rule, determining template parameters, and dynamically binding the template rule with the template parameters to receive data so as to determine a derived template;

Determining the template content of the derived template, encrypting the template content, and storing the encrypted derived template into a predetermined database;

And determining a default export template through the database, decrypting the default export template, and assigning a value to the decrypted default export template according to the template rule.