Excel data import method and device, computer device and storage medium

A technology of excel and computer programs, applied in the import of Excel data, computer equipment and storage media, can solve the problems of low efficiency of manual entry, achieve the effect of improving import efficiency, avoiding errors, and improving accuracy

Inactive Publication Date: 2019-05-21
BIZGO TECH (CHINA) CO LTD
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Based on this, it is necessary to provide an import method, device, computer equipment and storage medium that can automatically import offline data into online Excel data for the above-mentioned problem of low manual entry efficiency when offline data is transferred to online

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 and device, computer device and storage medium
  • Excel data import method and device, computer device and storage medium
  • Excel data import method and device, computer device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0035] The embodiment of this application provides a method for importing Excel data, such as figure 1 As shown, the method may include the following steps:

[0036] Step 102, identifying the version of the Excel file to be imported.

[0037] It should be noted that there are currently two versions of the Excel file, and the file formats corresponding to the two versions are different. For example, before Office2007 (excluding Office2007), Excel files stored data in binary format, and its file extension was usually "xls". Starting from Office2007 (including Office2007),...

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

The invention relates to an Excel data import method and device, a computer device and a storage medium. The method comprises: the version of an Excel file to be imported is recognized; determining acorresponding processing mode according to the version of the Excel file to be imported; converting the to-be-imported Excel file into a corresponding business object according to the determined processing mode; and importing the converted business object; according to the embodiment of the invention, the version of the Excel file to be imported is identified; determining a corresponding processing mode according to the version of the Excel file to be imported, the to-be-imported Excel file is converted into a corresponding business object according to the determined processing mode; accordingto the data importing method and the data importing device, the offline Excel file is automatically imported into the online system when the offline data is transferred to the online system, so thatthe data importing efficiency is improved, errors caused by manually inputting the data are avoided, and the data importing accuracy is improved.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to an Excel data import method, device, computer equipment and storage medium. Background technique [0002] With the development of Internet technology, the application of various management systems is becoming more and more extensive. Every enterprise faces the problem of transferring offline data to an online management system when applying a management system. At present, offline data is generally recorded through Excel, but because Excel files cannot be directly operated by other management systems, the data in Excel files cannot be directly imported into the management system. [0003] At present, offline data is generally transferred to online through manual entry, but due to the low efficiency of manual entry, it seriously affects the normal use of the management system. Contents of the invention [0004] Based on this, it is necessary to provide an import me...

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 Applications(China)
IPC IPC(8): G06F16/25
CPCG06F16/25
Inventor 车光爱翁浦益初旭
Owner BIZGO TECH (CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap