CN108228551A - Data lead-in method, device, equipment and the computer readable storage medium of excel - Google Patents
Data lead-in method, device, equipment and the computer readable storage medium of excel Download PDFInfo
- Publication number
- CN108228551A CN108228551A CN201810016130.2A CN201810016130A CN108228551A CN 108228551 A CN108228551 A CN 108228551A CN 201810016130 A CN201810016130 A CN 201810016130A CN 108228551 A CN108228551 A CN 108228551A
- Authority
- CN
- China
- Prior art keywords
- data
- excel
- drop
- field information
- list
- 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 OR CALCULATING; 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
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/186—Templates
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 embodiment of the present invention provides a kind of data lead-in method of excel, device, equipment and computer readable storage medium, this method and includes：Excel files are created in webpage, the excel files include excel template files and pre-set dictionary table；The drop-down list of the default cell of the excel template files, the data source of the drop-down list and data queueing discipline is configured, wherein, the data source of the drop-down list is directed toward the pre-set dictionary table；If user is received from the download instruction of the page download excel template files, from each extracting data preset field information in the data list of the webpage, wherein, the data list includes a plurality of data, and a plurality of data include the field information of same type；The preset field information is stored in pre-set dictionary table；The preset field information in the pre-set dictionary table is imported into the corresponding drop-down list of the excel template files according to the data arrangement rule.The present invention is convenient for the management and operation of excel data.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of data lead-in method of excel, device, equipment and
Computer readable storage medium.
Background technology
Excel softwares have the function of powerful, are commonly used to data management at present, have to user and greatly facilitate.Mesh
Before for, the data of excel are typically filled in manually, and the problem of some are difficult to understand data are being will appear during filling in；
In addition, for same enterprise, can often be shown in many cases using a general excel template with same format
Or the data of content, when the form of data or content slight variation, it is only necessary to corresponding adjustment is done to general excel templates i.e.
Can, the amplitude of adjustment will not be too big, and only data format often changes primary or data content and often increases once with regard to needing to repair
Change primary general excel files, particularly when a content is there are many that may can be chosen, if manually adjusted, can increase
Add workload and the difficulty of maintenance.
Invention content
An embodiment of the present invention provides a kind of data lead-in method of excel, device, equipment and computer-readable storage mediums
Matter, convenient for the management and operation of excel data.
In a first aspect, an embodiment of the present invention provides a kind of data lead-in method of excel, this method includes：
Excel files are created in webpage, the excel files include excel template files and pre-set dictionary table；
Be configured the drop-down list of the default cell of the excel template files, the data source of the drop-down list and
Data arrangement rule, wherein, the data source of the drop-down list is directed toward the pre-set dictionary table；
If receiving user from the download instruction of the page download excel template files, arranged from the data of the webpage
Each extracting data preset field information in table, wherein, the data list includes a plurality of data, a plurality of data
Include the field information of same type；
The preset field information is stored in pre-set dictionary table；
The preset field information in the pre-set dictionary table is imported into the excel according to the data arrangement rule
The corresponding drop-down list of template file.
Second aspect, the embodiment of the present invention additionally provide a kind of data importing device of excel, which includes holding
The unit of the data lead-in method of the above-mentioned excel of row.
The third aspect, the data that the embodiment of the present invention additionally provides a kind of excel import equipment, and the equipment includes storage
Device and the processor being connected with the memory；
The memory, for storing the program data for the data lead-in method for realizing excel；
The processor, for running the program data stored in the memory, to perform such as above-mentioned first aspect institute
The method stated.
Fourth aspect, an embodiment of the present invention provides a kind of computer readable storage medium, the computer-readable storage
There are one either more than one program data the one or more programs data can be by one or one for media storage
A above processor performs, to realize the method described in above-mentioned first aspect.
The embodiment of the present invention provides a kind of data lead-in method of excel, device, equipment and computer-readable storage medium
Matter, this method include：Excel files are created in webpage, the excel files include excel template files and pre-set dictionary
Table；The drop-down list of the default cell of the excel template files, the data source of the drop-down list and data row is configured
Row rule, wherein, the data source of the drop-down list is directed toward the pre-set dictionary table；If user is received under the webpage
The download instruction of excel template files is carried, from each extracting data preset field letter in the data list of the webpage
Breath, wherein, the data list includes a plurality of data, and a plurality of data include the field information of same type；By described in
Preset field information is stored in pre-set dictionary table；By the preset field information in the pre-set dictionary table according to the data
Queueing discipline imports the corresponding drop-down list of the excel template files.By implementing technical scheme of the present invention, for identical
Type but the different field of particular content and user can carry out content according to different situations the scene that uses of selection, automatically will
Multiple options of drop-down list imported into excel template files, it is not necessary to be manually entered, reduce workload, data management has spirit
Activity.
Description of the drawings
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, the accompanying drawings in the following description is some embodiments of the present invention, general for this field
For logical technical staff, without creative efforts, other attached drawings are can also be obtained according to these attached drawings.
Fig. 1 is a kind of flow diagram of the data lead-in method of excel provided in an embodiment of the present invention；
Fig. 2 is a kind of sub-process schematic diagram of the data lead-in method of excel provided in an embodiment of the present invention；
Fig. 3 is a kind of another sub-process schematic diagram of the data lead-in method of excel provided in an embodiment of the present invention；
Fig. 4 is a kind of another flow diagram of the data lead-in method of excel provided in an embodiment of the present invention；
Fig. 5 is a kind of cellular construction schematic block diagram of the data importing device of excel provided in an embodiment of the present invention；
Fig. 6 is a kind of sub-unit structure schematic block diagram of the data importing device of excel provided in an embodiment of the present invention；
Fig. 7 is a kind of another cellular construction schematic block diagram of the data importing device of excel provided in an embodiment of the present invention；
Fig. 8 is that the data of excel provided in an embodiment of the present invention a kind of import the schematic block diagram of equipment.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present invention, the technical solution in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is part of the embodiment of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, the every other implementation that those of ordinary skill in the art are obtained without making creative work
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 " comprising " 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, element, component and/or its presence or addition gathered.
It is also understood that the term "and/or" used in description of the invention and the appended claims refer to it is related
Join any combinations and all possible combinations of one or more of the item listed, and including these combinations.
It will also be understood that although term first, second etc. can be used for describing various elements herein, these elements should not
This is limited to these terms, these terms are only used for these elements being distinguished from each other out.
Fig. 1 is a kind of flow diagram of the data lead-in method of excel provided in an embodiment of the present invention.This method can be with
It operates in smart machine, such as tablet computer, laptop and intelligent terminal.As shown in Figure 1, the step of this method, wraps
Include S101~S105.
S101, creates excel files in webpage, and the excel files include excel template files and pre-set dictionary
Table.
The purpose of the embodiment of the present invention is that the certain type of information in the data list of webpage is directed into excel tables
In, using excel tables as a template file, i.e. excel template files, for user's browsing or fill data.
Webpage has the function of establishment excel using bottom.An excel file, the foundation are created in webpage
Excel files include at least two excel tables, and an excel template file that can be made as excel templates, one is pre-
If dictionary table, while the effect of pre-set dictionary table is the middleware that storage needs the source data for being directed into excel template files.
The drop-down list of the default cell of the excel template files is configured in S102, the data of the drop-down list are come
Source and data queueing discipline, wherein, the data source of the drop-down list is directed toward the pre-set dictionary table.
It is that required lattice are configured in specific cell in the excel template files after excel files are created
Formula, such as the data source of drop-down list, drop-down list and data queueing discipline, wherein, the data source of the drop-down list
The pre-set dictionary table is directed toward, the data source for specifically including the drop-down list of which column unit lattice is directed toward in pre-set dictionary table
Which region (which column unit etc.), the data of the corresponding region are finally directed to the drop-down list of corresponding cell
In.
Furthermore it is also possible to for the cell configuration format in pre-set dictionary table, for example, data source of its cell etc..
S103, if user is received from the download instruction of the page download excel template files, from the number of the webpage
According to each extracting data preset field information in list, wherein, the data list includes a plurality of data, described a plurality of
Data include the field information of same type.
The excel template files are not supported directly to beat in the web page as an excel table in web application layer
Open browsing, there are one the download buttons for downloading excel template files in webpage, if user wants to browse this document content, need
The excel template files are downloaded, the excel template files after download are no different with common excel tables, and user can open
The excel tables browse table content, and the content of excel tables can also be changed according to the wish of oneself.
It may include one or more data lists in webpage, different data lists preserves different types of data, one
Data list preserves a type of data, each data list is comprising a plurality of data, the data format one per data
Sample, a data include several different fields, are distinguish with field name.Such as Tables 1 and 2, the data in table 1 are silver
The information of row type, data are related to all kinds of bank informations and are made of several different fields, and gauge outfit is the title of field, including
Bank Name and bank describe two types, and each data includes these fields, but the Bank Name of different a datas
Difference, bank's description content according to circumstances depending on.Data in table 2 are the information of loan transaction type, and each data include
Loan transaction title and whether need the two kinds of field of guaranty.
Table 1
| Serial number | Bank Name | Bank describes |
| 1 | Minsheng bank | Minsheng bank |
| 2 | Agricultural bank | Agricultural bank |
| 3 | Safety bank | Safety bank |
| 4 | Standard Chartered Bank | Overseas bank |
Table 2
| Serial number | Loan transaction title | Whether guaranty is needed |
| 1 | Proficiency building mortgage loan | It is |
| 2 | Second-hand building mortgage loan | It is |
| 3 | Loan on personal security | It is no |
Because certain business demand is (for example, user when handling loan transaction, can select therein one from several banks
It is a, a certain loan transaction can be selected from several loan transactions), needing will be needed for data each in data list
Field information imported into the drop-down list of excel table cells, it is therefore desirable to arrange these field informations from corresponding data
The extracting data of table comes out, and the information extracted is stored in the preset region of pre-set dictionary table.For example, developer presets
The type of preset field information in table 1 is Bank Name, and the type of the preset field information in preset table 2 is loan transaction class
Type, stage extract each Bank Name from each data of table 1, will be various from each data of table 2
Loan transaction type-collection comes out.
In embodiments of the present invention, the number of the data list included in webpage is one or more.If only 1 data
List then extracts the preset field information in the data class table, if with multiple data lists, successively from each institute
State the preset field information of each extracting data corresponding types of data list.
The preset field information is stored in pre-set dictionary table by S104.
Preset region can preserve the preset field information extracted from data list in pre-set dictionary table, for example,
Specifically preset which column unit lattice is used for preserving extracting from which (if multiple) data list of webpage
Field information.
If the number of the data list included in webpage is 1, step S104 is specifically included：The preset field is believed
Breath is stored in the default column unit lattice of the pre-set dictionary table by the sequence in the data list.It can in default column unit lattice
For any one column unit lattice in pre-set dictionary table.
If the number of the data list included in webpage is multiple, step S104 is specifically included：By same data list
Preset field information be stored in preset same column in the pre-set dictionary table successively by the sequence in the data list
Cell, the preset field information of different data list is stored in the unit of preset different lines in the pre-set dictionary table
Lattice.
S105, by the preset field information in the pre-set dictionary table according to described in data arrangement rule importing
The corresponding drop-down list of excel template files.
System developer has preset the field information for needing to extract, i.e. preset field information when writing program,
Triggering system extraction data after the download instruction for downloading excel template files are sent out in user, finally according to setting
Form imports these data in excel template files, completes the importing of excel data.
Specifically, if the number of the data list included in webpage is 1, a row of the excel template files created
Cell is provided with drop-down list, and the data source of the drop-down list is directed toward the default column unit lattice of preset field information, such as
Shown in Fig. 2, step S105 includes sub-step S1051a and S1052a.
S1051a reads the preset field information from the default column unit lattice in the pre-set dictionary table.
S1052a is arranged the preset field information by each drop-down that is sequentially introduced into the default column unit lattice
Table, and show in the corresponding cell of each drop-down list the preset field information of the first sequence.
It is different lines in the excel template files of establishment if the number of the data list included in webpage is multiple
Cell sets drop-down list, and the data source of the drop-down list of different lines cell is respectively directed in the pre-set dictionary table in advance
If for preserving column unit lattice of different type presupposed information, as shown in figure 3, step S105 include sub-step S1051b and
S1052b。
S1051b reads predetermined word from a column unit lattice corresponding with the drop-down list in the pre-set dictionary table
Segment information.
The preset field information is imported corresponding drop-down by S1052b by putting in order in the pre-set dictionary table
In list, and show in the corresponding cell of the drop-down list preset field information of the first sequence.
For example, pre-set in excel template files the wherein the 1st to the drop-down list of N column unit lattice data source
The 1st of the pre-set dictionary table is respectively directed to N column unit lattice, the 1st of pre-set dictionary table is respectively intended to preserve to N column unit lattice
From first data list of webpage, second data list ... ..., corresponding first preset field in n-th data list
Information, the second preset field information ... ..., N preset field information, when user downloads the excel file templates, by first
Preset field information is directed into the drop-down list of the 1st column unit lattice of excel template files, and the second preset field information is imported
To the drop-down list ... ... of the 2nd column unit lattice of excel template files, N preset field information is directed into excel templates
The drop-down list of the Nth column cell of file.
The data lead-in method of excel through the embodiment of the present invention, for same type but the different word of particular content
Section and user can carry out content according to different situations the use scene of selection, automatically import corresponding field information option
Excel file unit lattice drop-down list is alternatively selected for user, it is not necessary to is manually entered one by one, be reduced workload, save behaviour
Make the time；For the data being stored directly in web data list, it is introduced directly into when needing in excel template files, it can be just
In the management and operation of data；In addition, because of the data in web data list, developer can change at any time, therefore excel
Data configurability and flexibility in template file is high.
In other embodiments, as shown in figure 4, the data lead-in method of the excel further includes step S106：By described in
Excel template files are preserved to designated position.
When user sends out the download instruction for downloading excel template files, selection is needed to preserve the guarantor of the excel template files
Approach, i.e. designated position are deposited, this document is successfully stored in designated position after download excel template files, after download, Yong Huke
Browse and change the data content in the excel template files.
Fig. 5 is a kind of schematic block diagram of the data importing device 100 of excel provided in an embodiment of the present invention.The excel
Data importing device 100 include creating unit 101, dispensing unit 102, receiving unit 103, extraction unit 104, first preserve
Unit 105 and import unit 106.
Creating unit 101 be used in webpage create excel files, the excel files include excel template files and
Pre-set dictionary table.
Dispensing unit 102 is used to that the drop-down list of the default cell of the excel template files, the drop-down row to be configured
The data source of table and data queueing discipline, wherein, the data source of the drop-down list is directed toward the pre-set dictionary table.
Receiving unit 103 is used to receive user from the download instruction of the page download excel template files.
Extraction unit 104 is used for from each extracting data preset field information in the data list of the webpage,
Wherein, the data list includes a plurality of data, and a plurality of data include the field information of same type.
If the number of the data list is multiple, the different data lists preserve different types of field information, then
Extraction unit 104 is specifically additionally operable to：Successively from the default of each extracting data corresponding types of each data list
Field information.
First storage unit 105 is used to the preset field information being stored in pre-set dictionary table.
In embodiments of the present invention, if the number of the data list is 1, first storage unit 105 is specifically used
In：The preset field information is stored in the default column unit of the pre-set dictionary table by the sequence in the data list
Lattice.
If the number of the data list is multiple, first storage unit 105 is specifically used for：
The preset field information of same data list is stored in by the sequence in the data list successively described pre-
If the cell of preset same column in dictionary table, the preset field information of different data list is stored in the pre-set dictionary
The cell of preset different lines in table.
Import unit 106 is used to advise the preset field information in the pre-set dictionary table according to the data arrangement
Then import the corresponding drop-down list of the excel template files.
As shown in fig. 6, the import unit 106 includes reading subunit 1061, imports subelement 1062 and shows that son is single
Member 1063.
In embodiments of the present invention, if the number of the data list is 1, the drop-down list includes a column unit
The drop-down list of lattice, the data source of the drop-down list are directed toward the default column unit lattice.
Then reading subunit 1061 is described pre- for being read from the default column unit lattice in the pre-set dictionary table
If field information；Subelement 1062 is imported for the preset field information to be led by the sequence in the default column unit lattice
Enter each drop-down list, display subelement 1063 is used for the first sequence of display in the corresponding cell of each drop-down list
Preset field information.
If the number of the data list is multiple, the drop-down list includes the drop-down list of different lines cell,
The data source of the drop-down list of different lines cell is respectively directed to preset for preserving inhomogeneity in the pre-set dictionary table
One column unit lattice of type presupposed information.
Then reading subunit 1061 is used for from a column unit corresponding with the drop-down list in the pre-set dictionary table
Preset field information is read in lattice；Subelement 1062 is imported to be used to press the preset field information in the pre-set dictionary table
Put in order and be directed into corresponding drop-down list, display subelement 1063 is used in the corresponding cell of the drop-down list
The preset field information of the first sequence of middle display.
As shown in fig. 7, the data importing device 100 of the excel further includes the second storage unit 107, described second protects
Memory cell 107 is used to preserve the excel template files to designated position.
The specific descriptions of each unit can refer to above method embodiment in the embodiment of the present invention, and the embodiment of the present invention is not done
It repeats.
The data importing device 100 of above-mentioned excel can be implemented as a kind of form of computer program, and computer program can
To be run on computer equipment as shown in Figure 8.
Fig. 8 is that the data of excel provided in an embodiment of the present invention a kind of import the schematic block diagram of equipment.The equipment can be with
It is terminal or server, wherein, terminal can be smart mobile phone, tablet computer, laptop, desktop computer, a
Personal digital assistant and Wearable etc. have the electronic equipment of communication function.Server can be independent server, also may be used
To be server cluster that multiple servers form.
The equipment is a kind of computer equipment 200, including the processor 202, non-volatile connected by system bus 201
Storage medium 203, built-in storage 204 and network interface 205.Wherein, the non-volatile memory medium of the computer equipment 200
203 can storage program area 2031 and computer program 2032, which is performed, and may be such that processor
202 perform a kind of data lead-in method of excel.The processor 202 of the computer equipment 200 calculates and controls energy for providing
Power supports the operation of entire computer equipment 200.The built-in storage 204 is the computer journey in non-volatile memory medium 203
The operation of sequence 2032 provides environment, when which is performed by processor 202, may be such that processor 202 performs one
The data lead-in method of kind excel.The network interface 205 of computer equipment 200 is for carrying out network communication, as sent and distributed
Task dispatching.It will be understood by those skilled in the art that the structure shown in Fig. 8, only part knot relevant with application scheme
The block diagram of structure does not form the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
It can include either combining certain components than components more or fewer shown in figure or be arranged with different components.
Processor 202 runs the computer program 2032 in non-volatile memory medium 203, performs following operation：
Excel files are created in webpage, the excel files include excel template files and pre-set dictionary table；Configuration
The drop-down list of the default cell of the excel template files, the data source of the drop-down list and data queueing discipline,
Wherein, the data source of the drop-down list is directed toward the pre-set dictionary table；User is received from the page download excel templates
The download instruction of file；From each extracting data preset field information in the data list of the webpage, wherein, it is described
Data list includes a plurality of data, and a plurality of data include the field information of same type；By the preset field information
It is stored in pre-set dictionary table；The preset field information in the pre-set dictionary table is imported according to the data arrangement rule
The corresponding drop-down list of the excel template files.
Processor 202 also performs following operation：
The excel template files are preserved to designated position.
The number of the data list is 1, and the drop-down list includes the drop-down list of a column unit lattice, the drop-down
The data source of list is directed toward the default column unit lattice, then processor 202 also performs following operation：
The preset field information is stored in the default of the pre-set dictionary table by the sequence in the data list
Column unit lattice；The preset field information is read from the default column unit lattice in the pre-set dictionary table；It will be described pre-
If field information is by each drop-down list that is sequentially introduced into the default column unit lattice, and in each drop-down list pair
The preset field information of the first sequence is shown in the cell answered.
The number of the data list is multiple, and the different data lists preserve different types of field information, described
Drop-down list includes the drop-down list of different lines cell, and the data source of the drop-down list of different lines cell is respectively directed to institute
The preset column unit lattice for being used to preserve different type presupposed information in pre-set dictionary table are stated, then processor 202 also performs such as
Lower operation：
Successively from the preset field information of each extracting data corresponding types of each data list；It will be same
The preset field information of data list is stored in by the sequence in the data list in the pre-set dictionary table and preset successively
Same column cell, the preset field information of different data list is stored in preset difference in the pre-set dictionary table
The cell of row；Preset field letter is read from a column unit lattice corresponding with the drop-down list in the pre-set dictionary table
Breath；The preset field information is directed by putting in order in the pre-set dictionary table in corresponding drop-down list, and
The preset field information of the first sequence is shown in the corresponding cell of the drop-down list.
It will be understood by those skilled in the art that the embodiment that the data of the excel shown in Fig. 8 import equipment is not formed
The restriction of equipment specific composition is imported to the data of excel, in other embodiments, the data of excel, which import equipment, to wrap
It includes and either combines certain components or different components arrangement than illustrating more or fewer components.For example, in some implementations
In example, the data of excel, which import equipment, can only include memory and processor, in such embodiments, memory and place
Structure and the function for managing device are consistent with embodiment illustrated in fig. 8, and details are not described herein.
The present invention also provides a kind of computer readable storage medium, the computer-readable recording medium storage there are one or
More than one program of person, the one or more programs can be performed by one or more than one processor, with reality
Existing following steps：
Excel files are created in webpage, the excel files include excel template files and pre-set dictionary table；Configuration
The drop-down list of the default cell of the excel template files, the data source of the drop-down list and data queueing discipline,
Wherein, the data source of the drop-down list is directed toward the pre-set dictionary table；User is received from the page download excel templates
The download instruction of file；From each extracting data preset field information in the data list of the webpage, wherein, it is described
Data list includes a plurality of data, and a plurality of data include the field information of same type；By the preset field information
It is stored in pre-set dictionary table；The preset field information in the pre-set dictionary table is imported according to the data arrangement rule
The corresponding drop-down list of the excel template files.
Also realize following steps：
The excel template files are preserved to designated position.
The number of the data list is 1, and the drop-down list includes the drop-down list of a column unit lattice, the drop-down
The data source of list is directed toward the default column unit lattice, then also realizes following steps：
The preset field information is stored in the default of the pre-set dictionary table by the sequence in the data list
Column unit lattice；The preset field information is read from the default column unit lattice in the pre-set dictionary table；It will be described pre-
If field information is by each drop-down list that is sequentially introduced into the default column unit lattice, and in each drop-down list pair
The preset field information of the first sequence is shown in the cell answered.
The number of the data list is multiple, and the different data lists preserve different types of field information, described
Drop-down list includes the drop-down list of different lines cell, and the data source of the drop-down list of different lines cell is respectively directed to institute
The preset column unit lattice for being used to preserve different type presupposed information in pre-set dictionary table are stated, then also realize following steps：
Successively from the preset field information of each extracting data corresponding types of each data list；It will be same
The preset field information of data list is stored in by the sequence in the data list in the pre-set dictionary table and preset successively
Same column cell, the preset field information of different data list is stored in preset difference in the pre-set dictionary table
The cell of row；Preset field letter is read from a column unit lattice corresponding with the drop-down list in the pre-set dictionary table
Breath；The preset field information is directed by putting in order in the pre-set dictionary table in corresponding drop-down list, and
The preset field information of the first sequence is shown in the corresponding cell of the drop-down list.
The computer readable storage medium can be the internal storage unit of aforementioned device, such as the hard disk of equipment or interior
It deposits.The computer readable storage medium can also be what is be equipped on the External memory equipment of the equipment, such as the equipment
Plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card dodge
Deposit card (Flash Card) etc..Further, the computer readable storage medium can also both include the inside of the equipment
Storage unit also includes External memory equipment.
It is apparent to those skilled in the art that for convenience of description and succinctly, foregoing description is set
The specific work process of standby, device and unit can refer to the corresponding process in preceding method embodiment, and details are not described herein.
Those of ordinary skill in the art may realize that each exemplary units and algorithm described with reference to the embodiments described herein
Step can be realized with the combination of electronic hardware, computer software or the two, in order to clearly demonstrate hardware and software
Interchangeability generally describes each exemplary composition and step according to function in the above description.These functions are studied carefully
Unexpectedly specific application and design constraint depending on technical solution are performed with hardware or software mode.Professional technician
Described function can be realized using distinct methods to each specific application, but this realization is it is not considered that exceed
The scope of the present invention.
In several embodiments provided herein, it should be understood that disclosed unit and method, it can be with
It realizes by another way.For example, the apparatus embodiments described above are merely exemplary, for example, the unit
It divides, only a kind of division of logic function can have other dividing mode, can also will have identical work(in actual implementation
Can unit set into a unit, such as multiple units or component may be combined or can be integrated into another system or
Some features can be ignored or does not perform.In addition, shown or discussed mutual coupling or direct-coupling or communication link
Connect can be by the INDIRECT COUPLING of some interfaces, device or unit or communication connection or electricity, it is mechanical or other
Form connection.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
The component shown may or may not be physical unit, you can be located at a place or can also be distributed to multiple
In network element.Some or all of unit therein can be selected according to the actual needs to realize the embodiment of the present invention
Purpose.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
It is that each unit is individually physically present or two or more units integrate in a unit.It is above-mentioned integrated
The form that hardware had both may be used in unit is realized, can also be realized in the form of SFU software functional unit.
If the integrated unit is realized in the form of SFU software functional unit and is independent product sale or uses
When, it can be stored in a computer readable storage medium.Based on such understanding, technical scheme of the present invention substantially or
Person say the part contribute to the prior art or the technical solution all or part can in the form of software product body
Reveal and, which is stored in a storage medium, including some instructions with so that a computer is set
Standby (can be personal computer, server or the network equipment etc.) performs the whole of each embodiment the method for the present invention
Or part steps.And aforementioned storage medium includes：USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only
Memory), the various media that can store program code such as magnetic disc or CD.
The above description is merely a specific embodiment, but protection scope 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 domain subject to.
Claims (10)
1. a kind of data lead-in method of excel, which is characterized in that including：
Excel files are created in webpage, the excel files include excel template files and pre-set dictionary table；
The drop-down list of the default cell of the excel template files, the data source and data of the drop-down list is configured
Queueing discipline, wherein, the data source of the drop-down list is directed toward the pre-set dictionary table；
If user is received from the download instruction of the page download excel template files, from the data list of the webpage
Each extracting data preset field information, wherein, the data list includes a plurality of data, and a plurality of data wrap
Include the field information of same type；
The preset field information is stored in pre-set dictionary table；
The preset field information in the pre-set dictionary table is imported into the excel templates according to the data arrangement rule
The corresponding drop-down list of file.
2. the data lead-in method of excel according to claim 1, which is characterized in that described by the pre-set dictionary table
In the preset field information according to the data arrangement rule import the corresponding drop-down list of the excel template files it
Afterwards, it further includes：
The excel template files are preserved to designated position.
3. the data lead-in method of excel according to claim 1, the number of the data list is 1；
It is described that the preset field information is stored in pre-set dictionary table, including：
The preset field information is stored in the default list of the pre-set dictionary table by the sequence in the data list
First lattice.
4. the data lead-in method of excel according to claim 3, the drop-down list includes the drop-down of a column unit lattice
List, the data source of the drop-down list are directed toward the default column unit lattice；
The preset field information by the pre-set dictionary table imports the excel according to the data arrangement rule
The corresponding drop-down list of template file, including：
The preset field information is read from the default column unit lattice in the pre-set dictionary table；
By the preset field information by each drop-down list that is sequentially introduced into the default column unit lattice, and in each institute
State the preset field information that the first sequence is shown in the corresponding cell of drop-down list.
5. the data lead-in method of excel according to claim 1, the number of the data list be it is multiple, it is different
The data list preserves different types of field information；
Each extracting data preset field information from the data list of the webpage, including：
Successively from the preset field information of each extracting data corresponding types of each data list.
6. the data lead-in method of excel according to claim 5, which is characterized in that described to believe the preset field
Breath is stored in pre-set dictionary table, including：
The preset field information of same data list is stored in the predetermined word successively by the sequence in the data list
The preset field information of different data list is stored in the pre-set dictionary table by the cell of preset same column in allusion quotation table
The cell of preset different lines.
7. the data lead-in method of excel according to claim 6, which is characterized in that the drop-down list includes difference
The drop-down list of column unit lattice, the data source of the drop-down list of different lines cell are respectively directed in the pre-set dictionary table in advance
If for preserving column unit lattice of different type presupposed information；
The preset field information by the pre-set dictionary table imports the excel according to the data arrangement rule
The corresponding drop-down list of template file, including：
Preset field information is read from a column unit lattice corresponding with the drop-down list in the pre-set dictionary table；
The preset field information is directed by putting in order in the pre-set dictionary table in corresponding drop-down list, and
The preset field information of the first sequence is shown in the corresponding cell of the drop-down list.
8. a kind of data importing device of excel, which is characterized in that performed as described in claim any one of 1-7 including being used for
Excel data lead-in method unit.
9. the data of excel a kind of import equipment, which is characterized in that the equipment include memory and with the memory
Connected processor；
The memory imports program data for storing the data of excel；
The processor, for running the program data stored in the memory, to perform such as any one of claim 1-7 institutes
The method stated.
10. a kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage there are one or
More than one program data, the one or more programs data can be held by one or more than one processor
Row, to realize method as described in any one of claim 1 to 7.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810016130.2A CN108228551B (en) | 2018-01-08 | 2018-01-08 | excel data import method, device, equipment and computer readable storage medium |
| PCT/CN2018/077146 WO2019134225A1 (en) | 2018-01-08 | 2018-02-24 | Excel data import method, apparatus and device, and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810016130.2A CN108228551B (en) | 2018-01-08 | 2018-01-08 | excel data import method, device, equipment and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108228551A true CN108228551A (en) | 2018-06-29 |
| CN108228551B CN108228551B (en) | 2021-02-05 |
Family
ID=62640186
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810016130.2A Active CN108228551B (en) | 2018-01-08 | 2018-01-08 | excel data import method, device, equipment and computer readable storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108228551B (en) |
| WO (1) | WO2019134225A1 (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109117468A (en) * | 2018-08-01 | 2019-01-01 | 北京数字雷暴信息科技有限公司 | A kind of data processing method and device |
| CN109740136A (en) * | 2018-12-19 | 2019-05-10 | 北京达佳互联信息技术有限公司 | Web data introduction method, device, electronic equipment and storage medium |
| CN109857662A (en) * | 2019-01-25 | 2019-06-07 | 浙江数链科技有限公司 | Case data processing method, device, computer equipment and storage medium |
| CN112800730A (en) * | 2021-01-28 | 2021-05-14 | 中国工商银行股份有限公司 | Report form filling method and device |
| CN112949266A (en) * | 2019-12-11 | 2021-06-11 | 珠海金山办公软件有限公司 | Electronic form processing method, processing device, electronic equipment and storage medium |
| CN115934716A (en) * | 2022-12-02 | 2023-04-07 | 山东浪潮智慧医疗科技有限公司 | A Method of Importing Excel Table Data into Database Based on Metadata Definition and Realization |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115757184A (en) * | 2022-12-06 | 2023-03-07 | 招银云创信息技术有限公司 | Test case management method and related equipment |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management system and method |
| US20160026377A1 (en) * | 2014-07-22 | 2016-01-28 | Posiba, Inc. | System and method for collecting, curating, aggregating, and displaying metrics data from and to stakeholders in the charitable sector |
| CN105808939A (en) * | 2016-03-04 | 2016-07-27 | 新博卓畅技术（北京）有限公司 | Data rule engine system and method |
| CN106202013A (en) * | 2016-06-25 | 2016-12-07 | 国云科技股份有限公司 | A kind of implementation method of webpage version EXCEL |
| CN107480262A (en) * | 2017-08-05 | 2017-12-15 | 中山大学 | A kind of general management system of database based on webpage |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105843788A (en) * | 2016-03-31 | 2016-08-10 | 浪潮通信信息系统有限公司 | Report generation method and device |
-
2018
- 2018-01-08 CN CN201810016130.2A patent/CN108228551B/en active Active
- 2018-02-24 WO PCT/CN2018/077146 patent/WO2019134225A1/en not_active Ceased
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management system and method |
| US20160026377A1 (en) * | 2014-07-22 | 2016-01-28 | Posiba, Inc. | System and method for collecting, curating, aggregating, and displaying metrics data from and to stakeholders in the charitable sector |
| CN105808939A (en) * | 2016-03-04 | 2016-07-27 | 新博卓畅技术（北京）有限公司 | Data rule engine system and method |
| CN106202013A (en) * | 2016-06-25 | 2016-12-07 | 国云科技股份有限公司 | A kind of implementation method of webpage version EXCEL |
| CN107480262A (en) * | 2017-08-05 | 2017-12-15 | 中山大学 | A kind of general management system of database based on webpage |
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 |
| CN109740136A (en) * | 2018-12-19 | 2019-05-10 | 北京达佳互联信息技术有限公司 | Web data introduction method, device, electronic equipment and storage medium |
| CN109740136B (en) * | 2018-12-19 | 2024-02-09 | 北京达佳互联信息技术有限公司 | Webpage data importing method and device, electronic equipment and storage medium |
| CN109857662A (en) * | 2019-01-25 | 2019-06-07 | 浙江数链科技有限公司 | Case data processing method, device, computer equipment and storage medium |
| CN109857662B (en) * | 2019-01-25 | 2022-09-27 | 浙江数链科技有限公司 | Use case data processing method and device, computer equipment and storage medium |
| CN112949266A (en) * | 2019-12-11 | 2021-06-11 | 珠海金山办公软件有限公司 | Electronic form processing method, processing device, electronic equipment and storage medium |
| CN112949266B (en) * | 2019-12-11 | 2024-06-25 | 珠海金山办公软件有限公司 | Electronic form processing method, electronic form processing device, electronic equipment and storage medium |
| CN112800730A (en) * | 2021-01-28 | 2021-05-14 | 中国工商银行股份有限公司 | Report form filling method and device |
| CN115934716A (en) * | 2022-12-02 | 2023-04-07 | 山东浪潮智慧医疗科技有限公司 | A Method of Importing Excel Table Data into Database Based on Metadata Definition and Realization |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019134225A1 (en) | 2019-07-11 |
| CN108228551B (en) | 2021-02-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228551A (en) | Data lead-in method, device, equipment and the computer readable storage medium of excel | |
| CN109191090A (en) | Means of payment recommended method, device, equipment and computer readable storage medium | |
| CN106202358A (en) | A kind of method recommending application program and terminal | |
| CN107391626A (en) | Land the creation method and device of page | |
| CN107797826A (en) | A kind of regular collocation method, terminal and the equipment of rule-based engine | |
| CN108170654A (en) | A kind of electronic forms editing device and its development approach | |
| CN107665464B (en) | Method, device and equipment for generating credit investigation message and computer readable storage medium | |
| CN107678789A (en) | The update method and device at UI interfaces | |
| CN108897525A (en) | Test data generating method, device, computer equipment and storage medium | |
| CN109324859A (en) | Book cover replacing options, electronic equipment and computer storage medium | |
| CN108874738A (en) | Distributed parallel operation method, device, computer equipment and storage medium | |
| CN106777398A (en) | The generation method and device of a kind of csv file | |
| CN107818512A (en) | Produce method, apparatus, equipment and the computer-readable recording medium of declaration form certification | |
| CN109726020A (en) | System docking method, system docking equipment, storage medium and device | |
| CN112329412A (en) | Method and device for dynamic control of table column based on front-end technology | |
| CN109408092A (en) | Method and device, storage medium and the electronic equipment of front end version publication | |
| CN108446371A (en) | Data return guiding method, device, computer equipment and storage medium | |
| CN104267975B (en) | A kind of processing method and device of expanded application data, card | |
| CN109144952A (en) | Believe and examines rule file dissemination method, device and storage medium | |
| CN108536864A (en) | Page numeric displaying method, device, computer equipment and storage medium | |
| CN104994493B (en) | A kind of method that system of real name is opened an account, robot and system | |
| CN105306686A (en) | Information processing method and electronic equipment | |
| CN107547614A (en) | The Numerical Methods and device of investment platform | |
| CN108805521A (en) | Survey tasks processing method, device, computer equipment and storage medium | |
| CN109766313A (en) | Geological project data processing method, device and computer equipment |
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 |