Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
EXCEL DATA IMPORT METHOD, APPARATUS AND DEVICE, AND COMPUTER READABLE STORAGE MEDIUM
Document Type and Number:
WIPO Patent Application WO/2019/134225
Kind Code:
A1
Abstract:
Embodiments of the present application provide an excel data import method, apparatus and device, and a computer readable storage medium. The method comprises: creating an excel file in a webpage, the excel file comprising an excel template file and a preset dictionary table; configuring a drop-down list of preset cells of the excel template file, and a data source and a data arrangement rule of the drop-down list, wherein the data source of the drop-down list points to the preset dictionary table; if a download instruction of downloading the excel template file from the webpage sent by a user 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 comprises the same type of field information; storing the preset field information in the preset dictionary table; and importing the preset field information in the preset dictionary table into the drop-down list corresponding to the excel template file according to the data arrangement rule. The present application facilitates the management and operation on excel data.

Inventors:
LONG, Juegang (6F Ping an Building, Bagua 3rd Road Bagualing, Futian Distric, Shenzhen Guangdong 0, 518000, CN)
SUN, Cheng (6F Ping an Building, Bagua 3rd Road Bagualing, Futian Distric, Shenzhen Guangdong 0, 518000, CN)
YE, Junfeng (6F Ping an Building, Bagua 3rd Road Bagualing, Futian Distric, Shenzhen Guangdong 0, 518000, CN)
LAI, Yunhui (6F Ping an Building, Bagua 3rd Road Bagualing, Futian Distric, Shenzhen Guangdong 0, 518000, CN)
LUO, Xianxian (6F Ping an Building, Bagua 3rd Road Bagualing, Futian Distric, Shenzhen Guangdong 0, 518000, CN)
Application Number:
CN2018/077146
Publication Date:
July 11, 2019
Filing Date:
February 24, 2018
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
PING AN TECHNOLOGY (SHENZHEN) CO., LTD. (6F Ping an Building, Bagua 3rd Road Bagualing, Futian Distric, Shenzhen Guangdong 0, 518000, CN)
International Classes:
G06F17/24
Attorney, Agent or Firm:
SHENZHEN TALENT PATENT SERVICE (B 20/F, Building B Lvjing Square 6009 Shennan Middle Road, Futian Distric, Shenzhen Guangdong 0, 518000, CN)
Download PDF: