CN110399420A - A kind of deriving method, electronic equipment and the medium of configurableization Excel format - Google Patents
A kind of deriving method, electronic equipment and the medium of configurableization Excel format Download PDFInfo
- Publication number
- CN110399420A CN110399420A CN201910697020.1A CN201910697020A CN110399420A CN 110399420 A CN110399420 A CN 110399420A CN 201910697020 A CN201910697020 A CN 201910697020A CN 110399420 A CN110399420 A CN 110399420A
- Authority
- CN
- China
- Prior art keywords
- field
- excel
- activity data
- template
- information configuration
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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
Abstract
The invention discloses a kind of deriving method of configurableization Excel format, include the following steps: to create raw data base list: custom field, associate field and activity, activity data is stored in database profession by the activity data that activity is formed with JSON format；Create information configuration template: creating information configuration table in the database, the sequence of at least one field and the field is configured in the information configuration table, according in information configuration table field and field be arranged in order as the column of Microsoft Excel template；Excel file export: selection needs derived Microsoft Excel template, extracts activity data from JSON form database according to the field of each column of Microsoft Excel template and forms Excel file to the cell assignment of every a line.User in this method can carry out customized, raising working efficiency and system experience before table exports to table.
Description
Technical field
The present invention relates to software technology field, especially a kind of deriving method, the electronic equipment of configurableization Excel format
And medium.
Background technique
With the arrival of digitization and information age, numerous network users leave bulk information on network, when need
When carrying out certain one kind research, the suitable information that meets can be grabbed from network to be analyzed, what these were crawled
Data much will form easy to read Word Excel format, but traditional Database Systems, derived system data
Substantially fixed template, user can be also to be limited in the range that it presets in advance with customized range, can not be real
According to the demand of each user come data needed for customized export.
It is to be difficult to change the sequence between every column data in traditional approach and in export, it can only be according to fixed
Format export, if need to change the sequence of each column data, can only modify the operation code on backstage, then is tested and provided
It completes.This process is a process that is time-consuming and laborious and being easily modified out bug for the operation personnel of backstage.For common
For user, can not changing format according to their own needs, limited to work bring also bigger；Especially needing greatly
When amount export, also needing the artificial format of adjustment one by one after export data every time is very inefficient work.
Summary of the invention
Present invention aims at above-mentioned background technique is directed to, a kind of configurableization Excel format is provided
Deriving method, electronic equipment and medium, user can table export before to table carry out it is customized, improve working efficiency and
System experience.
In order to achieve the above object, technical solution of the present invention has:
A kind of deriving method of configurableization Excel format, includes the following steps:
Raw data base list: custom field, associate field and activity is created, the activity data that activity is formed is with JSON
Activity data is stored in database profession by format；
It creates information configuration template: creating information configuration table in the database, configure at least one in the information configuration table
The sequence of a field and the field, according in information configuration table field and field be arranged in order as Microsoft Excel
The column of template；
Excel file export: selection needs derived Microsoft Excel template, according to the field of each column of Microsoft Excel template
Activity data is extracted from JSON form database, and Excel file is formed to the cell assignment of every a line.
Further, the creation raw data base list step includes the following steps:
Creation field manages table in the database, and customized field is stored into the field management table；
The mapping ruler table between field and activity data is created in the database；
Activity data table is created in the database, and activity data is stored in JSON format by activity data table according to contingency table
In.
Further, according to the corresponding { " word for storing identical quantity of the setting quantity of field in the activity data table
Section ": " activity data " } object.
Further, the sequential steps between the arrangement field include the following steps:
Each field is changed after the sequence of the field arrangement again according to the number of the sequentially assignment row or column sequence of arrangement
Carry out assignment.
Further, each field position in Excel table is distributed according to the number of the row or column sequence.
Further, the creation information configuration template step includes naming for Microsoft Excel template.
Further, the Excel file deriving step includes the following steps:
Selection needs derived Microsoft Excel template, detects the field and order of the field for including in the information configuration table；
Field is set to the gauge outfit of Excel by column according to order of the field；
From the corresponding activity data of calling field in the raw data base list to each traveling under the field respective column
Row assignment, assignment form Excel file export after the completion.
The present invention also provides a kind of electronic equipment comprising processor, storage medium and computer program, the calculating
Machine program is stored in the storage medium, and the computer program is executed by processor realization the method.
The present invention also provides a kind of computer readable storage mediums, are stored thereon with computer program, the computer journey
Sequence processor realizes the method when executing.
Deriving method, electronic equipment and the medium of a kind of configurableization Excel format of the invention, overcome the prior art
The problem of middle export table can only be exported according to preset field and format, when users use, system can not provide default
Field can pass through foundation of the customized field of user as collection activity data completely；Raw data base keep in field and
With field there are associated activity data, and the format that non-user directly exports, database is provided for subsequent customized row or column
Buffering and support；By creating information configuration template, use habit and hobby of user etc. can recorde, the primary template that is arranged is
It can repeatedly export, without being arranged repeatedly, save the time of user；It can be each with customized setting before the output of final template
The sequence of field meets a variety of demands of user so that row or column sequence when exporting final Excel formatted file be arranged.
Detailed description of the invention
Fig. 1 is a kind of flow chart of the deriving method of configurableization Excel format of the invention；
Fig. 2 is the structural block diagram of a kind of electronic equipment of the invention.
Specific embodiment
Deriving method, electronic equipment and the medium to a kind of configurableization Excel format of the invention is described with reference to the drawings
It is described in detail, protection scope of the present invention to be explained and illustrated.
Embodiment one
Fig. 1 is a kind of flow diagram of the deriving method of configurableization Excel format of the embodiment of the present invention 1, described to lead
Method includes the following steps: out
S1: creation raw data base list: custom field, associate field and activity, activity formed activity data with
Activity data is stored in database profession by JSON format；
It is general directly mapping ruler to be utilized to collect activity data from needs in the list deriving method of the prior art
Place export, without the raw data base list in this programme, therefore its export process is simpler, but also results in user
Customized degree reduces because the program code on backstage can only be modified when needing to change derived content every time, cannot by with
Family directly operates, and is not easy to operate for a user；Complexity is runed for network operator, is also needed after modification by surveying every time
Examination runs to prevent bug from influence program occur.In the present solution, when user is customized without changing the program code on backstage,
Original data form only plays the role of temporal data, first saves field and associated activity data wherein, purpose
It is that data support is provided when creating final Excel format for the later period.
S2: creation information configuration template: information configuration table is created in the database, is configured at least in the information configuration table
The sequence of one field and the field, according in information configuration table field and field be arranged in order as EXCEL table
The column of grid template；
In actual use, if wanting to create information configuration template, field is needed as starting standard, otherwise can be made
The case where being used at non-activity data.When there are two or when more than two fields, this programme also supports ranking function, Yong Huke
First these fields to sort as needed, the information configuration template for there was only field but non-activity data is formed, reduces sequence behaviour
The burden of program when making when field being avoided to be mapped with flood tide activity data, needs to handle when field and activity data are sorted jointly
Data volume it is excessive, cause operation slowly, occupancy be cached the problems such as more.Multiple information configuration templates can also be created for making
With, and since template is customized order of the field etc., user is arranged without repeating, and is needed in next time in use, directly using
This template reduces the duplication of labour.
The export of S3:Excel file: selection needs derived Microsoft Excel template, according to each column of Microsoft Excel template
Field extracts activity data from JSON form database and forms Excel file to the cell assignment of every a line.
After the information configuration template-setup of previous step is good, derived Excel form template needed for user's selection, at this time
Field is provided in information configuration template, it can will be related with field from the raw data base of JSON format by these fields
The activity data of connection is transferred, then corresponding assignment is filled to cell, forms complete Excel text needed for final user
Part.Wherein, field can only be as the gauge outfit of column, and can only change the sequence between column, and capable content follows the variation of column and becomes
Change.
Entire export process contains three big steps, the drawback in traditional deriving method is evaded, temporal data and later period
The method of calling improves the customized degree of process for entirely exporting data, and user with customized any field and can export number
According to, be not limited to developer restriction field.Therefore this method possesses bigger ductility and applicability, can be multiple types
User use.
Specifically, creation raw data base list step is implemented by the following steps:
Creation field manages table in the database, and customized field is stored into the field management table, word at this time
Segment management table is stored in backstage, will not be interfered to the operation of user；
The mapping ruler table between field and activity data is created in the database, this mapping ruler according to actual needs may be used
It is selection containing before " age " character with the mapping ruler being arranged between various patterns, such as field " age " and its activity data
Number afterwards；
Activity data table is created in the database, and activity data is stored in JSON format by activity data table according to contingency table
In, it is called when forming Excel file convenient for the later period.
As the preferred embodiment for realizing the sequential steps between the arrangement field comprising following steps:
Each field is according to the number of the sequentially assignment row or column sequence of arrangement for identifying its arrangement when exporting Excel file
Position and sequence, re-start assignment after changing the sequence of field arrangement, avoid in the appearance sequence in subsequent export
Not the case where not being inconsistent.Each field position in Excel table is distributed according to the number of the row or column sequence, this ensure that this
The sequence of the field in stage can be embodied when exporting Excel file.
It further include being named for Microsoft Excel template, just as the preferred embodiment of creation information configuration template step
In the later period using when required template can be quickly found according to the title of information configuration template.
As the preferred embodiment for realizing the Excel file deriving step comprising following steps:
Selection needs derived Microsoft Excel template, detects the field and order of the field for including in the information configuration table；
Field is set to the gauge outfit of Excel by column according to order of the field；
From the corresponding activity data of calling field in the raw data base list to each traveling under the field respective column
Row assignment, assignment form Excel file export after the completion.
Gauge outfit is set by the field, gauge outfit can be the first place of a certain row or column, meet the reading habit of user, just
It in understanding, fills with the activity data of each fields match to corresponding cell, to be formed using field as row name or column
Name, activity data are the Excel file of corresponding content and preservation.
Embodiment two
Fig. 2 is the structural schematic diagram of a kind of electronic equipment provided by Embodiment 2 of the present invention, and the computer program is located
It manages device and executes realization the method, which includes processor, memory, input unit and output device；Computer is set
The quantity of standby middle processor can be one or more, take a processor as an example in Fig. 2；Processor in electronic equipment is deposited
Reservoir, input unit and output device can be connected by bus or other modes, in Fig. 2 for being connected by bus.
Memory can be used for storing software program, computer executable program as a kind of computer readable storage medium
And module, such as the corresponding program instruction/module of deriving method of the configurableization Excel format in the embodiment of the present invention.Place
Device is managed by running software program, instruction and module stored in memory, thereby executing the various functions of electronic equipment
Using and data processing, that is, realize above-mentioned floor method of discrimination.
Memory can mainly include storing program area and storage data area, wherein storing program area can storage program area,
Application program needed at least one function；Storage data area, which can be stored, uses created data etc. according to terminal.In addition,
Memory may include high-speed random access memory, can also include nonvolatile memory, and a for example, at least disk is deposited
Memory device, flush memory device or other non-volatile solid state memory parts.In some instances, memory can further comprise phase
The memory remotely located for processor, these remote memories can pass through network connection to electronic equipment.Above-mentioned network
Example include but is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Input unit can be used for input-capable field etc., and output device may include that display screen etc. shows equipment.
Embodiment three
The present invention also provides the storage medium comprising computer executable instructions, the computer executable instructions are by counting
For executing the deriving method of configurableization Excel format when calculation machine processor executes, this method comprises:
Raw data base list: custom field, associate field and activity is created, the activity data that activity is formed is with JSON
Activity data is stored in database profession by format；
It creates information configuration template: creating information configuration table in the database, configure at least one in the information configuration table
The sequence of a field and the field, according in information configuration table field and field be arranged in order as Microsoft Excel
The column of template；
Excel file export: selection needs derived Microsoft Excel template, according to the field of each column of Microsoft Excel template
Activity data is extracted from JSON form database, and Excel file is formed to the cell assignment of every a line.
A kind of storage medium comprising computer executable instructions provided by the embodiment of the present invention, computer are executable
The method operation being not limited to the described above is instructed, it is described configurable that application provided by any embodiment of the invention can also be performed
Change the relevant operation in the deriving method of Excel format.
By the description above with respect to embodiment, it is apparent to those skilled in the art that, the present invention
It can be realized by software and required common hardware, naturally it is also possible to which by hardware realization, but in many cases, the former is more
Good embodiment.Based on this understanding, technical solution of the present invention substantially in other words contributes to the prior art
Part can be embodied in the form of software products, which can store in computer readable storage medium
In, floppy disk, read-only memory (Read-Only Memory, ROM), random access memory (Random such as computer
Access Memory, RAM), flash memory (FLASH), hard disk or CD etc., including some instructions use so that an electronic equipment
(can be mobile phone, personal computer, server or the network equipment etc.) executes method described in each embodiment of the present invention.
According to the disclosure and teachings of the above specification, those skilled in the art in the invention can also be to above-mentioned embodiment party
Formula is changed and is modified.Therefore, the invention is not limited to the specific embodiments disclosed and described above, to of the invention
Some modifications and changes should also be as falling into the scope of the claims of the present invention.In addition, although being used in this specification
Some specific terms, these terms are merely for convenience of description, does not limit the present invention in any way.
Claims (9)
1. a kind of deriving method of configurableization Excel format, which comprises the steps of:
Raw data base list: custom field, associate field and activity is created, the activity data that activity is formed is with JSON format
Activity data is stored in database profession；
It creates information configuration template: creating information configuration table in the database, at least one institute is configured in the information configuration table
The sequence for stating field and the field, according in information configuration table field and field be arranged in order as Microsoft Excel template
Column；
Excel file export: selection needs derived Microsoft Excel template, according to the field of each column of Microsoft Excel template from
Activity data is extracted in the database of JSON format, and Excel file is formed to the cell assignment of every a line.
2. deriving method according to claim 1, which is characterized in that the creation raw data base list step includes such as
Lower step:
Creation field manages table in the database, and customized field is stored into the field management table；
The contingency table between field and activity is created in the database；
Activity data table is created in the database, and activity data is stored in activity data table with JSON format according to contingency table.
3. deriving method according to claim 2, which is characterized in that according to the setting number of field in the activity data table
Corresponding { " field ": " the activity data " } object for storing identical quantity of amount.
4. deriving method according to claim 3, which is characterized in that the sequential steps between the arrangement field include such as
Lower step:
Each field re-starts after changing the sequence of the field arrangement according to the number of the sequentially assignment row or column sequence of arrangement
Assignment.
5. deriving method according to claim 4, which is characterized in that distribute each word according to the number of the row or column sequence
Section position in Excel table.
6. deriving method according to claim 1, which is characterized in that the creation information configuration template step further include as
Lower step: for the name of Microsoft Excel template.
7. deriving method according to claim 1, which is characterized in that the Excel file deriving step includes following step
It is rapid:
Selection needs derived Microsoft Excel template, detects the field and order of the field for including in the information configuration table；
Field is set to the gauge outfit of Excel by column according to order of the field；
Each row under the field respective column is assigned from the corresponding activity data of calling field in the raw data base list
Value, assignment form Excel file export after the completion.
8. a kind of electronic equipment comprising processor, storage medium and computer program, the computer program are stored in institute
It states in storage medium, which is characterized in that the computer program, which is executed by processor, to be realized described in any one of claim 1 to 7
Method.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that at the computer program
It manages when device executes and realizes the described in any item methods of claim 1 to 7.
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 true CN110399420A (en) | 2019-11-01 |
| CN110399420B 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) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110826297A (en) * | 2019-11-05 | 2020-02-21 | 北京锐安科技有限公司 | Data export method, device, equipment and storage medium |
| CN111125221A (en) * | 2019-12-19 | 2020-05-08 | 上海三稻智能科技有限公司 | Excel format-based data extraction system and configuration method |
| CN111177243A (en) * | 2019-12-24 | 2020-05-19 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111291302A (en) * | 2020-03-20 | 2020-06-16 | 成都药王科技股份有限公司 | 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 |
| CN112507672A (en) * | 2020-12-23 | 2021-03-16 | 安徽航天信息有限公司 | Payroll data acquisition method, device, system and storage medium |
| CN113011145A (en) * | 2021-03-16 | 2021-06-22 | 深圳市麦谷科技有限公司 | Data export method and device, terminal equipment and storage medium |
| CN113010588A (en) * | 2019-12-20 | 2021-06-22 | 北京国基科技股份有限公司 | Data table processing method |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN113268967A (en) * | 2020-10-13 | 2021-08-17 | 上海右云信息技术有限公司 | Method and equipment for processing data information |
| CN113807068A (en) * | 2021-09-30 | 2021-12-17 | 杭州分叉智能科技有限公司 | Excel automation method based on RPA |
| CN114979120A (en) * | 2022-05-24 | 2022-08-30 | 中国平安财产保险股份有限公司 | Data uploading method, device, equipment and storage medium |
Citations (11)
| 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 |
| US20070192679A1 (en) * | 2006-02-13 | 2007-08-16 | 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 |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| US20150039651A1 (en) * | 2013-07-31 | 2015-02-05 | Splunk Inc. | Templates for defining fields in machine data |
| 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 |
-
2019
- 2019-07-30 CN CN201910697020.1A patent/CN110399420B/en active Active
Patent Citations (11)
| 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 |
| US20070192679A1 (en) * | 2006-02-13 | 2007-08-16 | 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 |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| US20150039651A1 (en) * | 2013-07-31 | 2015-02-05 | Splunk Inc. | Templates for defining fields in machine data |
| 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组件的用户自定义报表设计", 《兵工自动化》 * |
| 蒋利 等: "基于XLS模板的城市地下管线成果报表自动生成方法研究", 《软件导刊》 * |
Cited By (20)
| 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 |
| CN111125221A (en) * | 2019-12-19 | 2020-05-08 | 上海三稻智能科技有限公司 | Excel format-based data extraction system and configuration method |
| CN113010588B (en) * | 2019-12-20 | 2023-07-04 | 北京国基科技股份有限公司 | Data form processing method |
| CN113010588A (en) * | 2019-12-20 | 2021-06-22 | 北京国基科技股份有限公司 | Data table processing method |
| CN111177243A (en) * | 2019-12-24 | 2020-05-19 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111177243B (en) * | 2019-12-24 | 2023-11-14 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111291302A (en) * | 2020-03-20 | 2020-06-16 | 成都药王科技股份有限公司 | 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 |
| CN113268967A (en) * | 2020-10-13 | 2021-08-17 | 上海右云信息技术有限公司 | Method and equipment for processing data information |
| CN113268967B (en) * | 2020-10-13 | 2024-04-09 | 上海右云信息技术有限公司 | Method and equipment for processing data information |
| CN112507672A (en) * | 2020-12-23 | 2021-03-16 | 安徽航天信息有限公司 | Payroll data acquisition method, device, 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 |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN113807068A (en) * | 2021-09-30 | 2021-12-17 | 杭州分叉智能科技有限公司 | Excel automation method based on RPA |
| CN113807068B (en) * | 2021-09-30 | 2024-01-26 | 杭州分叉智能科技有限公司 | Excel automation method based on RPA |
| CN114979120A (en) * | 2022-05-24 | 2022-08-30 | 中国平安财产保险股份有限公司 | Data uploading method, device, equipment and storage medium |
| CN114979120B (en) * | 2022-05-24 | 2023-10-13 | 中国平安财产保险股份有限公司 | Data uploading method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110399420B (en) | 2022-11-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110399420A (en) | A kind of deriving method, electronic equipment and the medium of configurableization Excel format | |
| CN106067080B (en) | Configurable workflow capabilities are provided | |
| CN105094707B (en) | A kind of data storage, read method and device | |
| CN110377851A (en) | Implementation method, device and the computer equipment of multistage linking combobox | |
| CN101446971B (en) | Method for building content management system and device thereof | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN106843844B (en) | Display device of custom view | |
| CN110045894A (en) | System and method for dialog box customization | |
| CN107302573A (en) | A kind of information-pushing method, device, electronic equipment and storage medium | |
| CN109471676A (en) | Parameter configuration processing method and device | |
| CN109800375A (en) | Information integrates dissemination method, device, computer equipment and storage medium | |
| CN104346435A (en) | Methods, apparatus and systems for data sorting, visualisation and related applications | |
| CN107632827A (en) | The generation method and device of the installation kit of application | |
| CN110728123A (en) | Report generation method, system and related equipment | |
| WO2014137258A1 (en) | Selection of data storage settings for an application | |
| CN115358204A (en) | Report generation method and device, electronic equipment and storage medium | |
| CN106250110A (en) | Set up the method and device of model | |
| CN105933154A (en) | Management method of cloud calculation resources | |
| CN107153705A (en) | The application program sort method and server of a kind of web browser | |
| CN115329728B (en) | Work data low-acquisition high-multiplexing collaborative office report system and method | |
| CN103793519A (en) | Automatic tool supporting exportation of mass data | |
| CN108133088B (en) | Self-adaptive creation method and system of CAD (computer-aided design) model | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN112699032B (en) | Method for realizing vddbench performance test result analysis based on Excel | |
| CN109558403A (en) | Data aggregation method and device, computer installation and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| 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 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right |