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 (CN)
SUN CHENG (CN)
YE JUNFENG (CN)
LAI YUNHUI (CN)
LUO XIANXIAN (CN)
SUN CHENG (CN)
YE JUNFENG (CN)
LAI YUNHUI (CN)
LUO XIANXIAN (CN)
Application Number:
PCT/CN2018/077146
Publication Date:
July 11, 2019
Filing Date:
February 24, 2018
Export Citation:
Assignee:
PING AN TECH SHENZHEN CO LTD (CN)
International Classes:
G06F17/24
Foreign References:
| CN101650712A | 2010-02-17 | |||
| CN105808939A | 2016-07-27 | |||
| CN105843788A | 2016-08-10 | |||
| US20160026377A1 | 2016-01-28 |
Attorney, Agent or Firm:
SHENZHEN TALENT PATENT SERVICE (CN)
Download PDF: