CN108280056A - A kind of Excel file analytic method - Google Patents
A kind of Excel file analytic method Download PDFInfo
- Publication number
- CN108280056A CN108280056A CN201711436088.1A CN201711436088A CN108280056A CN 108280056 A CN108280056 A CN 108280056A CN 201711436088 A CN201711436088 A CN 201711436088A CN 108280056 A CN108280056 A CN 108280056A
- Authority
- CN
- China
- Prior art keywords
- file
- excel file
- fileinfo
- heading message
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/205—Parsing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/258—Heading extraction; Automatic titling; Numbering
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of Excel file analytic method, including：S1 extracts fileinfo, heading message and the content information of target Excel file using Apache POI respectively；Wherein, fileinfo includes at least the unique mark and file name of target Excel file；Heading message includes at least the corresponding row name of unique mark, each column and the corresponding line number of each row name of target Excel file；Content information includes the unique mark of target Excel file, the cell data of each row name respective column and the corresponding line number of each cell data；Fileinfo, heading message and content information are corresponded to typing file information table, heading message table and table of contents information by S2.Excel file is split as three parts and parsed, effectively analyzed Excel file, reduce time cost, improve batch analyzing efficiency by a kind of Excel file analytic method provided by the invention.
Description
Technical field
The present invention relates to data analytic technique field more particularly to a kind of Excel file analytic methods.
Background technology
Apache POI are provided using cross-platform Java API, the Apache POI of written in Java freely to increase income
The function that API reads and writes to Microsoft Office format archives to Java formulas, especially Java Tentative Study of Achievement of Manipulation on Excel solution party
Case.Currently, carrying out the main stream approach that parsing has become Excel parsings to Excel file using Apache POI.
However, the batch with more and more Excel files in project imports, for the workload of single Excel processing
Also increasing.Excel file is all based on greatly currently based on the Excel analytic methods of Apache POI integrally to carry out, largely
Analysis program takes time and effort, and challenge is brought to the parsing of batch Excel file.
Invention content
The present invention is to solve the problems, such as that Excel file analytic method existing in the prior art is time-consuming and laborious, provides one
Kind Excel file analytic method.
On the one hand, the present invention proposes a kind of Excel file analytic method, including：S1 is extracted respectively using ApachePOI
Fileinfo, heading message and the content information of target Excel file；Wherein, the fileinfo includes at least the target
The unique mark and file name of Excel file；The heading message includes at least unique mark of the target Excel file
Knowledge, the corresponding row name of each column and the corresponding line number of each row name；The content information includes the target Excel file
Unique mark, the cell data of each row name respective column and the corresponding line number of each cell data；S2, by institute
Fileinfo, heading message and content information is stated to correspond in typing file information table, heading message table and table of contents information.
Preferably, the fileinfo further includes the file type, file size and file position of the target Excel file
At least one of set.
Preferably, the acquisition methods of the corresponding row name of either rank include：Sequence, which is read in the target Excel file, includes
The first row cell of data, and it is described any according to preset naming rule and the setting of the row number of any cell
The row name of cell column.
Preferably, the file type includes at least：And .xls .xlsx.
Preferably, further include：S3, using the file information table, heading message table and table of contents information to the target
Excel file is analyzed.
On the other hand, the present invention proposes a kind of Excel file resolver, including：Information extraction modules, for applying
ApachePOI extracts fileinfo, heading message and the content information of target Excel file respectively；Wherein, the fileinfo
Including at least the unique mark and file name of the target Excel file；The heading message includes at least the target
The corresponding row name of unique mark, each column and the corresponding line number of each row name of Excel file；The content information includes institute
State the unique mark of target Excel file, the cell data of each row name respective column and each cell data
Corresponding line number；Data input module, for the fileinfo, heading message and content information to be corresponded to typing fileinfo
In table, heading message table and table of contents information.
Preferably, the fileinfo further includes the file type, file size and file position of the target Excel file
At least one of set.
In another aspect, the present invention proposes a kind of Excel file analyzing device, including：At least one processor；And with institute
At least one processor of processor communication connection is stated, wherein：The memory is stored with the journey that can be executed by the processor
Sequence instructs, and the processor calls described program instruction to be able to carry out foregoing method.
Another aspect, the present invention propose that a kind of non-transient computer readable storage medium, the non-transient computer are readable
Storage medium stores computer instruction, and the computer instruction makes the computer execute foregoing method.
Target Excel file is split as three parts and solved by a kind of Excel file analytic method provided by the invention
Analysis, on the basis of having carried out effective analysis to Excel file, reduces time cost, improves batch analyzing efficiency.
Description of the drawings
Fig. 1 is a kind of flow diagram of Excel file analytic method of the specific embodiment of the invention；
Fig. 2 is a kind of structural schematic diagram of Excel file resolver of the specific embodiment of the invention；
Fig. 3 is a kind of structural schematic diagram of Excel file analyzing device of the specific embodiment of the invention.
Specific implementation mode
With reference to the accompanying drawings and examples, the specific implementation mode of the present invention is described in further detail.Implement below
Example is not limited to the scope of the present invention for illustrating the present invention.
Fig. 1 is a kind of flow diagram of Excel file analytic method of the specific embodiment of the invention, as shown in Figure 1, one
Kind Excel file analytic method, S1 extract fileinfo, the heading message of target Excel file using Apache POI respectively
And content information；Wherein, the fileinfo includes at least the unique mark and file name of the target Excel file；Institute
It is right including at least the corresponding row name of unique mark, each column of the target Excel file and each row name to state heading message
The line number answered；The content information includes the unit of the unique mark of the target Excel file, each row name respective column
Lattice data and the corresponding line number of each cell data；S2 corresponds to the fileinfo, heading message and content information
In typing file information table, heading message table and table of contents information.
Specifically, Apache POI are the cross-platform Java API freely to increase income using written in Java, application
Apache POI can parse Excel file.
It is different from the method that traditional Apache POI integrally parse Excel file.The specific embodiment of the invention
In target Excel file is split, target Excel file, which is split as three parts, to be parsed, three parts
Correspond to extraction is fileinfo, heading message and the content information of the target Excel file respectively.
Wherein, the fileinfo includes at least the unique mark and file name of the target Excel file.It is described only
One mark is the target Excel file corresponding globally unique identifier (globally unique in systems
Identifier, GUID), i.e., the exclusive identification code created for the target Excel file by special algorithm.The mesh
The unique mark of mark Excel file is also contained in the heading message and content information, for identification the heading message
Excel file corresponding with content information.
The heading message includes at least every in the unique mark of the target Excel file, the target Excel file
One arranges corresponding row name and the corresponding line number of each row name.Include thus the Excel texts in the heading message
The row name of each row and the every position of rows of names in the Excel file, i.e., described right per rows of names in part
The line number answered.
The content information includes the unit of the unique mark of the target Excel file, each row name respective column
Lattice data and the corresponding line number of each cell data.Include thus in the Excel file in the content information
The position of the data of each cell and each cell data in the target Excel file, i.e., it is described each
The corresponding row name of cell data and line number.
Fileinfo, heading message and the content information in target Excel file are carried using Apache POI
It is corresponding by the fileinfo typing file information table, heading message typing heading message table, content information typing content after taking
Information table completes the parsing of the target Excel file.
In the specific embodiment of the invention, target Excel file is split as three parts and is parsed, to Excel texts
On the basis of part has carried out effective analysis, reduce time cost, improves batch analyzing efficiency.
Based on above-mentioned specific embodiment, a kind of Excel file analytic method, the fileinfo further includes the target
At least one of file type, file size and document location of Excel file.
Specifically, the fileinfo is while the unique mark and file name including the target Excel file,
Further comprise at least one of file type, file size and the document location of the target Excel file.
Based on any of the above-described specific embodiment, a kind of Excel file analytic method, the acquisition methods of the corresponding row name of each column
Including：Sequence reads the first row cell for including data in the target Excel file, and is advised according to preset name
The row name of any cell column is then set with the row number of any cell.
Specifically, the first row cell there are data in the target Excel file is sequentially read, according to the of acquisition
The row number of each unit lattice of a line is named the row belonging to each unit lattice using preset naming rule.
For example, it is assumed that 100 column datas in the target Excel file, obtain in the target Excel file that there are data
The first row, sequentially read each cell in the first row, column position where cell dynamic splicing table
Field name col1, col2 ..., col100, by include data row correspondence be stored in database table, by not data
Row are identified with sky.
Based on any of the above-described specific embodiment, a kind of Excel file analytic method, the file type includes at least
And .xls .xlsx.
Specifically, the analytic method of the Excel file is implemented for the parsing of above-mentioned file type, and is not limited to
This.
Based on any of the above-described specific embodiment, a kind of Excel file analytic method, S3, using the file information table, mark
Topic information table and table of contents information analyze the target Excel file.
Specifically, by the application to the file information table, heading message table and table of contents information to the target
Excel file is analyzed.In the specific embodiment of the invention, an Excel file parsing is generated into three information tables, right
When the target Excel file is analyzed, it is only necessary to be carried from corresponding informance table according to analysis purpose and analysis demand
Breath of winning the confidence reduces the access cost of analysis work, improves base without being extracted to demand information from Global Information
In the information analysis working efficiency of Excel file.
Based on any of the above-described method specific embodiment, Fig. 2 is a kind of Excel file parsing dress of the specific embodiment of the invention
The structural schematic diagram set, as shown in Fig. 2, a kind of Excel file resolver, including information extraction modules 201 and data input
Module 202.Wherein, described information extraction module 201, the text for extracting target Excel file respectively using Apache POI
Part information, heading message and content information；Wherein, the fileinfo includes at least unique mark of the target Excel file
Knowledge and file name；The heading message include at least the target Excel file the corresponding row name of unique mark, each column and
The corresponding line number of each row name；The content information includes the unique mark of the target Excel file, each row
The cell data and the corresponding line number of each cell data of name respective column；Described information recording module 202, being used for will
The fileinfo, heading message and content information correspond in typing file information table, heading message table and table of contents information.
Specifically, Apache POI are the cross-platform Java API freely to increase income using written in Java, application
Apache POI can parse Excel file.
It is different from the method that traditional Apache POI integrally parse Excel file.The specific embodiment of the invention
In target Excel file is split, target Excel file, which is split as three parts, to be parsed, information extraction modules
201 correspond to fileinfo, heading message and the content information that the target Excel file is extracted in three parts respectively.
Wherein, the fileinfo includes at least the unique mark and file name of the target Excel file.It is described only
One mark is the target Excel file corresponding globally unique identifier (globally unique in systems
Identifier, GUID), i.e., the exclusive identification code created for the target Excel file by special algorithm.The mesh
The unique mark of mark Excel file is also contained in the heading message and content information, for identification the heading message
Excel file corresponding with content information.
The heading message includes at least every in the unique mark of the target Excel file, the target Excel file
One arranges corresponding row name and the corresponding line number of each row name.Include thus the Excel texts in the heading message
The row name of each row and the every position of rows of names in the Excel file, i.e., described right per rows of names in part
The line number answered.
The content information includes the unit of the unique mark of the target Excel file, each row name respective column
Lattice data and the corresponding line number of each cell data.Include thus in the Excel file in the content information
The position of the data of each cell and each cell data in the target Excel file, i.e., it is described each
The corresponding row name of cell data and line number.
Information extraction modules 201 application Apache POI in target Excel file fileinfo, heading message and
After content information extracts, above- mentioned information is sent to data input module 202.
After described information recording module 202 receives above-mentioned fileinfo, heading message and content information, correspondence will be described
Fileinfo typing file information table, heading message typing heading message table, content information typing table of contents information, described in completion
The parsing of target Excel file.
In the specific embodiment of the invention, target Excel file is split as three parts and is parsed, to Excel texts
On the basis of part has carried out effective analysis, reduce time cost, improves batch analyzing efficiency.
Based on above-mentioned specific embodiment, a kind of Excel file resolver, the fileinfo further includes the target
At least one of file type, file size and document location of Excel file.
Specifically, the fileinfo is while the unique mark and file name including the target Excel file,
Further comprise at least one of file type, file size and the document location of the target Excel file.
Based on any of the above-described specific embodiment, a kind of Excel file resolver, the acquisition methods of the corresponding row name of each column
Including：Sequence reads the first row cell for including data in the target Excel file, and is advised according to preset name
The row name of any cell column is then set with the row number of any cell.
Specifically, the first row cell there are data in the target Excel file is sequentially read, according to the of acquisition
The row number of each unit lattice of a line is named the row belonging to each unit lattice using preset naming rule.
For example, it is assumed that 100 column datas in the target Excel file, obtain in the target Excel file that there are data
The first row, sequentially read each cell in the first row, column position where cell dynamic splicing table
Field name col1, col2 ..., col100, by include data row correspondence be stored in database table, by not data
Row are identified with sky.Based on any of the above-described specific embodiment, a kind of Excel file resolver, the file type is at least
Including .xlsx and .xls.
Specifically, the analytic method of the Excel file is implemented for the parsing of above-mentioned file type, and is not limited to
This.
Based on any of the above-described specific embodiment, a kind of Excel file resolver further includes file analyzing module, is used for
The target Excel file is analyzed using the file information table, heading message table and table of contents information.The file
Analysis module is electrically connected with described information recording module.
Specifically, file analyzing module obtain described information recording module generate file information table, heading message table and
Table of contents information, and by the application to the file information table, heading message table and table of contents information to the target Excel
File is analyzed.In the specific embodiment of the invention, an Excel file parsing is generated into three information tables, to described
When target Excel file is analyzed, it is only necessary to extract letter from corresponding informance table according to analysis purpose and analysis demand
Breath reduces the access cost of analysis work, improves and be based on without being extracted to demand information from Global Information
The information analysis working efficiency of Excel file.
Fig. 3 is a kind of structural schematic diagram of Excel file analyzing device of the specific embodiment of the invention, as shown in figure 3, should
Equipment includes：At least one processor 301；And at least one processor 302 communicated to connect with the processor 301,
In：The memory 302 is stored with the program instruction that can be executed by the processor 301, and the processor 301 calls the journey
The method that sequence instruction is able to carry out the Excel file parsing that the various embodiments described above are provided, such as including：S1, using Apache
POI extracts fileinfo, heading message and the content information of target Excel file respectively；Wherein, the fileinfo at least wraps
Include the unique mark and file name of the target Excel file；The heading message includes at least the target Excel file
Unique mark, the corresponding row name of each column and the corresponding line number of each row name；The content information includes the target
The unique mark of Excel file, the cell data of each row name respective column and each cell data are corresponding
Line number；The fileinfo, heading message and content information are corresponded to typing file information table, heading message table and content by S2
In information table.
The embodiment of the present invention also provides a kind of non-transient computer readable storage medium, the non-transient computer readable storage
Medium storing computer instructs, which makes computer execute the Excel file parsing side that corresponding embodiment is provided
Method, such as including：S1, fileinfo, heading message and the content for extracting target Excel file respectively using Apache POI are believed
Breath；Wherein, the fileinfo includes at least the unique mark and file name of the target Excel file；The title letter
Unique mark, each column corresponding row name and each row name corresponding line number of the breath including at least the target Excel file；
The content information include the unique mark of the target Excel file, the cell data of each row name respective column and
The corresponding line number of each cell data；The fileinfo, heading message and content information are corresponded to typing file by S2
In information table, heading message table and table of contents information.
One of ordinary skill in the art will appreciate that：Realize that all or part of step of above method embodiment can pass through
The relevant hardware of program instruction is completed, and program above-mentioned can be stored in a computer read/write memory medium, the program
When being executed, step including the steps of the foregoing method embodiments is executed；And storage medium above-mentioned includes：ROM, RAM, magnetic disc or light
The various media that can store program code such as disk.
Finally, the present processes are only preferable embodiment, are not intended to limit the scope of the present invention.It is all
Within the spirit and principles in the present invention, any modification, equivalent replacement, improvement and so on should be included in the protection of the present invention
Within the scope of.
Claims (9)
1. a kind of Excel file analytic method, which is characterized in that including：
S1 extracts fileinfo, heading message and the content information of target Excel file using ApachePOI respectively；Wherein,
The fileinfo includes at least the unique mark and file name of the target Excel file；The heading message is at least wrapped
Include the corresponding row name of unique mark, each column and the corresponding line number of each row name of the target Excel file；The content
Information includes the unique mark of the target Excel file, cell data of each row name respective column and each described
The corresponding line number of cell data；
The fileinfo, heading message and content information are corresponded to typing file information table, heading message table and content and believed by S2
It ceases in table.
2. according to the method described in claim 1, it is characterized in that, the fileinfo further includes the target Excel file
At least one of file type, file size and document location.
3. according to the method described in claim 1, it is characterized in that, the acquisition methods of the corresponding row name of either rank include：
Sequence reads the first row cell for including data in the target Excel file, and is advised according to preset name
The row name of any cell column is then set with the row number of any cell.
4. according to the method described in claim 2, it is characterized in that, the file type includes at least .xlsx and .xls.
5. according to the method described in claim 1, it is characterized in that, further including：
S3 analyzes the target Excel file using the file information table, heading message table and table of contents information.
6. a kind of Excel file resolver, which is characterized in that including：
Information extraction modules, for extracted respectively using ApachePOI the fileinfo of target Excel file, heading message and
Content information；Wherein, the fileinfo includes at least the unique mark and file name of the target Excel file；It is described
Heading message includes at least the corresponding row name of unique mark, each column of the target Excel file and each row name corresponds to
Line number；The content information includes the cell of the unique mark of the target Excel file, each row name respective column
Data and the corresponding line number of each cell data；
Data input module, for the fileinfo, heading message and content information to be corresponded to typing file information table, title
In information table and table of contents information.
7. device according to claim 6, which is characterized in that the fileinfo further includes the target Excel file
At least one of file type, file size and document location.
8. a kind of Excel file analyzing device, which is characterized in that including：
At least one processor；And at least one processor being connect with the processor communication, wherein：The memory is deposited
The program instruction that can be executed by the processor is contained, the processor calls described program instruction to be able to carry out such as claim
1 to 5 any method.
9. a kind of non-transient computer readable storage medium, which is characterized in that the non-transient computer readable storage medium is deposited
Computer instruction is stored up, the computer instruction makes the computer execute the method as described in claim 1 to 5 is any.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711436088.1A CN108280056A (en) | 2017-12-26 | 2017-12-26 | A kind of Excel file analytic method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711436088.1A CN108280056A (en) | 2017-12-26 | 2017-12-26 | A kind of Excel file analytic method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108280056A true CN108280056A (en) | 2018-07-13 |
Family
ID=62802188
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711436088.1A Pending CN108280056A (en) | 2017-12-26 | 2017-12-26 | A kind of Excel file analytic method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108280056A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109117468A (en) * | 2018-08-01 | 2019-01-01 | 北京数字雷暴信息科技有限公司 | A kind of data processing method and device |
| CN109213495A (en) * | 2018-08-23 | 2019-01-15 | 郑州云海信息技术有限公司 | A kind of read method and device of data |
| CN109284254A (en) * | 2018-10-16 | 2019-01-29 | 浪潮天元通信信息系统有限公司 | A kind of general excel document handling method |
| CN110457021A (en) * | 2019-07-12 | 2019-11-15 | 招商局金融科技有限公司 | Achievement data processing method, device and computer readable storage medium |
| CN112818937A (en) * | 2021-03-02 | 2021-05-18 | 广联达科技股份有限公司 | Excel file identification method and device, electronic equipment and readable storage medium |
| CN113010588A (en) * | 2019-12-20 | 2021-06-22 | 北京国基科技股份有限公司 | Data table processing method |
| CN117472359A (en) * | 2023-12-26 | 2024-01-30 | 广东太亚科技有限公司 | Visual configuration multistage linkage constraint method, device and computer equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1841362A (en) * | 2005-03-31 | 2006-10-04 | 国际商业机器公司 | Method and system for processing an electronic form |
| CN103500196A (en) * | 2013-09-22 | 2014-01-08 | 成都交大光芒科技股份有限公司 | EXCEL data export method and export device in multi-concurrence large data volume environment |
| US20160078004A1 (en) * | 2014-09-15 | 2016-03-17 | Oracle International Corporation | System independent font rendering |
| US20170268072A1 (en) * | 2016-03-21 | 2017-09-21 | The Samuel Roberts Noble Foundation, Inc. | Methods for identifying pecan tree cultivars |
-
2017
- 2017-12-26 CN CN201711436088.1A patent/CN108280056A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1841362A (en) * | 2005-03-31 | 2006-10-04 | 国际商业机器公司 | Method and system for processing an electronic form |
| CN103500196A (en) * | 2013-09-22 | 2014-01-08 | 成都交大光芒科技股份有限公司 | EXCEL data export method and export device in multi-concurrence large data volume environment |
| US20160078004A1 (en) * | 2014-09-15 | 2016-03-17 | Oracle International Corporation | System independent font rendering |
| US20170268072A1 (en) * | 2016-03-21 | 2017-09-21 | The Samuel Roberts Noble Foundation, Inc. | Methods for identifying pecan tree cultivars |
Non-Patent Citations (3)
| Title |
|---|
| 刁树民，等: "《大学计算机基础》", 31 August 2005, 哈尔滨工业大学出版社 * |
| 张强: "利用POI操作Excel", 《电脑知识与技术》 * |
| 朱文君，等: "基于Java反射机制的POI实现Excel数据导入/导出", 《计算机时代》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109117468A (en) * | 2018-08-01 | 2019-01-01 | 北京数字雷暴信息科技有限公司 | A kind of data processing method and device |
| CN109213495A (en) * | 2018-08-23 | 2019-01-15 | 郑州云海信息技术有限公司 | A kind of read method and device of data |
| CN109284254A (en) * | 2018-10-16 | 2019-01-29 | 浪潮天元通信信息系统有限公司 | A kind of general excel document handling method |
| CN110457021A (en) * | 2019-07-12 | 2019-11-15 | 招商局金融科技有限公司 | Achievement data processing method, device and computer readable storage medium |
| CN113010588A (en) * | 2019-12-20 | 2021-06-22 | 北京国基科技股份有限公司 | Data table processing method |
| CN113010588B (en) * | 2019-12-20 | 2023-07-04 | 北京国基科技股份有限公司 | Data form processing method |
| CN112818937A (en) * | 2021-03-02 | 2021-05-18 | 广联达科技股份有限公司 | Excel file identification method and device, electronic equipment and readable storage medium |
| CN117472359A (en) * | 2023-12-26 | 2024-01-30 | 广东太亚科技有限公司 | Visual configuration multistage linkage constraint method, device and computer equipment |
| CN117472359B (en) * | 2023-12-26 | 2024-03-01 | 广东太亚科技有限公司 | Visual configuration multistage linkage constraint method, device and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108280056A (en) | A kind of Excel file analytic method | |
| CN108399256B (en) | Heterogeneous database content synchronization method and device and middleware | |
| CN104899295B (en) | A kind of heterogeneous data source data relation analysis method | |
| CN106682036A (en) | Data exchange system and exchange method thereof | |
| CN111291049A (en) | Method, device, equipment and storage medium for creating table | |
| CN101901265B (en) | Objectification management system of virtual test data | |
| CN102375746A (en) | Method and device for enabling input method to self-adapt to application program | |
| CN104951515B (en) | A method of it extracts and analyzes Android phone whereabouts trace information | |
| CN107168695B (en) | Excel data analysis method and system | |
| CN103377053A (en) | Method, device and system for controlling application | |
| CN101944128A (en) | Data export and import method and device | |
| CN102981882B (en) | Analytic method and device | |
| CN107301214A (en) | Data migration method, device and terminal device in HIVE | |
| CN105701251A (en) | Data export and import method based on object definition | |
| CN108664657A (en) | A kind of big data method for scheduling task, electronic equipment, storage medium and platform | |
| CN107103035A (en) | This earth's surface data-updating method and device | |
| CN109670129A (en) | A kind of method and device for switching to html web page to be adapted to MIP format | |
| CN103645895B (en) | Method of automatic configuration and cloud compiling system | |
| CN105843899A (en) | Automatic big-data analysis method and system capable of simplifying programming | |
| CN109426496A (en) | Method, storage medium, electronic equipment and the system of program log write-in file | |
| WO2011074942A1 (en) | System and method of converting data from a multiple table structure into an edoc format | |
| CN107766519B (en) | Method for visually configuring data structure | |
| US8930808B2 (en) | Processing rich text data for storing as legacy data records in a data storage system | |
| CN106156075B (en) | A kind of method and device of report generation and displaying | |
| CN104346378B (en) | A kind of method, apparatus and system for realizing complex data processing |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180713 |
|
| RJ01 | Rejection of invention patent application after publication |