A method, device and system for exporting reports from a web query system

Abstract

The invention discloses a method for exporting a report from a web query system, which is applied to a client, comprising: modifying an original query request after detecting that a user triggers a report export operation on a current query result interface, adding an export identifier and sending it to a server , to receive the response containing the report file returned by the server. A corresponding method applied to the server is also disclosed, including: receiving a query request sent by a client and generating a query result page, setting a uniform identifier for the table object in the query result page, if the query request includes an export identifier, and converting the query result The page is converted into the document object model, and the table object in the document object model is located according to the identifier, and the table object in the document object model is converted into a report file, which is carried in the response and returned to the client. The invention can achieve no intrusion to the server-side query program, realize the export of the WYSIWYG report file, and improve the efficiency of system development and maintenance.

Description

technical field [0001] The invention relates to the technical field of computer communication, in particular to a method, device and system for exporting reports from a web query system. Background technique [0002] Reports in Excel format are the most widely used report formats in our work and life today, and it is generally believed that the data required by users can be queried in the web application system through a browser, and then exported to excel. A convenient way to obtain report data. [0003] There are mainly two types of existing methods for exporting reports from the web query system. The first type is to install the excel plug-in provided by Microsoft on the client side where the browser is located. When the user clicks the export button on the query result interface, the browser directly Convert the tabular data displayed on the current web page into an excel file. The disadvantage of this method is that the client must install the excel plug-in, and curre...

AI Technical Summary

Problems solved by technology

The disadvantage of this method is that the client must install the excel plug-in, and currently only supports the Internet Explorer browser, and does not support other types of browsers

This method has obvious disadvantages for development: each query page must pre-define the corresponding template. If you want to make the exported excel file achieve what you see is what you get, this requires background developers to be clear about the structure of the front-end web page , and it is very inefficient to modify the background program as the structure of the foreground web page changes, and it is also easy to cause inconsistencies between the display results of the web page and the excel file

[0004] Therefore, in order to achieve WYSIWYG report export and improve the efficiency of web system development and maintenance, the existing methods still need to be improved

Images