Processing method for excel data in java and cloud data interaction method

A processing method and data technology, applied in the direction of software design, etc., can solve the problems that the data interaction method cannot meet the requirements well, readability, architecture impact, low efficiency, etc.

Inactive Publication Date: 2018-04-20
政采云有限公司
View PDF9 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It is very redundant to use, and there are repeated codes everywhere, which has an impact on the framework, readability, and architecture.
[0004] Existing e-commerce platforms can only generate orders or process orders based on a single user operation, which is inefficient. Users often need to export excel documents to improve the efficiency of data update, but the data interaction methods of existing e-commerce platforms cannot well meet the requirements

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
  • Processing method for excel data in java and cloud data interaction method
  • Processing method for excel data in java and cloud data interaction method
  • Processing method for excel data in java and cloud data interaction method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Such as figure 1 and figure 2 As shown, the meaning in the figure is as follows:

[0024] Excelparse: Import and analyze the core class, which is responsible for obtaining the data flow from the file and parsing the data into the corresponding business-related domain objects.

[0025] Java bean: domain object, which is a domain object tightly coupled with business.

[0026] Excelfield: Import annotations, instead of using xml configuration, and use annotations to indicate data validation rules and the mapping relationship between attributes and rows.

[0027] Xlsexport: export core class, responsible for exporting domain objects to excel. For example, generate various reports.

[0028] Excelexportfield: Export annotations, responsible for defining export data display rules.

[0029] Such as figure 1 As shown, use the underlying core class to read the data stream of the Excel document; configure the mapping relationship between the domain object and the excel data...

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 discloses a processing method for excel data in java and a cloud data interaction method suitable for an e-commerce platform. The processing method mainly comprises checking the legalityof excel data after the excel file data is read; if the excel data is legal, converting the excel data into a service field object; and if the excel data is not legal, returning the position of a data validation rule that does not meet, and pointing out the violated rule. The data interaction method mainly includes that a supply end device uploads an excel file of a provided product to a cloud server; correspondingly, a purchase end device uploads an excel file of the required product to the cloud server, and the cloud server adopts the processing method to analyze the excel file and derivesa excel data in a java object according to service requirements to the supply end device and the purchase end device. The processing method for excel data in java and the cloud data interaction methodsuitable for the e-commerce platform have the advantages that the processing method for excel data enhances readability and ease of use of a program and the cloud data interaction method improves data interaction efficiency.

Description

technical field [0001] The invention relates to a processing method and a cloud data interaction method, in particular to a processing method for excel data in java and a cloud data interaction method suitable for an e-commerce platform. Background technique [0002] There are two packages for java, jxl and poi. Encapsulate the excel data, and encapsulate the elements of excel for java use, such as style (color, thickness), cell (row height, column width). The way to use it is to get the data stream first, specify the loop mode to read or write, and then save the output. Loop patterns can be highly abstract. [0003] The existing defect is that it is very cumbersome to use, and it is not object-oriented, but data-oriented. Didn't keep up with the trend of supporting annotation configuration. It is very redundant to use, and there are repeated codes everywhere, which has an impact on the framework, readability, and architecture. [0004] Existing e-commerce platforms can...

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): G06F8/20
CPCG06F8/24
Inventor 倪建峰赵玉珍
Owner 政采云有限公司
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