Method, device and system for deriving report forms from web inquiring system

Abstract

The invention discloses a method for deriving report forms from a web inquiring system, which is applied to a client. The method comprises the following steps: after detecting that a user triggers report form deriving operation on a current inquiring result interface, modifying an original inquiring request; increasing a deriving mark in the original inquiring request and sending the request to a server; receiving a response containing a report form file returned by the server. The invention further discloses a corresponding method applied to the server; the method comprises the following steps of: receiving an inquiring result sent by the client and generating an inquiring result page; setting a uniform mark for a form object in the inquiring result page; if the inquiring request contains the deriving mark, converting the inquiring result page into a document object model; positioning a form object in the document object model according to the mark; converting the form object in the document object model into a report form file; carrying the report form file in the response to be returned back to the client. According to the method disclosed by the invention, invasion to a server side inquiring procedure is not caused and the derivation of the WYSIWYG (What You See Is What You Get) report form files is realized; the system development and maintenance efficiencies are improved.

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