Unlock instant, AI-driven research and patent intelligence for your innovation.

Excel data import method, device, equipment and computer-readable storage medium

A data import and data technology, applied in the computer field, can solve problems such as increasing the difficulty of workload maintenance

Active Publication Date: 2021-02-05
PING AN TECH (SHENZHEN) CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, excel data is usually filled in manually, and some difficult-to-interpret problem data will appear during the filling process; in addition, for the same enterprise, in many cases, a common excel template can often be used to display the data with the same format or content. When the format or content of the data changes slightly, you only need to make corresponding adjustments to the general excel template, and the adjustment range will not be too large, but it needs to be modified every time the data format is changed or the data content is added. A common excel file, especially when there are multiple possibilities for a content to be selected, if manually adjusted, it will increase the workload and the difficulty of maintenance

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Excel data import method, device, equipment and computer-readable storage medium
  • Excel data import method, device, equipment and computer-readable storage medium
  • Excel data import method, device, equipment and computer-readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0026] It should be understood that when used in this specification and the appended claims, the terms "comprising" and "comprises" indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude one or Presence or addition of multiple other features, integers, steps, operations, elements, components and / or collections thereof.

[0027] It should also be understood that the term "and / or" use...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Embodiments of the present invention provide an excel data import method, device, device, and computer-readable storage medium. The method includes: creating an excel file in a web page, where the excel file includes an excel template file and a preset dictionary table; configuring all The drop-down list of preset cells in the excel template file, the data source and data arrangement rule of the drop-down list, wherein, the data source of the drop-down list points to the preset dictionary table; The download instruction for downloading the excel template file, extracting preset field information from each piece of data in the data list of the webpage, wherein the data list includes multiple pieces of data, and the multiple pieces of data all include the same type of field information ; save the preset field information in a preset dictionary table; import the preset field information in the preset dictionary table into a drop-down list corresponding to the excel template file according to the data arrangement rule. The present invention facilitates the management and operation of excel data.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to an excel data import method, device, equipment and computer-readable storage medium. Background technique [0002] Excel software has powerful functions and is currently widely used for data management, which is very convenient for users. At present, excel data is usually filled in manually, and some difficult-to-interpret problem data will appear during the filling process; in addition, for the same enterprise, in many cases, a common excel template can often be used to display the data with the same format or content. When the format or content of the data changes slightly, you only need to make corresponding adjustments to the general excel template, and the adjustment range will not be too large, but it needs to be modified every time the data format is changed or the data content is added. A common excel file, especially when there are multiple possibilities for a...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F40/186G06F40/18
CPCG06F40/18G06F40/186
Inventor 龙觉刚孙成叶俊锋赖云辉罗先贤
Owner PING AN TECH (SHENZHEN) CO LTD