CN110399420B - Export method, electronic equipment and medium of configurable Excel format - Google Patents
Export method, electronic equipment and medium of configurable Excel format Download PDFInfo
- Publication number
- CN110399420B CN110399420B CN201910697020.1A CN201910697020A CN110399420B CN 110399420 B CN110399420 B CN 110399420B CN 201910697020 A CN201910697020 A CN 201910697020A CN 110399420 B CN110399420 B CN 110399420B
- Authority
- CN
- China
- Prior art keywords
- field
- excel
- database
- creating
- 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
- 238000000034 method Methods 0.000 title claims abstract description 42
- 230000000694 effects Effects 0.000 claims abstract description 42
- 238000004590 computer program Methods 0.000 claims description 9
- 230000015654 memory Effects 0.000 description 12
- 238000007726 management method Methods 0.000 description 5
- 238000013507 mapping Methods 0.000 description 5
- 238000012163 sequencing technique Methods 0.000 description 5
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000003139 buffering effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for exporting a configurable Excel format, which comprises the following steps: creating an original database form: the user-defined field is used for associating the field with the activity, and the activity data formed by the activity is stored in a database in a JSON format; creating an information configuration template: creating an information configuration table in a database, configuring at least one field and the sequence of the field in the information configuration table, and configuring the field and the sequence of the field in the information configuration table into a column of an EXCEL form template; exporting the Excel file: and selecting an EXCEL form template to be exported, extracting active data from the JSON format database according to fields of each column of the EXCEL form template, and assigning values to cells of each row to form an EXCEL file. The user in the method can customize the table before the table is exported, so that the working efficiency and the system experience are improved.
Description
Technical Field
The invention relates to the technical field of software, in particular to a method, electronic equipment and medium for exporting a configurable Excel format.
Background
With the advent of the data and information age, a great deal of information is left on the network by a plurality of network users, when a certain type of research is needed, proper information which is in line with the network can be captured from the network for analysis, a great deal of captured data can form a Word or Excel format which is convenient to read, but in the traditional database system, the exported system data is basically a fixed template, the user-defined range is also limited in the preset range, and the needed data cannot be freely derived according to the requirements of each user.
In addition, when exporting, the traditional mode is difficult to change the sequencing of each line of data, only exporting can be carried out according to a fixed format, and if the sequencing of each line of data needs to be changed, only the running code of the background can be modified, and then testing and issuing are carried out. This process is a time consuming and laborious process for the back-office operator to modify the bug easily. For a common user, the format cannot be changed according to the requirement of the user, and the limitation on the work is large; especially when a large number of exports are needed, it is very inefficient to manually adjust the format one by one after each export of data.
Disclosure of Invention
The invention aims to provide the export method, the electronic equipment and the medium of the configurable Excel format aiming at the problems in the background technology, so that a user can customize a form before exporting the form, and the working efficiency and the system experience are improved.
In order to achieve the purpose, the technical scheme of the invention is as follows:
a export method of a configurable Excel format comprises the following steps:
creating a raw database form: the user-defined field is used for associating the field with the activity, and the activity data formed by the activity is stored in a database in a JSON format;
creating an information configuration template: creating an information configuration table in a database, configuring at least one field and the sequence of the field in the information configuration table, and configuring the field and the sequence of the field in the information configuration table into a column of an EXCEL form template;
exporting the Excel file: and selecting an EXCEL form template to be exported, extracting active data from the JSON format database according to fields of each column of the EXCEL form template, and assigning the cells of each row to form an EXCEL file.
Further, the step of creating the original database table comprises the steps of:
creating a field management table in a database, and storing a self-defined field into the field management table;
creating a mapping rule table between the fields and the activity data in the database;
and creating an activity data table in the database, and storing the activity data into the activity data table in a JSON format according to the association table.
Furthermore, the activity data table correspondingly stores the same number of { "fields": activity data "} objects according to the set number of the fields.
Further, the step of arranging the sequence between the fields comprises the steps of:
and each field is assigned according to the serial number of the arranged sequence assignment line or sequence, and the assignment is carried out again after the sequence of the field arrangement is changed.
Further, the position of each field in the Excel table is allocated according to the serial number of the row or the column.
Further, the creating information configuration template step includes naming an EXCEL form template.
Further, the Excel file exporting method comprises the following steps:
selecting an EXCEL form template to be exported, and detecting fields and field sequences contained in the information configuration table;
setting fields in a table header of Excel column by column according to the field sequence;
and calling the activity data corresponding to the field from the original database form to assign values to each row of the field corresponding to the column, and forming an Excel file to be exported after the assignment is completed.
The invention also provides an electronic device comprising a processor, a storage medium and a computer program, the computer program being stored in the storage medium and being executed by the processor for implementing the method.
The invention also provides a computer-readable storage medium, on which a computer program is stored, which when executed by a processor implements the method.
The export method, the electronic equipment and the medium of the configurable Excel format overcome the problem that the export form in the prior art can only be exported according to the preset field and format, and when the export form is used by a user, the system can not provide the preset field and can completely use the field customized by the user as the basis for collecting the activity data; the original database temporarily stores the field and the activity data associated with the field, instead of the format directly output by a user, and provides database buffering and support for the subsequent self-defined rows or columns; by creating the information configuration template, the using habits, hobbies and the like of the user can be recorded, the template can be exported for many times by setting once, repeated setting is not needed, and the time of the user is saved; before the final template is output, the sequence of each field can be set in a self-defined mode, so that the row or the sequence when the final Excel format file is output is set, and various requirements of a user are met.
Drawings
FIG. 1 is a flow chart of a configurable export method of Excel format according to the present invention;
fig. 2 is a block diagram of an electronic device according to the present invention.
Detailed Description
The method, electronic device and medium for exporting the configurable Excel format according to the present invention are described in detail with reference to the accompanying drawings for explaining and illustrating the scope of the present invention.
Example one
Fig. 1 is a flowchart of an export method of a configurable Excel format according to embodiment 1 of the present invention, where the export method includes the following steps:
s1, creating an original database form: the user-defined field is used for associating the field with the activity, and the activity data formed by the activity is stored in a database in a JSON format;
in the form export method in the prior art, the activity data is generally exported from the place needing to be collected by directly utilizing the mapping rule, and an original database form in the scheme is not available, so the export process is simpler, but the user-defined degree is reduced, because the exported content is required to be changed each time, only program codes in a background can be modified, the direct operation by the user cannot be realized, and the operation is inconvenient for the user; the operation is complex for an operator, and after each modification, a test is also needed to prevent the bug from affecting the program operation. In the scheme, when a user defines the Excel format, a program code of a background does not need to be changed, an original data form only plays a role of temporarily storing data, and the fields and the associated activity data are stored in the original data form, so that data support is provided for later-stage creation of a final Excel format.
S2, creating an information configuration template: creating an information configuration table in a database, configuring at least one field and the sequence of the field in the information configuration table, and configuring the field and the sequence of the field in the information configuration table into a column of an EXCEL form template;
in the actual use process, if an information configuration template is to be created, a field is required to be used as a starting standard, otherwise, the situation that no active data is available is caused. When two or more fields exist, the scheme also supports a sequencing function, a user can sequence the fields according to needs to form an information configuration template only with the fields but without active data, the burden of a program during sequencing operation is reduced, and the problems of slow operation, excessive occupied cache and the like caused by overlarge data volume to be processed during the common sequencing of the fields and the active data when the fields are mapped with huge active data are avoided. And because the templates are self-defined field sequences and the like, the user does not need to repeatedly set the templates, and the templates can be directly used when the templates are required to be used next time, so that the repeated labor is reduced.
And S3, exporting the Excel file: and selecting an EXCEL form template to be exported, extracting active data from the JSON format database according to fields of each column of the EXCEL form template, and assigning the cells of each row to form an EXCEL file.
After the information configuration template in the last step is set, the user selects the Excel form template required to be derived, fields are provided in the information configuration template, the active data relevant to the fields can be called from an original database in a JSON format through the fields, and then corresponding assignment is filled into cells to form a final complete Excel file required by the user. Wherein, the field can only be used as the head of the column, and only the sequence between the columns can be changed, and the content of the row changes along with the change of the columns.
The whole exporting process comprises three steps, the defects in the traditional exporting method are avoided, the self-defining degree of the whole data exporting process is improved by the method of data temporary storage and later calling, and a user can self-define any field and export data and is not limited to the field defined by a developer. Therefore, the method has greater ductility and applicability and can be used by various types of users.
Specifically, the step of creating the original database form is implemented by the steps of:
a field management table is established in a database, a self-defined field is stored in the field management table, and the field management table is stored in a background at the moment, so that the operation of a user is not interfered;
a mapping rule table between the field and the activity data is established in a database, the mapping rule can be set into various types according to actual needs, for example, the mapping rule between the field 'age' and the activity data thereof is to select numbers containing characters of the 'age';
and creating an activity data table in the database, and storing the activity data into the activity data table in a JSON format according to the association table, so that the activity data can be called conveniently when an Excel file is formed at a later stage.
As a preferred scheme for realizing the sequence steps among the arrangement fields, the method comprises the following steps:
and each field is assigned with the serial number of the row or the sequence according to the arranged sequence to identify the arranged position and the arranged sequence of the Excel file when the Excel file is exported, and the fields are assigned again after the arranged sequence of the fields is changed, so that the situation that the sequence is not consistent when the Excel file is exported subsequently is avoided. And allocating the position of each field in the Excel table according to the serial number of the row or the sequence, so that the sequence of the fields at the stage can be embodied when the Excel file is exported.
As a preferred embodiment of the step of creating the information configuration template, the method also comprises naming the EXCEL form template, so that the required template can be quickly found according to the name of the information configuration template when the method is used at a later time.
As a preferred scheme for realizing the Excel file exporting step, the Excel file exporting method comprises the following steps:
selecting an EXCEL form template to be exported, and detecting fields and field sequences contained in the information configuration table;
setting the fields in the header of the Excel column by column according to the field sequence;
and calling the activity data corresponding to the field from the original database form to assign values to each row corresponding to the field, and forming an Excel file export after the assignment is completed.
And the fields are set as a header, the header can be the first of a certain row or column, the reading habit of a user is met, the data is convenient to understand, and the activity data matched with each field is filled into the corresponding cell, so that an Excel file with the fields as row names or column names and the activity data as corresponding contents is formed and stored.
Example two
Fig. 2 is a schematic structural diagram of an electronic device according to a second embodiment of the present invention, where the computer program is executed by a processor to implement the method, and the electronic device includes a processor, a memory, an input device, and an output device; the number of processors in the computer device may be one or more, and one processor is taken as an example in fig. 2; the processor, memory, input devices and output devices in the electronic apparatus may be connected by a bus or other means, and fig. 2 illustrates the connection by a bus as an example.
The memory is used as a computer readable storage medium, and can be used for storing software programs, computer executable programs, and modules, such as program instructions/modules corresponding to the export method of the configurable Excel format in the embodiment of the present invention. The processor executes various functional applications and data processing of the electronic device by running software programs, instructions and modules stored in the memory, that is, the above-described floor determination method is realized.
The memory can mainly comprise a program storage area and a data storage area, wherein the program storage area can store an operating system and an application program required by at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the memory may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, the memory may further include memory located remotely from the processor, and these remote memories may be connected to the electronic device through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device may be used to receive input fields and the like, and the output device may include a display device such as a display screen.
EXAMPLE III
The present invention also provides a storage medium containing computer-executable instructions which, when executed by a computer processor, are operable to perform a method of exporting a configurable Excel format, the method comprising:
creating a raw database form: the user-defined field is used for associating the field with the activity, and the activity data formed by the activity is stored in a database in a JSON format;
creating an information configuration template: creating an information configuration table in a database, configuring at least one field and the sequence of the field in the information configuration table, and configuring the fields and the sequence of the fields in the information configuration table into columns of the EXCEL form template;
exporting the Excel file: and selecting an EXCEL form template to be exported, extracting active data from the JSON format database according to fields of each column of the EXCEL form template, and assigning values to cells of each row to form an EXCEL file.
The storage medium containing the computer-executable instructions provided in the embodiments of the present invention is not limited to the method operations described above, and may also perform related operations in the export method applying the configurable Excel format provided in any embodiment of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention or portions thereof contributing to the prior art may be embodied in the form of a software product, which may be stored in a computer readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling an electronic device (which may be a mobile phone, a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
Variations and modifications to the above-described embodiments may occur to those skilled in the art, which fall within the scope and spirit of the above description. Therefore, the present invention is not limited to the specific embodiments disclosed and described above, and modifications and variations of the present invention are also intended to fall within the scope of the appended claims. Furthermore, although specific terms are employed herein, they are used in a generic and descriptive sense only and not for purposes of limitation.
Claims (5)
1. A exporting method of a configurable Excel format is characterized by comprising the following steps:
creating an original database form: the user-defined field is used for associating the field with the activity, and the activity data formed by the activity is stored in a database in a JSON format; creating an information configuration template: creating an information configuration table in a database, configuring at least one field and the sequence of the field in the information configuration table, and configuring the field and the sequence of the field in the information configuration table into a column of an EXCEL form template;
exporting the Excel file: selecting an EXCEL form template to be exported, extracting active data from a database in a JSON format according to fields of each column of the EXCEL form template, and assigning the cells of each row to form an EXCEL file;
the single step of creating the original database table comprises the following steps:
creating a field management table in a database, and storing a self-defined field into the field management table;
creating an association table between the fields and the activities in the database;
creating an activity data table in a database, and storing activity data into the activity data table in a JSON format according to an association table;
the activity data table correspondingly stores the same number of { "fields": activity data "} objects according to the set number of the fields;
the sequence step between the permutation fields includes the steps of:
assigning the row or column number of each field according to the arranged sequence, and re-assigning after changing the sequence of the field arrangement;
the Excel file exporting step comprises the following steps:
selecting an EXCEL form template to be exported, and detecting fields and field sequences contained in the information configuration table;
setting the fields in the header of the Excel column by column according to the field sequence;
and calling the activity data corresponding to the field from the original database form to assign values to each row of the field corresponding to the column, and forming an Excel file to be exported after the assignment is completed.
2. The exporting method according to claim 1, wherein each field is assigned a position in an Excel table according to the number of the row or the column.
3. The exporting method according to claim 1, wherein the step of creating the information configuration template further comprises the steps of: name EXCEL form template.
4. An electronic device comprising a processor, a storage medium, and a computer program, the computer program being stored in the storage medium, wherein the computer program is executed by the processor to implement the method of any one of claims 1 to 3.
5. A computer-readable storage medium, on which a computer program is stored, characterized in that a computer program processor, when executing it, implements the method of any of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910697020.1A CN110399420B (en) | 2019-07-30 | 2019-07-30 | Export method, electronic equipment and medium of configurable Excel format |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910697020.1A CN110399420B (en) | 2019-07-30 | 2019-07-30 | Export method, electronic equipment and medium of configurable Excel format |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110399420A CN110399420A (en) | 2019-11-01 |
| CN110399420B true CN110399420B (en) | 2022-11-22 |
Family
ID=68326656
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910697020.1A Active CN110399420B (en) | 2019-07-30 | 2019-07-30 | Export method, electronic equipment and medium of configurable Excel format |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110399420B (en) |
Families Citing this family (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110826297A (en) * | 2019-11-05 | 2020-02-21 | 北京锐安科技有限公司 | Data export method, device, equipment and storage medium |
| CN111125221B (en) * | 2019-12-19 | 2023-05-05 | 上海三稻智能科技有限公司 | Excel format-based data extraction system and configuration method |
| CN113010588B (en) * | 2019-12-20 | 2023-07-04 | 北京国基科技股份有限公司 | Data form processing method |
| CN111177243B (en) * | 2019-12-24 | 2023-11-14 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111291302B (en) * | 2020-03-20 | 2023-06-27 | 成都药王科技股份有限公司 | Method for quickly creating active page |
| CN111476016A (en) * | 2020-04-15 | 2020-07-31 | 北京思特奇信息技术股份有限公司 | Template configuration method for package tariff in telecommunication industry |
| CN111813849A (en) * | 2020-09-14 | 2020-10-23 | 杭州数梦工场科技有限公司 | Data extraction method, device and equipment and storage medium |
| CN113268967B (en) * | 2020-10-13 | 2024-04-09 | 上海右云信息技术有限公司 | Method and equipment for processing data information |
| CN112507672B (en) * | 2020-12-23 | 2024-07-05 | 安徽航天信息有限公司 | Payroll data acquisition method, device and system and storage medium |
| CN113011145A (en) * | 2021-03-16 | 2021-06-22 | 深圳市麦谷科技有限公司 | Data export method and device, terminal equipment and storage medium |
| CN113032633B (en) * | 2021-04-15 | 2022-03-08 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN113778820A (en) * | 2021-07-28 | 2021-12-10 | 赤子城网络技术（北京）有限公司 | Application program data export method, device, electronic device and storage medium |
| CN113807068B (en) * | 2021-09-30 | 2024-01-26 | 杭州分叉智能科技有限公司 | Excel automation method based on RPA |
| CN114691604B (en) * | 2022-02-25 | 2024-05-14 | 智己汽车科技有限公司 | DBC signal derived start bit format conversion method and system |
| CN114756511A (en) * | 2022-03-07 | 2022-07-15 | 中银金融科技有限公司 | Method and device for exporting data in database into text file |
| CN114979120B (en) * | 2022-05-24 | 2023-10-13 | 中国平安财产保险股份有限公司 | Data uploading method, device, equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2004003768A1 (en) * | 2002-07-01 | 2004-01-08 | Rovenet, Inc. | System and method for preparing and using automated forms |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN106294389A (en) * | 2015-05-20 | 2017-01-04 | 上海纳鑫信息科技有限公司 | A kind of method and system realizing customizing form |
| CN106933835A (en) * | 2015-12-29 | 2017-07-07 | 航天信息软件技术有限公司 | The data lead-in method and system of a kind of compatibility parsing Excel file |
| CN107656914A (en) * | 2017-10-16 | 2018-02-02 | 厦门海迈科技股份有限公司 | Form generation method, device, terminal device and the storage medium of configurableization |
| CN109815276A (en) * | 2018-12-14 | 2019-05-28 | 中国平安财产保险股份有限公司 | Method, apparatus, computer equipment and the storage medium of declaration form extraction data |
| CN109948132A (en) * | 2019-03-18 | 2019-06-28 | 航天云网科技发展有限责任公司 | A kind of data of configuration template make a report on method and system |
| CN110019970A (en) * | 2018-06-15 | 2019-07-16 | 中国平安人寿保险股份有限公司 | Inventory downloads template creation method, device, terminal and readable storage medium storing program for executing |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8037402B2 (en) * | 2006-02-13 | 2011-10-11 | Oracle International Corporation | Method and system for flexible creation and publication of forms |
| US20120131445A1 (en) * | 2010-11-23 | 2012-05-24 | International Business Machines Corporation | Template-based content creation |
| US9922102B2 (en) * | 2013-07-31 | 2018-03-20 | Splunk Inc. | Templates for defining fields in machine data |
-
2019
- 2019-07-30 CN CN201910697020.1A patent/CN110399420B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2004003768A1 (en) * | 2002-07-01 | 2004-01-08 | Rovenet, Inc. | System and method for preparing and using automated forms |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN106294389A (en) * | 2015-05-20 | 2017-01-04 | 上海纳鑫信息科技有限公司 | A kind of method and system realizing customizing form |
| CN106933835A (en) * | 2015-12-29 | 2017-07-07 | 航天信息软件技术有限公司 | The data lead-in method and system of a kind of compatibility parsing Excel file |
| CN107656914A (en) * | 2017-10-16 | 2018-02-02 | 厦门海迈科技股份有限公司 | Form generation method, device, terminal device and the storage medium of configurableization |
| CN110019970A (en) * | 2018-06-15 | 2019-07-16 | 中国平安人寿保险股份有限公司 | Inventory downloads template creation method, device, terminal and readable storage medium storing program for executing |
| CN109815276A (en) * | 2018-12-14 | 2019-05-28 | 中国平安财产保险股份有限公司 | Method, apparatus, computer equipment and the storage medium of declaration form extraction data |
| CN109948132A (en) * | 2019-03-18 | 2019-06-28 | 航天云网科技发展有限责任公司 | A kind of data of configuration template make a report on method and system |
Non-Patent Citations (2)
| Title |
|---|
| 基于CELL组件的用户自定义报表设计;张蓉;《兵工自动化》;20050430;第24卷(第04期);第106-107、112页 * |
| 基于XLS模板的城市地下管线成果报表自动生成方法研究;蒋利 等;《软件导刊》;20171215;第16卷(第12期);第9-11页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110399420A (en) | 2019-11-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110399420B (en) | Export method, electronic equipment and medium of configurable Excel format | |
| CN111176976B (en) | Test data generation method and device, storage medium and electronic device | |
| CN108347532B (en) | Function access method, device, terminal equipment and storage medium | |
| EP3252592A1 (en) | Method and device for storing and reading data | |
| CN108875077B (en) | Column storage method and device of database, server and storage medium | |
| CN107396199B (en) | Barrage method for exhibiting data and device, computer readable storage medium | |
| CN103164114A (en) | Method and device of classifying icons of terminal operation interface | |
| CN109582936A (en) | The method and apparatus for configuring report messages | |
| CN111800471A (en) | Recommended page display method and device and electronic equipment | |
| CN115438087A (en) | Data query method and device based on cache library, storage medium and equipment | |
| CN111047434A (en) | Operation record generation method and device, computer equipment and storage medium | |
| CN113407254B (en) | Form generation method and device, electronic equipment and storage medium | |
| CN110457016B (en) | Data visualization processing method and device, computer equipment and storage medium | |
| CN112162951A (en) | Information retrieval method, server and storage medium | |
| CN113033221A (en) | Smart card issuing method, computer device and computer readable storage medium | |
| CN115935917A (en) | Data processing method, device and equipment for visual chart and storage medium | |
| CN106897257A (en) | The conversion method and device of a kind of ASCII character and character string based on LINUX platforms | |
| CN109144624B (en) | Method, storage medium, device and system for displaying unequal height lists in IOS | |
| CN109902275B (en) | Method for customizing form and electronic equipment | |
| CN111026739B (en) | Batch data cleaning method and device, computer equipment and storage medium | |
| CN114662689A (en) | Pruning method, device, equipment and medium for neural network | |
| CN108762637A (en) | Control method, apparatus and system | |
| CN108874994A (en) | A kind of piecemeal reads the method, apparatus and computer storage medium of data | |
| CN115794245A (en) | Data loading method and device, electronic equipment and storage medium | |
| CN108052379B (en) | Multi-task operation method and device of SPI-NAND |
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 | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A configurable Excel format export method, electronic devices, and media Effective date of registration: 20230901 Granted publication date: 20221122 Pledgee: Bank of China Limited by Share Ltd. Guangzhou Tianhe branch Pledgor: Guangzhou Jixin Network Technology Development Co.,Ltd. Registration number: Y2023980054987 |
|
| PC01 | Cancellation of the registration of the contract for pledge of patent right | ||
| PC01 | Cancellation of the registration of the contract for pledge of patent right |
Granted publication date: 20221122 Pledgee: Bank of China Limited by Share Ltd. Guangzhou Tianhe branch Pledgor: Guangzhou Jixin Network Technology Development Co.,Ltd. Registration number: Y2023980054987 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A configurable Excel format export method, electronic devices, and media Granted publication date: 20221122 Pledgee: Bank of China Limited by Share Ltd. Guangzhou Tianhe branch Pledgor: Guangzhou Jixin Network Technology Development Co.,Ltd. Registration number: Y2024980040255 |