Method and device for generating diagram based on Excel

An excel and chart technology, applied in the field of generating charts based on Excel

Active Publication Date: 2013-09-04
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
View PDF2 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Users often want to use charts to display Excel data to intuitively reflect data rules, but for Excel content in complex formats, users sometimes want to generate charts based on only part of the data, and existing technologies cannot solve this problem

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
  • Method and device for generating diagram based on Excel
  • Method and device for generating diagram based on Excel
  • Method and device for generating diagram based on Excel

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] The present invention will be described in detail below in conjunction with specific embodiments and accompanying drawings.

[0040] The present invention uses some characteristic information of the content in Excel, such as keywords or the number of rows and columns to locate the content that the user is interested in, and generates a chart accordingly. Embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0041] Please refer to figure 1 , which is a flowchart of an embodiment of the present invention, may include the following steps:

[0042] Step 101: read configuration information, if read successfully, go to step 102, otherwise, go to step 107;

[0043] The configuration information includes keywords or the number of rows and columns set by the user, and is stored in a storage and readable medium, such as a database or a file.

[0044] Step 102: determine whether the keyword exists, if it exists, ...

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 method and device for generating a diagram based on Excel. The method includes the following steps that configuration information is read, wherein the configuration information comprises keywords; when the keywords exist, positions of required data are located in the Excel according to the keywords, the data in the Excel are read from the located positions, and the diagram is generated according to the read data. The keywords are utilized to conduct locating, therefore, the data at any position in the Excel can be located according to requirements of users, then the diagram of the expected data is generated, flexibility is high, and dynamic configuration is achieved.

Description

technical field [0001] The invention relates to electronic form processing technology, in particular to a method and device for generating charts based on Excel. Background technique [0002] Excel can perform various data processing and statistical analysis, and is widely used in many fields such as management, statistics, finance, and finance. Users often want to use charts to display Excel data to intuitively reflect data rules, but for Excel content in complex formats, users sometimes want to generate charts based on only part of the data, and the existing technology cannot solve this problem. Contents of the invention [0003] The invention provides a method and device for generating graphs based on Excel, so as to realize generating graphs according to data in any position of Excel. [0004] A method for generating charts based on Excel, said method comprising: [0005] Read configuration information, where the configuration information includes keywords; [0006]...

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): G06F17/24G06F17/30
Inventor 常翔翔
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH 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