Report form realization method and device based on Excel template

Abstract

The invention discloses a report form realization method and device based on an Excel template. The method of the invention includes: reading the preset Excel template, wherein the Excel template includes configuration information used for generating a report form and configuration information used for generating a query component, and the query component includes query conditions used for screening report form data; generating the first report form according to the read configuration information used for generating the report form, and generating the query component according to the read configuration information used for generating the query component; screening the report form data in the first report form according to the query conditions in the query component to obtain a second report form of which report form data meet the query conditions; and converting the second report form and the query component into contents of a hypertext markup language, and then outputting the same onto a web page for display. The invention provides a report form realization scheme capable of flexibly generating the report form, and displaying and querying the report form on the same web page.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to an Excel template-based report realization method and device. Background technique [0002] Reports, as an indispensable part of enterprise management software, play a pivotal role in enterprise management software. With the continuous development of the Internet and the continuous popularization of web development, the demand for reports to be displayed on web pages is becoming more and more intense, especially in The financial field often involves the display of a large number of reports. [0003] At present, there are some reporting tools, such as the reporting tool based on the open source plug-in Business Intelligence and Reporting Tools (BIRT) plug-in, the open source library JasperReports tool, etc., but some of the current reporting tools need to configure the data source. If If the data source is wrongly matched, it will continue to search on the development tool, ...

AI Technical Summary

Problems solved by technology

[0003] At present, there are some reporting tools, such as the reporting tool based on the open source plug-in Business Intelligence and Reporting Tools (BIRT) plug-in, the open source library JasperReports tool, etc., but some of the current reporting tools need to configure the data source. If If the data source is wrongly matched, it will continue to search on the development tool, resulting in a large consumption of resources; some generated reports show that the web page can only display the fixed style that comes with the plug-in, and cannot generate a custom report format; some compile and generate The files need to be imported into the project and analyzed. When changing the report, you need to change the file on the software first, then compile it and then import it into the project for analysis. Switching tools and plug-ins back and forth is cumbersome and requires a lot of work. Some development tools are in the When generating a report, there is no query condition restriction. When the amount of data is large, the query result will be very slow, and there is no query component added to the web page, so the data cannot be flexibly queried

[0004] It can be seen that there is currently no report implementation scheme that can flexibly generate reports and display and query reports on the same web page

Images