CN108228551B - excel data import method, device, equipment and computer readable storage medium - Google Patents
excel data import method, device, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN108228551B CN108228551B CN201810016130.2A CN201810016130A CN108228551B CN 108228551 B CN108228551 B CN 108228551B CN 201810016130 A CN201810016130 A CN 201810016130A CN 108228551 B CN108228551 B CN 108228551B
- Authority
- CN
- China
- Prior art keywords
- data
- preset
- excel
- field information
- dictionary table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
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 invention provides a data import method, a data import device, excel data import equipment and a computer readable storage medium, wherein the method comprises the following steps: creating an excel file in a webpage, wherein the excel file comprises an excel template file and a preset dictionary table; configuring a drop-down list of preset cells of the excel template file, a data source of the drop-down list and a data arrangement rule, wherein the data source of the drop-down list points to the preset dictionary table; if a downloading instruction of a user for downloading an excel template file from the webpage is received, extracting preset field information from each piece of data in a data list of the webpage, wherein the data list comprises a plurality of pieces of data, and the plurality of pieces of data all comprise field information of the same type; storing the preset field information in a preset dictionary table; and importing the preset field information in the preset dictionary table into a pull-down list corresponding to the excel template file according to the data arrangement rule. The method and the device are convenient for management and operation of excel data.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a data import method, a data import device, data import equipment and a computer readable storage medium for excel.
Background
Excel software has powerful functions, is generally used for data management at present, and is greatly convenient for users. At present, excel data is usually filled manually, and some problem data which are difficult to read can occur in the filling process; in addition, for the same enterprise, in many cases, data with the same format or content can be displayed by using a universal excel template, when the format or content of the data is slightly changed, only corresponding adjustment needs to be performed on the universal excel template, the adjustment amplitude is not too large, only the universal excel file needs to be modified once the data format is changed or once the data content is increased, and particularly when a variety of contents can be selected, the workload and the maintenance difficulty can be increased if manual adjustment is performed.
Disclosure of Invention
The embodiment of the invention provides a method, a device and equipment for importing excel data and a computer readable storage medium, which are convenient for management and operation of excel data.
In a first aspect, an embodiment of the present invention provides a data import method for excel, where the method includes:
creating an excel file in a webpage, wherein the excel file comprises an excel template file and a preset dictionary table;
configuring a drop-down list of preset cells of the excel template file, a data source of the drop-down list and a data arrangement rule, wherein the data source of the drop-down list points to the preset dictionary table;
if a downloading instruction of a user for downloading an excel template file from the webpage is received, extracting preset field information from each piece of data in a data list of the webpage, wherein the data list comprises a plurality of pieces of data, and the plurality of pieces of data all comprise field information of the same type;
storing the preset field information in a preset dictionary table;
and importing the preset field information in the preset dictionary table into a pull-down list corresponding to the excel template file according to the data arrangement rule.
In a second aspect, an embodiment of the present invention further provides an excel data import apparatus, where the apparatus includes a unit configured to execute the excel data import method.
In a third aspect, an embodiment of the present invention further provides an excel data importing apparatus, where the apparatus includes a memory and a processor connected to the memory;
the memory is used for storing program data for realizing the data import method of the excel;
the processor is configured to execute the program data stored in the memory to perform the method according to the first aspect.
In a fourth aspect, embodiments of the present invention provide a computer-readable storage medium storing one or more program data, which can be executed by one or more processors to implement the method of the first aspect.
The embodiment of the invention provides a data import method, a data import device, excel data import equipment and a computer readable storage medium, wherein the method comprises the following steps: creating an excel file in a webpage, wherein the excel file comprises an excel template file and a preset dictionary table; configuring a drop-down list of preset cells of the excel template file, a data source of the drop-down list and a data arrangement rule, wherein the data source of the drop-down list points to the preset dictionary table; if a downloading instruction of a user for downloading an excel template file from the webpage is received, extracting preset field information from each piece of data in a data list of the webpage, wherein the data list comprises a plurality of pieces of data, and the plurality of pieces of data all comprise field information of the same type; storing the preset field information in a preset dictionary table; and importing the preset field information in the preset dictionary table into a pull-down list corresponding to the excel template file according to the data arrangement rule. By implementing the technical scheme of the invention, for the fields with the same type but different specific contents and the use situation that the user can select the contents according to different conditions, a plurality of options of the drop-down list are automatically imported into the excel template file, manual input is not needed, the workload is reduced, and the data management has flexibility.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic flowchart of a data import method of excel according to an embodiment of the present invention;
fig. 2 is a schematic sub-flow diagram of a data import method of excel according to an embodiment of the present invention;
FIG. 3 is another schematic sub-flow diagram of a data import method of excel according to an embodiment of the present invention;
fig. 4 is another schematic flowchart of a data import method of excel according to an embodiment of the present invention;
fig. 5 is a schematic block diagram of a cell structure of an excel data import apparatus according to an embodiment of the present invention;
fig. 6 is a schematic block diagram of a subunit structure of an excel data import apparatus according to an embodiment of the present invention;
fig. 7 is a schematic block diagram of another cell structure of an excel data import apparatus according to an embodiment of the present invention;
fig. 8 is a schematic block diagram of an excel data import device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It should also be understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.
It will also be understood that, although the terms first, second, etc. may be used herein to describe various elements, these elements should not be limited by these terms, which are used merely to distinguish one element from another.
Fig. 1 is a schematic flow chart of a data importing method of excel according to an embodiment of the present invention. The method can be operated in intelligent equipment such as a tablet computer, a notebook computer and an intelligent terminal. As shown in fig. 1, the steps of the method include S101 to S105.
S101, creating an excel file in a webpage, wherein the excel file comprises an excel template file and a preset dictionary table.
The embodiment of the invention aims to import certain type of information in a data list of a webpage into an excel form, and the excel form is used as a template file, namely an excel template file, so that a user can browse or fill in data.
The application bottom layer of the webpage has the function of creating excel. The method comprises the steps of creating an excel file in a webpage, wherein the created excel file comprises at least two excel forms, one excel template file capable of being made into an excel template, and the other excel template file is a preset dictionary form, and the preset dictionary form is used for storing middleware of source data needing to be imported into the excel template file.
S102, configuring a drop-down list of preset cells of the excel template file, a data source of the drop-down list and a data arrangement rule, wherein the data source of the drop-down list points to the preset dictionary table.
After the excel file is created, configuring a required format, such as a drop-down list, a data source of the drop-down list and a data arrangement rule, for a specific cell in the excel template file, wherein the data source of the drop-down list points to the preset dictionary table, specifically, the data source of the drop-down list of which cell points to which region (which column of cells and the like) in the preset dictionary table, and the data of the corresponding region is finally imported into the drop-down list of the corresponding cell.
In addition, the format can also be configured for the cells in the preset dictionary table, for example, the data sources of the cells, and the like.
S103, if a downloading instruction of a user for downloading the excel template file from the webpage is received, extracting preset field information from each piece of data in a data list of the webpage, wherein the data list comprises a plurality of pieces of data, and the plurality of pieces of data all comprise field information of the same type.
The excel template file is used as an excel form in a webpage application layer, direct opening and browsing in the webpage are not supported, a download button for downloading the excel template file is arranged in the webpage, if a user wants to browse the file content, the excel template file needs to be downloaded, the downloaded excel template file is not different from a common excel form, the user can open the excel form to browse the form content, and the content of the excel form can be modified according to own will.
The web page can contain one or more data lists, different data lists store different types of data, one data list stores one type of data, each data list contains a plurality of pieces of data, the data format of each piece of data is the same, and one piece of data comprises a plurality of different fields which are distinguished by field names. For example, table 1 and table 2, the data in table 1 is information of a bank type, the data relates to various types of bank information and is composed of several different fields, the header of the table is a name of the field, the two types include a bank name and a bank description, each piece of data includes the fields, but the bank name of different pieces of data is different, and the bank description content is determined according to the situation. The data in table 2 is information on the type of loan transaction, and each piece of data includes fields of both the name of the loan transaction and whether mortgage is required.
TABLE 1
| Serial number | Name of bank | Description of the Bank |
| 1 | Civil bank | Civil bank |
| 2 | Agricultural bank | Agricultural bank |
| 3 | Safe bank | Safe bank |
| 4 | Banking bank | Foreign bank |
TABLE 2
| Serial number | Name of loan transaction | Whether or not mortgage is required |
| 1 | Hand-lift loan on stairs | Is that |
| 2 | Second-hand building mortgage loan | Is that |
| 3 | Personal credit loan | Whether or not |
Due to a certain service requirement (for example, when a user transacts a loan service, the user may select one of several banks, and may select a loan service from several loan services), field information required in each piece of data in the data list needs to be imported into a pull-down list of an excel table cell, and therefore, the field information needs to be extracted from the data of the corresponding data list, and the extracted information is stored in a preset area of a preset dictionary table. For example, the developer presets the type of the preset field information in table 1 as a bank name, the type of the preset field information in table 2 as a loan transaction type, and extracts the bank name from each piece of data in table 1 and extracts the loan transaction types from each piece of data in table 2 in the later period.
In the embodiment of the present invention, the number of the data lists included in the web page is 1 or more. If only 1 data list exists, extracting preset field information in the data type list, and if a plurality of data lists exist, sequentially extracting corresponding types of preset field information from each piece of data in each data list.
And S104, storing the preset field information in a preset dictionary table.
The predetermined area in the predetermined dictionary table may hold predetermined field information extracted from the data list, for example, which column of cells is predetermined to hold field information extracted from which (if any) data list of the web page.
If the number of the data lists contained in the web page is 1, step S104 specifically includes: and storing the preset field information in a preset column cell of the preset dictionary table according to the sequence in the data list. The preset column of cells may be any column of cells in the preset dictionary table.
If the number of the data lists included in the web page is multiple, step S104 specifically includes: and sequentially storing preset field information of the same data list in the preset cells in the same column in the preset dictionary table according to the sequence in the data list, and storing the preset field information of different data lists in the preset cells in different columns in the preset dictionary table.
And S105, importing the preset field information in the preset dictionary table into a pull-down list corresponding to the excel template file according to the data arrangement rule.
The method comprises the steps that a system developer presets field information needing to be extracted when a program is written, namely the field information is preset, after a user sends a downloading instruction for downloading an excel template file, the system is triggered to extract data, and finally the data are led into the excel template file according to a preset format, so that the leading-in of the excel data is completed.
Specifically, if the number of the data lists contained in the web page is 1, a column of cells of the created excel template file is provided with a drop-down list, and a data source of the drop-down list points to a preset column of cells of the preset field information, as shown in fig. 2, step S105 includes substeps S1051a and S1052 a.
S1051a, reading the preset field information from the preset column cells in the preset dictionary table.
S1052a, importing the preset field information into each drop-down list according to the order in the preset column cells, and displaying the preset field information in the first order in the cell corresponding to each drop-down list.
If the number of the data lists included in the web page is multiple, drop-down lists are set for different columns of cells in the created excel template file, and data sources of the drop-down lists of different columns of cells point to a column of cells preset in the preset dictionary table for storing different types of preset information, as shown in fig. 3, step S105 includes substeps S1051b and S1052 b.
S1051b, reading preset field information from a list of cells in the preset dictionary table corresponding to the pull-down list.
S1052b, importing the preset field information into a corresponding pull-down list according to the arrangement order in the preset dictionary table, and displaying the preset field information in a first order in the cells corresponding to the pull-down list.
For example, the data sources of the drop-down lists of the 1 st to N th columns of cells in the excel template file are preset to point to the 1 st to N th columns of cells in the preset dictionary table, the 1 st to N th columns of cells in the preset dictionary table are used for storing the first data list, the second data list, … …, the corresponding first preset field information, the second preset field information, … … and the nth preset field information in the nth data list, respectively, when the user downloads the excel file template, the first preset field information is imported to the drop-down list of the 1 st column of cells in the excel template file, the second preset field information is imported to the drop-down list of the 2 nd column of cells in the excel template file, … …, and the nth preset field information is imported to the drop-down list of the nth column of cells in the excel template file.
According to the excel data import method, for the fields of the same type but different specific contents and the use situation that a user can select the contents according to different conditions, the corresponding field information options are automatically imported into the excel file cell drop-down list to be used as options for the user to select, manual input is not needed, the workload is reduced, and the operation time is saved; for data directly stored in the webpage data list, the data are directly imported into an excel template file as required, so that the data can be conveniently managed and operated; in addition, because the data in the webpage data list can be changed by developers at any time, the configurability and the flexibility of the data in the excel template file are high.
In other embodiments, as shown in fig. 4, the excel data importing method further includes step S106: and saving the excel template file to a specified position.
When a user sends a downloading instruction for downloading the excel template file, a storage way for storing the excel template file, namely a designated position, needs to be selected, the file is stored at the designated position after the excel template file is successfully downloaded, and the user can browse and modify the data content in the excel template file after downloading.
Fig. 5 is a schematic block diagram of an excel data import apparatus 100 according to an embodiment of the present invention. The excel data import apparatus 100 includes a creation unit 101, a configuration unit 102, a reception unit 103, an extraction unit 104, a first saving unit 105, and an import unit 106.
The creating unit 101 is configured to create an excel file in a web page, where the excel file includes an excel template file and a preset dictionary table.
The configuration unit 102 is configured to configure a drop-down list of preset cells of the excel template file, a data source of the drop-down list, and a data arrangement rule, where the data source of the drop-down list points to the preset dictionary table.
The receiving unit 103 is configured to receive a download instruction of a user to download an excel template file from the web page.
The extracting unit 104 is configured to extract preset field information from each piece of data in a data list of the web page, where the data list includes multiple pieces of data, and the multiple pieces of data all include field information of the same type.
If the number of the data lists is multiple, and different types of field information are stored in different data lists, the extracting unit 104 is further specifically configured to: and sequentially extracting preset field information of corresponding types from each piece of data of each data list.
The first saving unit 105 is configured to save the preset field information in a preset dictionary table.
In this embodiment of the present invention, if the number of the data lists is 1, the first saving unit 105 is specifically configured to: and storing the preset field information in a preset column cell of the preset dictionary table according to the sequence in the data list.
If the number of the data lists is multiple, the first saving unit 105 is specifically configured to:
and sequentially storing preset field information of the same data list in the preset cells in the same column in the preset dictionary table according to the sequence in the data list, and storing the preset field information of different data lists in the preset cells in different columns in the preset dictionary table.
The importing unit 106 is configured to import the preset field information in the preset dictionary table into the pull-down list corresponding to the excel template file according to the data arrangement rule.
As shown in fig. 6, the import unit 106 includes a reading sub-unit 1061, an import sub-unit 1062, and a display sub-unit 1063.
In the embodiment of the present invention, if the number of the data lists is 1, the pull-down list includes a pull-down list of a row of cells, and a data source of the pull-down list points to the preset row of cells.
The reading sub-unit 1061 is configured to read the preset field information from the preset column cell in the preset dictionary table; the importing subunit 1062 is configured to import the preset field information into each drop-down list according to the order in the preset column cells, and the displaying subunit 1063 is configured to display the preset field information in the first order in the cell corresponding to each drop-down list.
If the number of the data lists is multiple, the drop-down list comprises drop-down lists of different columns of cells, and data sources of the drop-down lists of different columns of cells respectively point to a column of cells preset in the preset dictionary table and used for storing different types of preset information.
The reading sub-unit 1061 is configured to read preset field information from a column of cells in the preset dictionary table corresponding to the pull-down list; the importing subunit 1062 is configured to import the preset field information into the corresponding drop-down list according to the arrangement order in the preset dictionary table, and the displaying subunit 1063 is configured to display the preset field information in the first order in the cell corresponding to the drop-down list.
As shown in fig. 7, the excel data import apparatus 100 further includes a second saving unit 107, where the second saving unit 107 is configured to save the excel template file to a specified location.
For the detailed description of each unit in the embodiments of the present invention, reference may be made to the above method embodiments, and details are not repeated in the embodiments of the present invention.
The data importing apparatus 100 of the excel may be implemented in the form of a computer program, and the computer program may be run on a computer device as shown in fig. 8.
Fig. 8 is a schematic block diagram of an excel data import device according to an embodiment of the present invention. The device can be a terminal or a server, wherein the terminal can be an electronic device with a communication function, such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a personal digital assistant and a wearable device. The server may be an independent server or a server cluster composed of a plurality of servers.
The apparatus is a computer apparatus 200 comprising a processor 202, a non-volatile storage medium 203, an internal memory 204 and a network interface 205 connected by a system bus 201. The non-volatile storage medium 203 of the computer device 200 may store an operating system 2031 and a computer program 2032, wherein the computer program 2032, when executed, may cause the processor 202 to execute an excel data import method. The processor 202 of the computer device 200 is used to provide computing and control capabilities that support the operation of the overall computer device 200. The internal memory 204 provides an environment for the operation of the computer program 2032 in the non-volatile storage medium 203, and when the computer program 2032 is executed by the processor 202, the processor 202 can be caused to execute an excel data import method. The network interface 205 of the computer device 200 is used for network communication such as sending assigned tasks and the like. Those skilled in the art will appreciate that the architecture shown in fig. 8 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
The processor 202 runs the computer program 2032 in the non-volatile storage medium 203 and performs the following operations:
creating an excel file in a webpage, wherein the excel file comprises an excel template file and a preset dictionary table; configuring a drop-down list of preset cells of the excel template file, a data source of the drop-down list and a data arrangement rule, wherein the data source of the drop-down list points to the preset dictionary table; receiving a downloading instruction of a user for downloading an excel template file from the webpage; extracting preset field information from each piece of data in a data list of the webpage, wherein the data list comprises a plurality of pieces of data, and the plurality of pieces of data comprise field information of the same type; storing the preset field information in a preset dictionary table; and importing the preset field information in the preset dictionary table into a pull-down list corresponding to the excel template file according to the data arrangement rule.
and saving the excel template file to a specified position.
If the number of the data lists is 1, the pull-down list includes a pull-down list of a row of cells, and a data source of the pull-down list points to the preset row of cells, then the processor 202 further performs the following operations:
storing the preset field information in a preset column cell of the preset dictionary table according to the sequence in the data list; reading the preset field information from the preset column cells in the preset dictionary table; and importing the preset field information into each drop-down list according to the sequence in the preset column cells, and displaying the preset field information in the first sequence in the cells corresponding to each drop-down list.
The number of the data lists is multiple, different data lists store different types of field information, the pull-down list includes pull-down lists of different columns of cells, data sources of the pull-down lists of different columns of cells respectively point to a column of cells preset in the preset dictionary table and used for storing different types of preset information, and then the processor 202 further performs the following operations:
sequentially extracting preset field information of corresponding types from each piece of data of each data list; sequentially storing preset field information of the same data list in the preset cells of the same column in the preset dictionary table according to the sequence in the data list, and storing the preset field information of different data lists in the preset cells of different columns in the preset dictionary table; reading preset field information from a column of cells corresponding to the drop-down list in the preset dictionary table; and importing the preset field information into a corresponding drop-down list according to the arrangement sequence in the preset dictionary table, and displaying the preset field information in a first sequence in the cells corresponding to the drop-down list.
Those skilled in the art can understand that the embodiment of the excel data import apparatus shown in fig. 8 does not constitute a limitation to the specific configuration of the excel data import apparatus, and in other embodiments, the excel data import apparatus may include more or less components than those shown in the figure, or combine some components, or arrange different components. For example, in some embodiments, the data importing apparatus of excel may only include a memory and a processor, and in such embodiments, the structures and functions of the memory and the processor are consistent with those of the embodiment shown in fig. 8, and are not described herein again.
The present invention also provides a computer readable storage medium storing one or more programs, the one or more programs being executable by one or more processors to perform the steps of:
creating an excel file in a webpage, wherein the excel file comprises an excel template file and a preset dictionary table; configuring a drop-down list of preset cells of the excel template file, a data source of the drop-down list and a data arrangement rule, wherein the data source of the drop-down list points to the preset dictionary table; receiving a downloading instruction of a user for downloading an excel template file from the webpage; extracting preset field information from each piece of data in a data list of the webpage, wherein the data list comprises a plurality of pieces of data, and the plurality of pieces of data comprise field information of the same type; storing the preset field information in a preset dictionary table; and importing the preset field information in the preset dictionary table into a pull-down list corresponding to the excel template file according to the data arrangement rule.
The following steps are also implemented:
and saving the excel template file to a specified position.
The number of the data lists is 1, the pull-down list comprises a pull-down list of a row of cells, and the data source of the pull-down list points to the preset row of cells, so that the following steps are further realized:
storing the preset field information in a preset column cell of the preset dictionary table according to the sequence in the data list; reading the preset field information from the preset column cells in the preset dictionary table; and importing the preset field information into each drop-down list according to the sequence in the preset column cells, and displaying the preset field information in the first sequence in the cells corresponding to each drop-down list.
The number of the data lists is multiple, different data lists store different types of field information, the pull-down list comprises pull-down lists with different columns of cells, data sources of the pull-down lists with different columns of cells respectively point to a column of cells preset in the preset dictionary table and used for storing different types of preset information, and then the following steps are further realized:
sequentially extracting preset field information of corresponding types from each piece of data of each data list; sequentially storing preset field information of the same data list in the preset cells of the same column in the preset dictionary table according to the sequence in the data list, and storing the preset field information of different data lists in the preset cells of different columns in the preset dictionary table; reading preset field information from a column of cells corresponding to the drop-down list in the preset dictionary table; and importing the preset field information into a corresponding drop-down list according to the arrangement sequence in the preset dictionary table, and displaying the preset field information in a first sequence in the cells corresponding to the drop-down list.
The computer readable storage medium may be an internal storage unit of the aforementioned device, such as a hard disk or a memory of the device. The computer readable storage medium may also be an external storage device of the device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), etc. provided on the device. Further, the computer-readable storage medium may also include both an internal storage unit and an external storage device of the apparatus.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses, devices and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again. Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of illustrating clearly the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus, device and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and there may be other divisions in actual implementation, or units with the same function may be grouped into one unit, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may also be an electric, mechanical or other form of connection.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention essentially or partially contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a magnetic disk, or an optical disk.
While the invention has been described with reference to specific embodiments, the invention is not limited thereto, and various equivalent modifications and substitutions can be easily made by those skilled in the art within the technical scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (7)
1. A data import method of excel is characterized by comprising the following steps:
creating an excel file in a webpage, wherein the excel file comprises an excel template file and a preset dictionary table;
configuring a drop-down list of preset cells of the excel template file, a data source of the drop-down list and a data arrangement rule, wherein the data source of the drop-down list points to the preset dictionary table;
if a downloading instruction of a user for downloading an excel template file from the webpage is received, extracting preset field information from each piece of data in a data list of the webpage, wherein the data list comprises a plurality of pieces of data, and the plurality of pieces of data all comprise field information of the same type;
storing the preset field information in a preset dictionary table;
importing the preset field information in the preset dictionary table into a pull-down list corresponding to the excel template file according to the data arrangement rule;
the step of creating the excel file in the webpage comprises the following steps:
creating an excel file in an application layer of a webpage through an application bottom layer of the webpage, wherein the excel file comprises two excel forms, one excel template file is an excel template, and the other excel template file is a preset dictionary table;
the number of the data lists is 1; the storing the preset field information in a preset dictionary table includes:
storing the preset field information in a preset column cell of the preset dictionary table according to the sequence in the data list;
the number of the data lists is multiple, and different types of field information are stored in different data lists;
the extracting preset field information from each piece of data in the data list of the webpage includes:
sequentially extracting preset field information of corresponding types from each piece of data of each data list;
the storing the preset field information in a preset dictionary table includes:
and sequentially storing preset field information of the same data list in the preset cells in the same column in the preset dictionary table according to the sequence in the data list, and storing the preset field information of different data lists in the preset cells in different columns in the preset dictionary table.
2. The excel data import method according to claim 1, wherein after importing the preset field information in the preset dictionary table into the pull-down list corresponding to the excel template file according to the data arrangement rule, the method further comprises:
and saving the excel template file to a specified position.
3. The excel data import method according to claim 1, wherein the drop-down list comprises a drop-down list of a column of cells, and a data source of the drop-down list points to the preset column of cells;
the importing the preset field information in the preset dictionary table into the pull-down list corresponding to the excel template file according to the data arrangement rule comprises the following steps:
reading the preset field information from the preset column cells in the preset dictionary table;
and importing the preset field information into each drop-down list according to the sequence in the preset column cells, and displaying the preset field information in the first sequence in the cells corresponding to each drop-down list.
4. The excel data import method according to claim 1, wherein the drop-down list comprises drop-down lists of different columns of cells, and data sources of the drop-down lists of different columns of cells point to a column of cells preset in the preset dictionary table for storing different types of preset information, respectively;
the importing the preset field information in the preset dictionary table into the pull-down list corresponding to the excel template file according to the data arrangement rule comprises the following steps:
reading preset field information from a column of cells corresponding to the drop-down list in the preset dictionary table;
and importing the preset field information into a corresponding drop-down list according to the arrangement sequence in the preset dictionary table, and displaying the preset field information in a first sequence in the cells corresponding to the drop-down list.
5. An excel data import apparatus comprising means for executing the excel data import method according to any one of claims 1 to 4.
6. The excel data import equipment is characterized by comprising a memory and a processor connected with the memory;
the memory is used for storing data import program data of excel;
the processor for executing program data stored in the memory to perform the method of any one of claims 1-4.
7. A computer-readable storage medium, storing one or more program data, the one or more program data being executable by one or more processors to implement the method of any one of claims 1 to 4.
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 CN108228551A (en) | 2018-06-29 |
| CN108228551B true 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) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109117468A (en) * | 2018-08-01 | 2019-01-01 | 北京数字雷暴信息科技有限公司 | A kind of data processing method and device |
| CN109740136B (en) * | 2018-12-19 | 2024-02-09 | 北京达佳互联信息技术有限公司 | Webpage data importing method and device, electronic equipment and storage medium |
| CN109857662B (en) * | 2019-01-25 | 2022-09-27 | 浙江数链科技有限公司 | Use case data processing method and device, computer 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 |
| CN115757184A (en) * | 2022-12-06 | 2023-03-07 | 招银云创信息技术有限公司 | Test case management method and related equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management 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 (4)
| 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 |
| 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 |
| 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 (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019134225A1 (en) | 2019-07-11 |
| CN108228551A (en) | 2018-06-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228551B (en) | excel data import method, device, equipment and computer readable storage medium | |
| CN109656807B (en) | Information security-based interface mock testing method, device, equipment and storage medium | |
| CN107656914B (en) | Configurable table generation method and device, terminal equipment and storage medium | |
| US20150293764A1 (en) | Method and system to compose and execute business rules | |
| CA2831381C (en) | Recovery of tenant data across tenant moves | |
| US20140136955A1 (en) | Hybrid Web Container for Cross-Platform Mobile Applications | |
| US20150220245A1 (en) | Branded computer devices and apparatus to connect user and enterprise | |
| CN111736825B (en) | Information display method, device, equipment and storage medium | |
| CN111445299A (en) | Invoice issuing method and equipment | |
| US10747943B2 (en) | Method, device, client apparatus, and electronic device for presenting webpages | |
| CN108776587B (en) | Data acquisition method and device, computer equipment and storage medium | |
| US10782857B2 (en) | Adaptive user interface | |
| CN108733370B (en) | Stylized display method, device, terminal and storage medium of native APP | |
| CN104320387A (en) | Local module customizing method, terminal and server | |
| CN111782210B (en) | Page management method, device, electronic equipment and computer readable medium | |
| CN116719456A (en) | Icon style switching method and device, electronic equipment and storage medium | |
| CN113407254B (en) | Form generation method and device, electronic equipment and storage medium | |
| CN113761415B (en) | Page display method and device | |
| CN110597585A (en) | Application page display method, device, computer equipment and storage medium | |
| CN112308539B (en) | Communication service opening method and server | |
| CN113656033A (en) | List page generation method, apparatus, device, medium, and program product | |
| CN109799987A (en) | Financial product data processing method, system, computer equipment and storage medium | |
| CN107015795A (en) | A kind of method and device for drawing user interface | |
| CN113448960A (en) | Method and device for importing form file | |
| CN102184112B (en) | Control upgrade method and device |
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 |