Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Excel annotation-based report generation method

A report generation and excel technology, applied in the direction of parser generation, creation/generation of source code, program control device, etc., can solve the problems of cumbersome reports and the inability of users to make their own, and achieve wide applicability, simple modification, and convenient operation Effect

Active Publication Date: 2016-08-24
SHANGHAI MUNICIPAL ELECTRIC POWER CO +1
View PDF2 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For developers, it is often a very cumbersome task to make various reports for many customers, because at present, making reports is still a professional job, and ordinary users cannot make them by themselves
At present, there is a lack of a simple and effective method to produce professional reports using familiar office software

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 annotation-based report generation method
  • Excel annotation-based report generation method
  • Excel annotation-based report generation method

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0056] Example 1: Original record of electric energy meter verification

[0057] A blank report, the comment that defines the report type, a report only has this item, S=F indicates that this comment is the definition of the report type, Type=Report indicates the report type, Default= / indicates that the blank data is filled with " / ", TopRow =1 means that the report starts from the first row, BottomRow=38 means that the report ends at the 38th row; define the comments of the header content, a report can have multiple items, S=H means the header area, T=PM_Meters and F= SerialNo indicates that the cell needs to be filled with the content of the SerialNo field of the data table PM_Meters; defines the comments of the detailed data, a report generally has multiple items, S=D indicates the detailed area, T=PM_Error and F=Error1 indicates that the cell needs to be filled For the content of the Error1 field of the data table PM_Error, M=Imax 1.0 means that the keyword that meets the co...

example 2

[0058] Example 2: Checklist of Energy Meter Verification Records

[0059] A report in the form of a list defines the comment of the report type. This is the only item for a report. S=Define indicates that the comment is the definition of the report type. TopRow=1 indicates that the report starts from row 1. 30 lines end, Type=List indicates that the report type is list format, Max=20 indicates that each page can output up to 20 records, Orientation=H indicates that the records are arranged in rows; define the annotation of the detailed data in the report, S=Detail indicates the detailed area , T=PM_Meters and F=SerialNo indicate that this cell is filled with the content of the SerialNo field of the PM_Meters data table, N=1-10 indicates that this area outputs the 1st to 10th records, and finally generates a new report.

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 annotation-based report generation method. The method comprises the following steps: defining a script format, and generating a data dictionary and an analytic program; generating an Excel report file; judging whether cells of the Excel report file needs automatically filling in or not, if yes, adding Excel cell annotation according to the data dictionary, and binding database content; if not, directly adding the Excel cell annotation, and describing basic information of a report; calling the report file by utilizing the analytic program to form a result report. Compared with the prior art, the Excel annotation-based report generation method has the advantages of being wide in applicability, simple to manufacture, convenient to change, simple in software maintenance, low in professional requirement and the like.

Description

technical field [0001] The invention relates to a method for generating a report, in particular to an Excel annotation-based method for generating a report. Background technique [0002] Reports are used to dynamically display data in forms such as tables and charts. After the emergence of computers, people use the functions of computer processing data and interface design to generate and display reports. The main features of the report on the computer are data dynamics, diversified formats, and the complete separation of report data and report format. Users can only modify the data or only the format. Report classification EXCEL, WORD and other editing software: they can make very complex report formats, but because they do not define a special report structure to dynamically load report data, the data in all such software is already defined, static It cannot be changed dynamically. They have no way to realize the "data dynamic" feature of report software. Database softw...

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
IPC IPC(8): G06F9/44
CPCG06F8/30G06F8/37
Inventor 王新刚朱铮朱彬若张垠江剑峰翁素婷顾臻陈金涛吴颖盛青
Owner SHANGHAI MUNICIPAL ELECTRIC POWER CO
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com