CN109241514A - Data automatically imported method, device, computer equipment and storage medium - Google Patents
Data automatically imported method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109241514A CN109241514A CN201811048318.1A CN201811048318A CN109241514A CN 109241514 A CN109241514 A CN 109241514A CN 201811048318 A CN201811048318 A CN 201811048318A CN 109241514 A CN109241514 A CN 109241514A
- Authority
- CN
- China
- Prior art keywords
- data
- file
- imported
- cell
- preset requirement
- 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/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
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)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to data automatically imported method, device, computer equipment and storage medium, this method obtains file to be imported；File to be imported is scanned, the cell data for meeting preset requirement are obtained；The cell data for meeting preset requirement are converted into the expression formula for having object format；File destination is constructed according to the expression formula for having object format；Import file destination.The present invention fills in rule by setting, the cell data of file to be imported are scanned, form the expression formula for having object format, expression formula is switched into file destination, to which file to be imported to be switched to the file destination of unified format, the data in different-format table can be converted to unified format and imported, the workload that data import is reduced, and the importing of different-format list data is carried out without developing multiple programs, it is convenient and efficient.
Description
Technical field
The present invention relates to data lead-in methods, more specifically refer to data automatically imported method, device, computer equipment
And storage medium.
Background technique
The shared transmitting for referring to business data of corporate resources, the transmitting of business data include the importing of business data and lead
Out, it is led from the enterprise resource planning of several first systematics (Enterprise Resource Planning, ERP)
Multiple Excel files out contain several business data in these Excel files, and the format of these Excel files is different, will
These Excel files import in second system, this requires that second system has multiple application programs to receive not apposition
The importing of formula file, larger workload, inefficiency.
Therefore, it is necessary to design a kind of new method, realizes and receive leading for different-format file without opening up multiple programs
Enter, it is high-efficient.
Summary of the invention
It is an object of the invention to overcome the deficiencies of existing technologies, data automatically imported method, device, computer are provided and set
Standby and storage medium.
To achieve the above object, the invention adopts the following technical scheme: data automatically imported method, comprising:
Obtain file to be imported；
File to be imported is scanned, the cell data for meeting preset requirement are obtained；
The cell data for meeting preset requirement are converted into the expression formula for having object format；
File destination is constructed according to the expression formula for having object format；
Import file destination.
Its further technical solution are as follows: before the acquisition file to be imported, further includes:
Preset the transformational relation of file unit lattice data to be imported.
Its further technical solution are as follows: it is described that file to be imported is scanned, obtain the cell for meeting preset requirement
Data, comprising:
The cell in file to be imported with transformational relation is scanned, the cell with transformational relation is obtained, to obtain
Meet the cell data of preset requirement.
Its further technical solution are as follows: the cell data that will meet preset requirement, which are converted to, has object format
Expression formula, comprising:
The meaning for meeting the cell data of preset requirement is obtained according to transformational relation；
Integration meets the cell data and meaning of preset requirement, to obtain the expression formula for having object format.
Its further technical solution are as follows: the basis has the expression formula building file destination of object format, comprising:
Several Set cell objects are constructed according to the expression formula for having object format；
Several Set cell objects are combined, to obtain meeting file destination.
The present invention also provides data automatic leading-in devices, comprising:
File obtaining unit, for obtaining file to be imported；
Scanning element obtains the cell data for meeting preset format for being scanned to file to be imported；
Converting unit, for the cell data for meeting preset requirement to be converted to the expression formula for having object format；
Construction unit, for constructing file destination according to the expression formula for having object format；
Import unit, for importing file destination.
Its further technical solution are as follows: described device further include:
Default unit, for presetting the transformational relation of file unit lattice data to be imported.
Its further technical solution are as follows: the converting unit includes:
Meaning obtains subelement, for obtaining the meaning for meeting the cell data of preset requirement according to transformational relation；
Subelement is integrated, for integrating the cell data and meaning that meet preset requirement, to obtain having object format
Expression formula.
The present invention also provides a kind of computer equipment, the computer equipment includes memory and processor, described to deposit
Computer program is stored on reservoir, the processor realizes the above-mentioned data side of being automatically imported when executing the computer program
Method.
The present invention also provides a kind of storage medium, the storage medium is stored with computer program, the computer journey
Sequence can realize above-mentioned data automatically imported method when being executed by processor.
Compared with the prior art, the invention has the advantages that: the present invention is by setting transformational relation, to file to be imported
Cell data be scanned, formed and have the expression formula of object format, expression formula is switched into file destination, thus will be wait lead
Enter the file destination that file switchs to unified format, the data in different-format table can be converted to unified format and import, subtracts
Minority and carries out without developing multiple programs the importing of different-format list datas according to the workload of importing, convenient and efficient.
The invention will be further described in the following with reference to the drawings and specific embodiments.
Detailed description of the invention
Technical solution in order to illustrate the embodiments of the present invention more clearly, below will be to needed in embodiment description
Attached drawing is briefly described, it should be apparent that, drawings in the following description are some embodiments of the invention, general for this field
For logical technical staff, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is the application scenarios schematic diagram of data automatically imported method provided in an embodiment of the present invention；
Fig. 2 is the flow diagram of data automatically imported method provided in an embodiment of the present invention；
Fig. 3 is the sub-process schematic diagram of data automatically imported method provided in an embodiment of the present invention；
Fig. 4 is the sub-process schematic diagram of data automatically imported method provided in an embodiment of the present invention；
Fig. 5 is the schematic block diagram of data automatic leading-in device provided in an embodiment of the present invention；
Fig. 6 is the schematic block diagram of the converting unit of data automatic leading-in device provided in an embodiment of the present invention；
Fig. 7 is the schematic block diagram of the construction unit of data automatic leading-in device provided in an embodiment of the present invention；
Fig. 8 is the schematic block diagram of computer equipment provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
It should be appreciated that ought use in this specification and in the appended claims, term " includes " and "comprising" instruction
Described feature, entirety, step, operation, the presence of element and/or component, but one or more of the other feature, whole is not precluded
Body, step, operation, the presence or addition of element, component and/or its set.
It is also understood that mesh of the term used in this description of the invention merely for the sake of description specific embodiment
And be not intended to limit the present invention.As description of the invention and it is used in the attached claims, unless on
Other situations are hereafter clearly indicated, otherwise " one " of singular, "one" and "the" are intended to include plural form.
It will be further appreciated that the term "and/or" used in description of the invention and the appended claims is
Refer to any combination and all possible combinations of one or more of associated item listed, and including these combinations.
Fig. 1 and Fig. 2 are please referred to, Fig. 1 is that the application scenarios of data automatically imported method provided in an embodiment of the present invention are illustrated
Figure.Fig. 2 is the schematic flow chart of data automatically imported method provided in an embodiment of the present invention.The data automatically imported method is answered
For being imported into server 20.This, which is imported into server 20, to be a server in Distributed Services platform, the quilt
Import server 20 in be deployed with importing platform, this be imported into server 20 import platform receive import server 10 wait lead
Enter file, to carry out file importing.
It should be noted that only illustrating that an importing server 10 is imported into the actual operation process in Fig. 2
Server 20 can import file in multiple importing servers 10.
Fig. 2 is the flow diagram of data automatically imported method provided in an embodiment of the present invention.As shown, this method packet
Include following steps S110 to S160.
S110, the transformational relation for presetting file unit lattice data to be imported.
In the present embodiment, transformational relation refers to containing representated by data in each cell to file to be imported
Data in justice, that is, the cell of file to be imported and its closed in the mapping for the file destination being imported into server 20
System.
In the present embodiment, a template is preset, is scanned to the template, to form transformational relation, and will
The transformational relation is stored in server, and once importing server transport data to when being imported into server, which can be according to
The transformational relation forms file destination.
For example, the second row third of file to be imported, which arranges corresponding cell data, represents declaration amount, then corresponds to and led
Enter the corresponding cell data of the third line secondary series of file destination in server 20.To the cell data to be imported asked in valence
Transformational relation setting is carried out, may make that being imported into server 20 is not necessarily to develop leading for multiple programs progress different-format list datas
Enter, it is only necessary to which can be converted to according to transformational relation acquiring unit lattice data can import the file destination pair for being imported into server 20
It answers in cell, it is convenient and efficient.
S120, file to be imported is obtained.
Specifically, file to be imported, each text to be imported for importing server 10 and exporting are obtained out of importing server 10
The format of part is all unanimously that therefore, different conversions can be arranged according to different importing servers 10 by being imported into server 20
Relationship, in order to once receive multiple and different formats file to be imported importing, improve import efficiency.
S130, file to be imported is scanned, obtains the cell data for meeting preset requirement.
In the present embodiment, the cell data for meeting preset requirement, which refer in the cell with transformational relation, is filled in
Data.
In the present embodiment, the cell in file to be imported with transformational relation is specifically scanned, obtaining has conversion
The cell of relationship, to obtain the cell data for meeting preset requirement.For some units for not setting transformational relation originally
The efficiency of scanning can be improved without scanning in lattice.
S140, the cell data for meeting preset requirement are converted into the expression formula for having object format.
Specifically, excel data file is switched to system data, is transported in systems by system according to default rule
It is saved after calculation, to form the expression formula for having object format.
In the present embodiment, object format is the meaning of cell data and cell data according to certain expression way
The format of expression, such as: the format that O.f11. declares at customs quantity=10 is then object format, represents first in file O to be imported
The corresponding cell of row first row is declaration quantity, and corresponding cell data are 10, this object format simultaneously fill in by non-user
The data of formation, but server is obtained according to the data conversion that user transmits.
Specifically, O. declaration quantity is filled in the first row first row of Excel template file, then represents and is imported in Excel
In file, the first row first row corresponds to the declaration quantity that data structure in program is object O, that is, forms such a corresponding relationship
(1,1)-O. declares at customs quantity, when number is 10 in the first row first row of the practical importing file of Excel, imports program
" O. declares at customs quantity " this data structure that this number 10 will be assigned in program, then carries out subsequent algorithm meter
It calculates, store and transmit；And preset corresponding relationship includes and the corresponding relationship of common data structure (such as O. number in file to be imported
Amount), the corresponding relationship of subobject data structure (such as O. cargo unit price), further include the data relationship of list type, for example have not
The list of multiple cargos of quantification includes title, quantity, unit price etc. in each cargo.
It is preset in file to be imported, after the file to be imported that program scanning is preset, forms the file to be imported
Description file, comprising:
Common data structure and cell corresponding relationship, such as (1,1) --- O. title；
Subobject data structure and cell corresponding relationship, can be multilayer subobject, such as (1,10) --- O. haulagman
Has title；
List type corresponding relationship (needing to recycle acquisition), such as (4,1)-(x, 1) " total " --- O. cargo, 1 --- O.
Cargo title indicates backward to recycle always since the 4th row the 1st column, be classified as " total " position until the first of certain a line,
All data are all assigned to O. cargo object, wherein the first of every a line is classified as cargo title, and cargo is a list
Type.
After inputting actual file data file corresponding with file to be imported, the template of the data file is judged first
ID recalls the description file of the file to be imported according to template ID, is carried out according to content of the description file to actual data files
Scanning, and the data content is assigned to according to description file by program internal data object, it carries out subsequent algorithm calculating, deposit
Storage and transmission.
In one embodiment, as shown in figure 3, above-mentioned step S140 may include step S141~S142.
S141, the meaning for meeting the cell data of preset requirement is obtained according to transformational relation；
In the present embodiment, the cell data for meeting preset requirement all have a meaning, which can be from turning
It changes in relationship and obtains, therefore it may only be necessary to from the relationship of transformational relation and the cell data for meeting preset requirement it can be learnt that full
The meaning of the cell data of sufficient preset requirement.
S142, integration meet the cell data and meaning of preset requirement, to obtain the expression formula for having object format.
In the present embodiment, specifically according to the lattice of file name cell location meaning=cell data to be imported
Formula integrates the cell data and meaning for meeting preset requirement, to form the expression formula for having object format.
S150, file destination is constructed according to the expression formula for having object format.
In the present embodiment, file destination, which refers to, inserts file to be imported according to being imported into table set by server 20
The file of corresponding unit lattice data.
In one embodiment, as shown in figure 4, above-mentioned step S150 may include step S151~S152.
S151, several Set cell objects are constructed according to the expression formula for having object format.
S152, several Set cell objects are combined, to obtain meeting file destination.
In the present embodiment, Set cell object refers to according to the cell for being imported into table set by server 20
Data.Specifically, according to the object format of file name cell location meaning=cell data to be imported, meaning is constructed
The Set cell object of=cell data, and by several Set cell object compositions at table, to obtain target text
Part.
In other embodiments, if meaning is that calculating character is being formed after carrying out operation to the data in cell data
Meaning=cell data Set cell object, wherein the cell data are then the data after operation.
S170, file destination is imported.
In the present embodiment, the file destination of generation is directed into the database for being imported into server 20.By target text
The data that part is carried are configured to the data structure of information system needs, to facilitate relevant computer program to this data
Structure carries out algorithm calculating, preservation and transmission.
Above-mentioned data automatically imported method carries out the cell data of file to be imported by setting transformational relation
Scanning forms the expression formula for having object format, expression formula is switched to file destination, so that file to be imported is switched to unified lattice
Data in different-format table can be converted to unified format and imported, reduce the work that data import by the file destination of formula
Amount, and the importing without developing multiple programs progress different-format list datas, it is convenient and efficient.
Fig. 5 is a kind of schematic block diagram of data automatic leading-in device 300 provided in an embodiment of the present invention.As shown in figure 5,
Corresponding to above data automatically imported method, the present invention also provides a kind of data automatic leading-in devices 300.The data are automatically imported
Device 300 includes the unit for executing above-mentioned data automatically imported method, which can be configured in server.Specifically
Ground, referring to Fig. 5, the data automatic leading-in device 300 includes:
File obtaining unit 302, for obtaining file to be imported；
Scanning element 303 obtains the cell data for meeting preset format for being scanned to file to be imported；
Converting unit 304, for the cell data for meeting preset requirement to be converted to the expression formula for having object format；
Construction unit 305, for constructing file destination according to the expression formula for having object format；
Import unit 306, for importing file destination.
In addition, above-mentioned device further include:
Default unit 301, for presetting the transformational relation of file unit lattice data to be imported
In one embodiment, as shown in fig. 6, the converting unit 304 includes:
Meaning obtains subelement 3041, meets the cell data of preset requirement for being obtained according to transformational relation and contains
Justice.
Subelement 3042 is integrated, for integrating the cell data and meaning that meet preset requirement, to obtain having target
The expression formula of format.
In one embodiment, as shown in fig. 7, the construction unit 305 includes:
Object constructs subelement 3051, for constructing several Set cells pair according to the expression formula for having object format
As；
Subelement 3052 is combined, for combining several Set cell objects, to obtain meeting file destination.
It should be noted that it is apparent to those skilled in the art that, above-mentioned data automatic leading-in device
300 and each unit specific implementation process, can with reference to the corresponding description in preceding method embodiment, for convenience of description and
Succinctly, details are not described herein.
Above-mentioned data automatic leading-in device 300 can be implemented as a kind of form of computer program, which can
To be run in computer equipment as shown in Figure 8.
Referring to Fig. 8, Fig. 8 is a kind of schematic block diagram of computer equipment provided by the embodiments of the present application.The computer
Equipment 500 is server, which can be independent server, is also possible to the server set of multiple server compositions
Group.
Refering to Fig. 8, which includes processor 502, memory and the net connected by system bus 501
Network interface 505, wherein memory may include non-volatile memory medium 503 and built-in storage 504.
The non-volatile memory medium 503 can storage program area 5031 and computer program 5032.The computer program
5032 include program instruction, which is performed, and processor 502 may make to execute a kind of data automatically imported method.
The processor 502 is for providing calculating and control ability, to support the operation of entire computer equipment 500.
The built-in storage 504 provides environment for the operation of the computer program 5032 in non-volatile memory medium 503, should
When computer program 5032 is executed by processor 502, processor 502 may make to execute a kind of data automatically imported method.
The network interface 505 is used to carry out network communication with other equipment.It will be understood by those skilled in the art that in Fig. 8
The structure shown, only the block diagram of part-structure relevant to application scheme, does not constitute and is applied to application scheme
The restriction of computer equipment 500 thereon, specific computer equipment 500 may include more more or fewer than as shown in the figure
Component perhaps combines certain components or with different component layouts.
Wherein, the processor 502 is for running computer program 5032 stored in memory, to realize following step
It is rapid:
Obtain file to be imported；
File to be imported is scanned, the cell data for meeting preset requirement are obtained；
The cell data for meeting preset requirement are converted into the expression formula for having object format；
File destination is constructed according to the expression formula for having object format；
Import file destination.
In one embodiment, processor 502 also realizes following step before realizing the acquisition Files step to be imported
It is rapid:
Preset the transformational relation of file unit lattice data to be imported.
In one embodiment, processor 502 realize it is described file to be imported is scanned, acquisition meet preset requirement
Cell data step when, be implemented as follows step:
The cell in file to be imported with transformational relation is scanned, the cell with transformational relation is obtained, to obtain
Meet the cell data of preset requirement.
In one embodiment, processor 502 is converted in the realization cell data that will meet preset requirement and has
When the expression formula step of object format, following steps are also realized:
The meaning for meeting the cell data of preset requirement is obtained according to transformational relation；
Integration meets the cell data and meaning of preset requirement, to obtain the expression formula for having object format.
In one embodiment, processor 502 constructs file destination in the expression formula for realizing that the basis has object format
When step, following steps are also realized:
Several Set cell objects are constructed according to the expression formula for having object format；
Several Set cell objects are combined, to obtain meeting file destination.
It should be appreciated that in the embodiment of the present application, processor 502 can be central processing unit (Central
Processing Unit, CPU), which can also be other general processors, digital signal processor (Digital
Signal Processor, DSP), specific integrated circuit (Application Specific Integrated Circuit,
ASIC), ready-made programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic
Device, discrete gate or transistor logic, discrete hardware components etc..Wherein, general processor can be microprocessor or
Person's processor is also possible to any conventional processor etc..
Those of ordinary skill in the art will appreciate that be realize above-described embodiment method in all or part of the process,
It is that relevant hardware can be instructed to complete by computer program.The computer program includes program instruction, computer journey
Sequence can be stored in a storage medium, which is computer readable storage medium.The program instruction is by the department of computer science
At least one processor in system executes, to realize the process step of the embodiment of the above method.
Therefore, the present invention also provides a kind of storage mediums.The storage medium can be computer readable storage medium.This is deposited
Storage media is stored with computer program, and processor is made to execute following steps when wherein the computer program is executed by processor:
Obtain file to be imported；
File to be imported is scanned, the cell data for meeting preset requirement are obtained；
The cell data for meeting preset requirement are converted into the expression formula for having object format；
File destination is constructed according to the expression formula for having object format；
Import file destination.
In one embodiment, the processor realizes acquisition file step to be imported executing the computer program
Before rapid, following steps are also realized:
Preset the transformational relation of file unit lattice data to be imported.
In one embodiment, the processor is realized described to file to be imported progress in the execution computer program
Scanning is implemented as follows step when acquisition meets the cell data step of preset requirement:
The cell in file to be imported with transformational relation is scanned, the cell with transformational relation is obtained, to obtain
Meet the cell data of preset requirement.
In one embodiment, the processor is executing the computer program and realizing described will meet preset requirement
When cell data are converted to the expression formula step for having object format, following steps are also realized:
The meaning for meeting the cell data of preset requirement is obtained according to transformational relation；
Integration meets the cell data and meaning of preset requirement, to obtain the expression formula for having object format.
In one embodiment, the processor realizes the basis and has object format in the execution computer program
Expression formula construct file destination step when, also realization following steps:
Several Set cell objects are constructed according to the expression formula for having object format；
Several Set cell objects are combined, to obtain meeting file destination.
The storage medium can be USB flash disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), magnetic disk
Or the various computer readable storage mediums that can store program code such as CD.
Those of ordinary skill in the art may be aware that list described in conjunction with the examples disclosed in the embodiments of the present disclosure
Member and algorithm steps, can be realized with electronic hardware, computer software, or a combination of the two, in order to clearly demonstrate hardware
With the interchangeability of software, each exemplary composition and step are generally described according to function in the above description.This
A little functions are implemented in hardware or software actually, the specific application and design constraint depending on technical solution.Specially
Industry technical staff can use different methods to achieve the described function each specific application, but this realization is not
It is considered as beyond the scope of this invention.
In several embodiments provided by the present invention, it should be understood that disclosed device and method can pass through it
Its mode is realized.For example, the apparatus embodiments described above are merely exemplary.For example, the division of each unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation.Such as multiple units or components can be tied
Another system is closed or is desirably integrated into, or some features can be ignored or not executed.
The steps in the embodiment of the present invention can be sequentially adjusted, merged and deleted according to actual needs.This hair
Unit in bright embodiment device can be combined, divided and deleted according to actual needs.In addition, in each implementation of the present invention
Each functional unit in example can integrate in one processing unit, is also possible to each unit and physically exists alone, can also be with
It is that two or more units are integrated in one unit.
If the integrated unit is realized in the form of SFU software functional unit and when sold or used as an independent product,
It can store in one storage medium.Based on this understanding, technical solution of the present invention is substantially in other words to existing skill
The all or part of part or the technical solution that art contributes can be embodied in the form of software products, the meter
Calculation machine software product is stored in a storage medium, including some instructions are used so that a computer equipment (can be a
People's computer, terminal or network equipment etc.) it performs all or part of the steps of the method described in the various embodiments of the present invention.
The above description is merely a specific embodiment, but scope of protection of the present invention is not limited thereto, any
Those familiar with the art in the technical scope disclosed by the present invention, can readily occur in various equivalent modifications or replace
It changes, these modifications or substitutions should be covered by the protection scope of the present invention.Therefore, protection scope of the present invention should be with right
It is required that protection scope subject to.
Claims (10)
1. data automatically imported method characterized by comprising
Obtain file to be imported；
File to be imported is scanned, the cell data for meeting preset requirement are obtained；
The cell data for meeting preset requirement are converted into the expression formula for having object format；
File destination is constructed according to the expression formula for having object format；
Import file destination.
2. data automatically imported method according to claim 1, which is characterized in that before the acquisition file to be imported,
Further include:
Preset the transformational relation of file unit lattice data to be imported.
3. data automatically imported method according to claim 2, which is characterized in that described to be swept to file to be imported
It retouches, obtains the cell data for meeting preset requirement, comprising:
The cell in file to be imported with transformational relation is scanned, the cell with transformational relation is obtained, to be met
The cell data of preset requirement.
4. data automatically imported method according to claim 3, which is characterized in that the unit that preset requirement will be met
Lattice data are converted to the expression formula for having object format, comprising:
The meaning for meeting the cell data of preset requirement is obtained according to transformational relation；
Integration meets the cell data and meaning of preset requirement, to obtain the expression formula for having object format.
5. data automatically imported method according to claim 4, which is characterized in that the basis has the table of object format
File destination is constructed up to formula, comprising:
Several Set cell objects are constructed according to the expression formula for having object format；
Several Set cell objects are combined, to obtain meeting file destination.
6. data automatic leading-in device characterized by comprising
File obtaining unit, for obtaining file to be imported；
Scanning element obtains the cell data for meeting preset format for being scanned to file to be imported；
Converting unit, for the cell data for meeting preset requirement to be converted to the expression formula for having object format；
Construction unit, for constructing file destination according to the expression formula for having object format；
Import unit, for importing file destination.
7. data automatic leading-in device according to claim 6, which is characterized in that described device further include:
Default unit, for presetting the transformational relation of file unit lattice data to be imported.
8. data automatic leading-in device according to claim 7, which is characterized in that the converting unit includes:
Meaning obtains subelement, for obtaining the meaning for meeting the cell data of preset requirement according to transformational relation；
Subelement is integrated, for integrating the cell data and meaning that meet preset requirement, to obtain the table for having object format
Up to formula.
9. a kind of computer equipment, which is characterized in that the computer equipment includes memory and processor, on the memory
It is stored with computer program, the processor is realized as described in any one of claims 1 to 5 when executing the computer program
Data automatically imported method.
10. a kind of storage medium, which is characterized in that the storage medium is stored with computer program, the computer program quilt
Processor can realize the data automatically imported method as described in any one of claims 1 to 5 when executing.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811048318.1A CN109241514A (en) | 2018-09-10 | 2018-09-10 | Data automatically imported method, device, computer equipment and storage medium |
| PCT/CN2018/117860 WO2020052090A1 (en) | 2018-09-10 | 2018-11-28 | Method and apparatus for automatically importing data, computer device, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811048318.1A CN109241514A (en) | 2018-09-10 | 2018-09-10 | Data automatically imported method, device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109241514A true CN109241514A (en) | 2019-01-18 |
Family
ID=65067675
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811048318.1A Pending CN109241514A (en) | 2018-09-10 | 2018-09-10 | Data automatically imported method, device, computer equipment and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN109241514A (en) |
| WO (1) | WO2020052090A1 (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110334018A (en) * | 2019-06-18 | 2019-10-15 | 梁俊杰 | A kind of big data introduction method and relevant device |
| CN110377563A (en) * | 2019-07-23 | 2019-10-25 | 中国工商银行股份有限公司 | Document handling method and device and electronic equipment and readable storage medium storing program for executing |
| CN110688826A (en) * | 2019-08-14 | 2020-01-14 | 中国平安人寿保险股份有限公司 | Disordered row-column transposition method and device, computer equipment and storage medium |
| CN110991150A (en) * | 2019-12-16 | 2020-04-10 | 中国铁塔股份有限公司 | Data format conversion method and device and account reporting system |
| CN111859596A (en) * | 2019-04-16 | 2020-10-30 | 萨姆森控制设备（中国）有限公司 | Control valve model selection method and control valve model selection device |
| CN112035412A (en) * | 2020-08-31 | 2020-12-04 | 北京奇虎鸿腾科技有限公司 | Data file importing method, device, storage medium and device |
| CN112650477A (en) * | 2020-12-31 | 2021-04-13 | 深圳软牛科技有限公司 | Project data batch transfer method and device and electronic equipment |
| CN112733491A (en) * | 2020-12-31 | 2021-04-30 | 北京乐学帮网络技术有限公司 | Data conversion method and device, computer equipment and storage medium |
| CN112957742A (en) * | 2021-04-07 | 2021-06-15 | 北京格瑞拉科技有限公司 | Processing method and processing device for configuration file |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090031205A1 (en) * | 2001-08-09 | 2009-01-29 | International Business Machines Corporation | System for exporting-impoting the content of input cells from a scalable template instance to another |
| CN103793372A (en) * | 2012-10-30 | 2014-05-14 | 国际商业机器公司 | Extracting semantic relationships from table structures in electronic documents |
| CN104285209A (en) * | 2011-12-29 | 2015-01-14 | 比博实验室公司 | Spreadsheet-based programming language adapted for report generation |
| CN105868196A (en) * | 2015-01-21 | 2016-08-17 | 张家口沪东电子科技有限公司 | Method for generating industrial data report in server |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7002580B1 (en) * | 2003-05-14 | 2006-02-21 | At&T Corp | Method and apparatus for automatically generating charts |
| CN103853806A (en) * | 2013-09-26 | 2014-06-11 | 深圳海联讯科技股份有限公司 | Method and device for converting table |
| CN106919618A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | Excel data lead-in methods and system |
| CN107122473A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | A kind of lead-in and lead-out method and device of Excel data |
-
2018
- 2018-09-10 CN CN201811048318.1A patent/CN109241514A/en active Pending
- 2018-11-28 WO PCT/CN2018/117860 patent/WO2020052090A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090031205A1 (en) * | 2001-08-09 | 2009-01-29 | International Business Machines Corporation | System for exporting-impoting the content of input cells from a scalable template instance to another |
| CN104285209A (en) * | 2011-12-29 | 2015-01-14 | 比博实验室公司 | Spreadsheet-based programming language adapted for report generation |
| CN103793372A (en) * | 2012-10-30 | 2014-05-14 | 国际商业机器公司 | Extracting semantic relationships from table structures in electronic documents |
| CN105868196A (en) * | 2015-01-21 | 2016-08-17 | 张家口沪东电子科技有限公司 | Method for generating industrial data report in server |
Non-Patent Citations (1)
| Title |
|---|
| 王允富: "半结构化文本信息抽取方法研究及应用", 《中国优秀硕士学位论文全文数据库》 * |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111859596A (en) * | 2019-04-16 | 2020-10-30 | 萨姆森控制设备（中国）有限公司 | Control valve model selection method and control valve model selection device |
| CN111859596B (en) * | 2019-04-16 | 2024-02-02 | 萨姆森控制设备（中国）有限公司 | Control valve type selection method and control valve type selection device |
| CN110334018A (en) * | 2019-06-18 | 2019-10-15 | 梁俊杰 | A kind of big data introduction method and relevant device |
| CN110377563A (en) * | 2019-07-23 | 2019-10-25 | 中国工商银行股份有限公司 | Document handling method and device and electronic equipment and readable storage medium storing program for executing |
| CN110688826A (en) * | 2019-08-14 | 2020-01-14 | 中国平安人寿保险股份有限公司 | Disordered row-column transposition method and device, computer equipment and storage medium |
| CN110688826B (en) * | 2019-08-14 | 2023-07-25 | 中国平安人寿保险股份有限公司 | Disorder rank transposition method, device, computer equipment and storage medium |
| CN110991150A (en) * | 2019-12-16 | 2020-04-10 | 中国铁塔股份有限公司 | Data format conversion method and device and account reporting system |
| CN110991150B (en) * | 2019-12-16 | 2023-10-03 | 中国铁塔股份有限公司 | Data format conversion method, device and account reporting system |
| CN112035412A (en) * | 2020-08-31 | 2020-12-04 | 北京奇虎鸿腾科技有限公司 | Data file importing method, device, storage medium and device |
| CN112650477A (en) * | 2020-12-31 | 2021-04-13 | 深圳软牛科技有限公司 | Project data batch transfer method and device and electronic equipment |
| CN112733491A (en) * | 2020-12-31 | 2021-04-30 | 北京乐学帮网络技术有限公司 | Data conversion method and device, computer equipment and storage medium |
| CN112957742A (en) * | 2021-04-07 | 2021-06-15 | 北京格瑞拉科技有限公司 | Processing method and processing device for configuration file |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2020052090A1 (en) | 2020-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109241514A (en) | Data automatically imported method, device, computer equipment and storage medium | |
| CN102033848B (en) | SOA-based three-dimensional design system integrating method and system | |
| CN107678736A (en) | A kind of business Page Template shows method, system and computer installation | |
| CN104216912A (en) | Method and device for achieving non-intrusive service form workflow | |
| US20080183479A1 (en) | Business process reconstruction method, and its program and computer | |
| CN110457666B (en) | Report generation method, system, electronic equipment and storage medium | |
| EP2328301A1 (en) | Method and apparatus for managing the authority in workflow component based on authority component | |
| CN112035090B (en) | Intelligent contract intelligent management system and method based on containerization technology | |
| CN109614110A (en) | A kind of method and apparatus that message-oriented middleware concentrates deployment | |
| CN104598249B (en) | Software personalisation customization and dispositions method that multi-tenant is perceived | |
| CN110489812A (en) | Multilayer level netlist processing method, device, computer equipment and storage medium | |
| CN112511596A (en) | Method and equipment for creating cloud resources in cloud platform | |
| CN102521218A (en) | File combining method and file combining device | |
| CN108021621A (en) | Database data acquisition method, application server and computer-readable recording medium | |
| CN101409717A (en) | Protocol-independent SOA system and method for processing business | |
| CN104052626A (en) | Method, device and system for configuring network element data | |
| CN115840745A (en) | Scheduling method and device based on dynamic form, computer equipment and storage medium | |
| US9009652B2 (en) | Method and system for handling software design conflicts | |
| CN104144210A (en) | Method and system for automatically building data service | |
| CN107609109A (en) | A kind of report form generation method, device and system | |
| CN104270446A (en) | Enterprise management system integration method based on user selection | |
| CN112395339B (en) | Intersystem data admission verification method, device, computer equipment and storage medium | |
| CN107491298A (en) | A kind of button object automatic scanning method and system | |
| CN109542432A (en) | Air control rule editing method and terminal device | |
| CN103019819A (en) | Dynamic link library uniform scheduling method based on plug-in mechanism |
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: 20190118 |
|
| RJ01 | Rejection of invention patent application after publication |