Unlock instant, AI-driven research and patent intelligence for your innovation.

Variable statement generation method and system based on EXCEL templates

A report generation and template technology, applied in the creation/generation of source code, program control device, software design, etc., can solve the problems of wasting time, labor, and cumbersome, and achieve simple methods, good code reusability, and good application versatility. Effect

Inactive Publication Date: 2016-08-24
NANJING UNIV OF INFORMATION SCI & TECH
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the process of software design, the report style (font, content layout, table, position) is a difficult problem between program developers and users. With the change of time and personnel, users always hope that the report style can be changed accordingly, but this For programmers, it is a tedious and simple job. It is purely a waste of time and labor, and I don’t want to do it.

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
  • Variable statement generation method and system based on EXCEL templates
  • Variable statement generation method and system based on EXCEL templates

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The present invention will be further described below in conjunction with the accompanying drawings.

[0029] A method for generating a variable report based on an EXCEL template, comprising the following steps:

[0030] Step 1, use EXCEL to prepare the required report template;

[0031] Step 2, according to each report template in step 1, determine its corresponding comparison information configuration template comparison table;

[0032] Step 3, obtain the required data in the report form from the database;

[0033] Step 4, select the corresponding report EXCEL template from the report template prepared in step 1 according to the required data;

[0034] Step 5, select the corresponding comparison table from the template comparison table configured in step 2 according to the required data, and then obtain the location where each data should be placed in the EXCEL report according to the comparison information in the comparison table, and select in step 4 Write the da...

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 variable statement generation method and system based on EXCEL templates, and belongs to the technical field of software program design systems. The system comprises an EXCEL template statement, a template reference table, a table name file configuration table, a data position reference table and a statement generator. When a statement needs to be generated, an interpreter selects the corresponding statement EXCEL template according to the table name file configuration table; the corresponding data position reference table is selected, the positions where all the data should be placed in the EXCEL statement are acquired according to reference information in the data position reference table, and data is written at the corresponding positions in the EXCEL template; after the data is filled, a corresponding EXCEL file is printed, and then the needed statement is formed; if the style of the statement needs to be modified, the EXCEL template can be modified or added, the positions of the data needed by all the templates are modified or added, and configuration is conducted through the system. According to the method and system, the statement style can be changed through simple configuration, and the method and system are high in efficiency, simple and easy to achieve.

Description

technical field [0001] The invention relates to a variable report generation technology based on an EXCEL template, and belongs to the technical field of software program design systems. Background technique [0002] In the process of software design, the report style (font, content layout, table, position) is a difficult problem between program developers and users. With the change of time and personnel, users always hope that the report style can be changed accordingly, but this For programmers, it is a tedious and simple job. It is purely a waste of time and labor, and they are unwilling to do it. This requires programmers to find a way to solve this dilemma when developing software. Users can change the style of the report to a certain extent through simple configuration. Contents of the invention [0003] Purpose of the invention: In order to overcome the deficiencies in the prior art, the present invention provides a method for generating a variable report based on...

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/20
Inventor 朱节中张辉郑钰辉姜丹丹顾文亚孟祥瑞郭萍姚永雷罗君周万昊李凌
Owner NANJING UNIV OF INFORMATION SCI & TECH