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

A method and device for generating an electronic report

A report generation and electronic technology, applied in the field of electronic report generation method and device, can solve the problems that the report cannot be decomposed into multiple sheets and the report format is complicated

Active Publication Date: 2018-08-28
AGRICULTURAL BANK OF CHINA
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] (2) The report format of the Ministry of Finance, the People's Bank of China and other units is relatively complex, and there are strict requirements for report styles such as pagination, column division, blank line, cell row height, column width, font, and merged cells
[0006] (3) A report cannot be broken down into multiple sheets, nor can it be displayed in multiple sheets within the table

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
  • A method and device for generating an electronic report
  • A method and device for generating an electronic report
  • A method and device for generating an electronic report

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0066] First, in order to enable those skilled in the art to better understand the embodiments of the present invention, the special terms involved in the embodiments of the present invention will be introduced:

[0067] xlsx: an XML-based spreadsheet file specification developed by Microsoft and compressed in ZIP format, which is part of the ISO 29500 standard; since Microsoft Office EXCEL 2007, xlsx has become its default file format, and the domestic software WPS (Word Processing System, text editing system) also supports this file specification;

[0068] Electronic statements: electronic documents used in commercial systems such as banks for data reconciliation, display, analysis, statistics, etc.;

[0069] Template file: refers to a certain template report prepared in advance for generating the final electronic report in the present invention; this template file can be edited through Microsoft Office EXCEL software to define various display styles, data sources and variou...

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 provides an electronic spreadsheet generating method and device. The electronic spreadsheet generating method includes steps of acquiring template files corresponding to electronic spreadsheets and analyzing the templates files to obtain several base XML files to be modified; processing the XML files to obtain a package, and modifying suffix names of the files of the package into suffix corresponding to the electronic spreadsheets so as to obtain the electronic spreadsheets. Therefore, the spreadsheets developed by Microsoft based on XML can be obtained by the electronic spreadsheet generating method in this embodiment of the invention, so that universality of the spreadsheet generating method can be improved.

Description

technical field [0001] The present invention relates to the technical field of electronic reports, and more specifically, to a method and device for generating electronic reports. Background technique [0002] Electronic statements are electronic documents used for data reconciliation, display, analysis, statistics and other functions in many commercial application systems. As an important part of commercial application systems, the data volume of electronic statements is increasing day by day and the format of electronic statements is becoming more and more complex. . [0003] For example, in the construction of a comprehensive financial agency service system, a bank needs to generate various daily, monthly, and annual reports in accordance with the requirements of the Ministry of Finance and the People's Bank of China. The data size and format requirements of the electronic statements to be issued are as follows: [0004] (1) The amount of data is between tens of thousand...

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 Patents(China)
IPC IPC(8): G06F8/30
Inventor 丁慧焦健
Owner AGRICULTURAL BANK OF CHINA