Online report processing method and device, computer equipment and storage medium

Abstract

The embodiment of the invention belongs to the field of big data and financial science and technology, and relates to an online report processing method which comprises the steps of obtaining a local report in response to a report processing instruction; analyzing the local report to obtain report analysis information of the local report; mapping the report analysis information to a pre-established data model so as to generate a rendering configuration file of the local report according to the data model; and performing page rendering processing on the local report according to the rendering configuration file to obtain an online report corresponding to the local report. The invention further provides an online report processing device, computer equipment and a storage medium. In addition, the invention also relates to a block chain technology, and the local report can be stored in a block chain. According to the invention, the processing efficiency of the online report is improved.

Description

Technical Field

[0001] The present application relates to the fields of big data and financial technology, and in particular to an online report processing method, device, computer equipment and storage medium. Background Art

[0002] Reports are usually carried out in Excel files to fill in and display data. Localized Excel files have many limitations in sharing and multi-person collaboration. For this reason, online report technology has emerged to move reports to web pages for display and operation. However, current online report generation technology is usually developed specifically for a specific report, including the development of background logic and front-end display pages. The development cost is high and the development speed is slow. When a report needs to be changed or added, developers are required to perform corresponding maintenance or development. In the field of financial technology, various reports may appear at any time based on business needs. The existing online report generation technology will greatly reduce the efficiency of online report processing. Summary of the invention

[0003] The purpose of the embodiments of the present application is to provide an online report processing method, apparatus, computer equipment and storage medium to solve the problem of low efficiency of online report processing.

[0004] In order to solve the above technical problems, the embodiment of the present application provides an online report processing method, which adopts the following technical solution:

[0005] Responding to the report processing instruction, obtaining a local report;

[0006] Parsing the local report to obtain report parsing information of the local report;

[0007] Mapping the report parsing information to a pre-established data model to generate a rendering configuration file for the local report according to the data model;

[0008] The page rendering process of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report.

[0009] In order to solve the above technical problems, the embodiment of the present application further provides an online report processing device, which adopts the following technical solution:

[0010] A report acquisition module, used to acquire a local report in response to a report processing instruction;

[0011] A report parsing module, used to parse the local report to obtain report parsing information of the local report;

[0012] A file generation module, used for mapping the report parsing information to a pre-established data model, so as to generate a rendering configuration file of the local report according to the data model;

[0013] The report generation module is used to perform page rendering processing of the local report according to the rendering configuration file to obtain an online report corresponding to the local report.

[0014] In order to solve the above technical problems, the embodiment of the present application further provides a computer device, which adopts the following technical solution:

[0015] Responding to the report processing instruction, obtaining a local report;

[0016] Parsing the local report to obtain report parsing information of the local report;

[0017] Mapping the report parsing information to a pre-established data model to generate a rendering configuration file for the local report according to the data model;

[0018] The page rendering process of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report.

[0019] In order to solve the above technical problems, the embodiment of the present application further provides a computer-readable storage medium, which adopts the following technical solution:

[0020] Responding to the report processing instruction, obtaining a local report;

[0021] Parsing the local report to obtain report parsing information of the local report;

[0022] Mapping the report parsing information to a pre-established data model to generate a rendering configuration file for the local report according to the data model;

[0023] The page rendering process of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report.

[0024] Compared with the prior art, the embodiments of the present application mainly have the following beneficial effects: in response to a report processing instruction, a local report is obtained; the local report is parsed to obtain report parsing information, which includes detailed information of various aspects of the local report; the report parsing information is mapped to a pre-established data model, which is a benchmark and specification for establishing online reports, and the report parsing information is standardized before online display and operation according to the data model to obtain a rendering configuration file, which determines the form and content of the online report; the page rendering processing of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report; the present application can generate online reports of various local reports by standardizing and programming the local reports, thereby improving the efficiency of online report processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] In order to more clearly illustrate the scheme in the present application, a brief introduction is given below to the drawings required for use in the description of the embodiments of the present application. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0026] Figure 1 is an exemplary system architecture diagram to which the present application may be applied;

[0027] Figure 2 is a flow chart of an embodiment of an online report processing method according to the present application;

[0028] Figure 3 is a structural diagram of an embodiment of an online report processing device according to the present application;

[0029] Figure 4 It is a structural diagram of an embodiment of a computer device according to the present application. DETAILED DESCRIPTION

[0030] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by technicians in the technical field of the present application; the terms used in the specification of the application herein are only for the purpose of describing specific embodiments and are not intended to limit the present application; the terms "including" and "having" and any variations thereof in the specification and claims of the present application and the above-mentioned drawings are intended to cover non-exclusive inclusions. The terms "first", "second", etc. in the specification and claims of the present application or the above-mentioned drawings are used to distinguish different objects, not to describe a specific order.

[0031] Reference to "embodiments" herein means that a particular feature, structure, or characteristic described in conjunction with the embodiments may be included in at least one embodiment of the present application. The appearance of the phrase in various locations in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment that is mutually exclusive with other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0032] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings.

[0033] like Figure 1 As shown, the system architecture 100 may include terminal devices 101, 102, 103, a network 104 and a server 105. The network 104 is used to provide a medium for communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links or optical fiber cables.

[0034] Users can use terminal devices 101, 102, 103 to interact with server 105 through network 104 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 101, 102, 103, such as web browser applications, shopping applications, search applications, instant messaging tools, email clients, social platform software, etc.

[0035] The terminal devices 101, 102, and 103 can be various electronic devices with display screens and supporting web browsing, including but not limited to smart phones, tablet computers, e-book readers, MP3 players (Moving Picture Experts Group Audio Layer III), MP4 (Moving Picture Experts Group Audio Layer IV) players, laptop computers, desktop computers, etc.

[0036] The server 105 may be a server that provides various services, such as a background server that provides support for web pages displayed on the terminal devices 101 , 102 , and 103 .

[0037] It should be noted that the online report processing method provided in the embodiment of the present application is generally executed by a server, and accordingly, the online report processing device is generally arranged in the server.

[0038] It should be understood that Figure 1The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.

[0039] Continue to refer Figure 2 , shows a flow chart of an embodiment of an online report processing method according to the present application. The online report processing method comprises the following steps:

[0040] Step S201, in response to a report processing instruction, obtaining a local report.

[0041] In this embodiment, the online report processing method is executed on the electronic device (eg Figure 1 The server shown in the figure) can communicate with the terminal device through a wired connection or a wireless connection. It should be noted that the above wireless connection method may include but is not limited to 3G / 4G / 5G connection, Wi-Fi connection, Bluetooth connection, Wi MAX connection, Zigbee connection, UWB (Ultra Wi-Fi Band) connection, and other wireless connection methods currently known or to be developed in the future.

[0042] Specifically, the client can send a report processing instruction to the server, and the report processing instruction is used to request the server to process the local report in the client to generate an online report. The local report can be an Excel table.

[0043] Furthermore, the above step S201 may include: when receiving a report processing instruction sent by the client, performing security verification with the client; when passing the security verification, obtaining a local report from the client through the secure transport layer protocol, and verifying the local report through the secure transport layer protocol; when the local report verification passes, parsing the local report to obtain report parsing information of the local report.

[0044] Specifically, the user can operate the client to send a report processing instruction to the server. For example, when the user needs to share a local report located in the client to all users in a certain user group, the user can select the local report through the upload entry in the online report processing system and trigger the report processing instruction. Alternatively, the client can automatically trigger the report processing instruction; for example, the client needs to upload the local report to the server regularly to generate an online report.

[0045] When receiving the report processing instruction sent by the client, security verification is performed with the client. Security verification can be performed through SSL (Secure Socket Layer, a security protocol implemented on the transmission communication protocol TCP / IP). Security verification includes security certificate verification and client identity verification. Among them, security certificate verification can be based on the SSL protocol, using digital certificates to authenticate the server; client identity verification is based on the SSL protocol, authenticating the client identity (including users and / or terminal devices).

[0046] When the security verification is passed, the local report is obtained from the client through the secure transport layer protocol (TLS, used to provide confidentiality and data integrity between two communicating applications). TLS will use encryption algorithms to encrypt the communication channel. The data in the communication channel is also encrypted, making it difficult for third parties to intercept and interpret the data, ensuring the confidentiality of the data during transmission.

[0047] After receiving the local report, the local report is verified through the secure transport layer protocol, for example, a data integrity check can be performed to ensure that the data has not been tampered with or damaged during the transmission process.

[0048] When the received local report passes the verification, the local report is parsed to obtain report parsing information of the local report.

[0049] In this embodiment, security verification is performed with the client. When the security verification is passed, local reports are obtained from the client via the secure transport layer protocol, and the local reports are verified via the secure transport layer protocol, thereby ensuring the accuracy of the received local reports and further ensuring the accuracy of the generated online reports.

[0050] Step S202: parse the local report to obtain report parsing information of the local report.

[0051] Specifically, the server parses the local report, obtains information and details in the local report through parsing, and obtains report parsing information.

[0052] Furthermore, the above step S202 may include: parsing the local report to obtain report structure information, cell information, formula information, style information and interaction information of the local report; generating report parsing information of the local report according to the report structure information, cell information, formula information, style information and interaction information.

[0053] Specifically, the local report is parsed to obtain report structure information, cell information, formula information, style information and interaction information of the local report.

[0054] Among them, report structure information refers to which worksheets (Sheets) the local report (i.e. workbook) contains, and how many rows (Row) and columns (Column) are in each worksheet. Cells are the smallest units in a worksheet and are used to store specific data. Cell information refers to the data storage situation of cells, including data values, data types, etc. Formula information refers to the formulas contained in local reports. Style information refers to the style and format information of worksheets, cells, rows, and columns, including fonts, colors, borders, alignment, etc., which are used to present and display data. Interaction information refers to whether the cell supports editing of cell content, whether dragging to adjust the size of rows and columns is allowed, etc. The online report processing system can automatically identify cells in local reports that allow data to be filled in, and mark these cells through interaction information.

[0055] In one embodiment, chart image information can also be obtained after parsing.

[0056] The report structure information, cell information, formula information, style information and interaction information as a whole will be used as the report parsing information of the local report.

[0057] In this embodiment, the local report is parsed to obtain report structure information, cell information, formula information, style information and interaction information, so that detailed information of various aspects of the local report can be obtained and report parsing information of the local report can be obtained.

[0058] Step S203: Map the report parsing information to a pre-established data model to generate a rendering configuration file of the local report according to the data model.

[0059] Specifically, a data model is pre-established in the server. The data model is equivalent to the benchmark and specification for establishing online reports. By mapping the report parsing information to the data model, various types of information in the report parsing information can be standardized before generating online reports, and a rendering configuration file can be generated. It is a configuration file for generating online reports and determines the form and content of the online reports.

[0060] Furthermore, the above step S203 may include: mapping the report parsing information to a pre-established data model to obtain standard report information; determining the rendering data of the local report according to the standard report information; storing the rendering data in a preset data format to obtain a rendering configuration file, wherein the preset data format includes a JSON format.

[0061] Specifically, the report parsing information is mapped to the data model, and various types of information in the report parsing information are standardized. For example, by mapping to the data model, the new data type of the data value in the cell is determined, the style and format of the rows and columns are determined, and standard report information is obtained.

[0062] The rendering data of the local report is determined according to the standard report information. The rendering data includes not only the data related to the online table form, but also the specific data in the local report cell.

[0063] The rendering data is stored in a preset data format to obtain a rendering configuration file, and the preset data format includes a JSON format. JSON (JavaScript Object Notation) is a lightweight data exchange format, which is usually used to transmit data between different applications. The present application transmits and stores data through JSON, and the server parses and converts the local report into a format suitable for presentation on a web page. The conversion result is usually stored in JSON format, because JSON is very effective for representing structured data, and the data, style, formula and other information of each cell can be mapped to a JSON object. The generated JSON data can be used by the front-end interface to present online reports. The front-end application usually uses JavaScript to parse the JSON data and convert it into an interactive electronic form on the web page, which allows users to view and edit online reports on the web page. Using the JSON format can increase the flexibility and maintainability of the online report processing system. Because JSON is a text format that is easy to parse and generate, developers can relatively easily write code to process and operate JSON data without having to deal with complex binary formats.

[0064] In this embodiment, the report parsing information is mapped to the data model for standardization processing to obtain standard report information; the rendering data of the local report is determined based on the standard report information, and then stored in a preset data format to obtain a rendering configuration file. The preset data format includes a JSON format, which can efficiently represent and manage structured rendering data.

[0065] Furthermore, when the report parsing information contains formula information, the above-mentioned step of mapping the report parsing information to a pre-established data model to obtain standard report information may include: obtaining a formula engine in the data model; parsing the formula information in the report parsing information through the formula engine to obtain standard formula information matching the local report, wherein the standard formula information includes calculation functions, operators, data types and cell reference information.

[0066] Specifically, when the report parsing information contains formula information, the formula engine pre-established in the data model is obtained. It is similar to the formula calculation engine in Excel and can accurately parse and execute the calculation formula and verification formula in Excel. The formula engine fully understands the specifications and syntax of Excel. It can parse the formula information in the report parsing information and obtain standard formula information that matches the local report standard. The standard formula information includes calculation functions, operators, data types, and cell reference information, etc., which can ensure that the calculation results of the formula are completely consistent with Excel.

[0067] When the formula in a local report needs to be changed, you only need to modify the formula in the local report and then upload it again to the online report processing system. The new formula will be automatically parsed and executed without the need to manually modify and implement the formula calculation logic, which reduces maintenance costs, ensures the accuracy of the formula, and improves debugging and development efficiency.

[0068] In this embodiment, when the report parsing information contains formula information, the formula information in the report parsing information is parsed by the formula engine in the data model to obtain standard formula information that matches the local report standard, including calculation functions, operators, data types, and cell reference information, to ensure that the calculation results of the formulas in subsequent online reports are completely consistent with the local reports.

[0069] Step S204: performing page rendering processing on the local report according to the rendering configuration file to obtain an online report corresponding to the local report.

[0070] Specifically, the online report processing system performs page rendering processing of the local report according to the rendering configuration file in JSON format, creates an electronic report in the web application, and obtains an online report corresponding to the local report.

[0071] In one embodiment, the online report processing system can be built based on SpreadJS, which is a spreadsheet library based on JavaScript that provides rich functions and allows spreadsheets to be created and operated in Web applications, similar to Microsoft Excel.

[0072] The online report generation system in this application supports the coexistence of multiple sets of reports. The data between reports will not affect each other. Whenever you need to generate a set of online reports, you only need to upload the new local report through the upload entrance provided by the system. There is a report switching button on the system page, which can switch between multiple sets of reports.

[0073] In this embodiment, in response to a report processing instruction, a local report is obtained; the local report is parsed to obtain report parsing information, which includes detailed information of various aspects of the local report; the report parsing information is mapped to a pre-established data model, which is a benchmark and specification for establishing online reports, and the report parsing information is standardized before online display and operation according to the data model to obtain a rendering configuration file, which determines the form and content of the online report; page rendering processing of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report; the present application can generate online reports of various local reports by standardizing and programming local reports, thereby improving the efficiency of online report processing.

[0074] Furthermore, after the above step S204, it can also include: for each worksheet in the online report, obtaining the row number range of the worksheet; dividing the worksheet into multiple sub-sheets according to the row number range; generating a worksheet menu for the worksheet in a preset area of ​​the online report, and adding control buttons for each sub-sheet in the worksheet menu.

[0075] Specifically, for each worksheet in the online report, the server can obtain the row number range of the worksheet, and the row number range can show how many rows the worksheet contains. The worksheet can be divided into multiple sub-sheets according to the row number range. In the preset area of ​​the generated online report, a worksheet menu of the worksheet can be generated, and control buttons for each sub-sheet can be added to the worksheet menu. There are many types of control buttons, which can realize the jump, submission, review, archiving, etc. of each sub-sheet.

[0076] In this embodiment, for each worksheet in the online report, the row number range of the worksheet is obtained; the worksheet is divided into multiple sub-sheets according to the row number range; a worksheet menu of the worksheet is generated in a preset area of ​​the online report, and control buttons for each sub-sheet are added to the worksheet menu to facilitate various functional controls of each sub-sheet through the control buttons.

[0077] Furthermore, the above method may also include: obtaining data filling information of each sub-table; generating filling statistics information of each sub-table according to the data filling information of each sub-table; and displaying the filling statistics information of each sub-table through a worksheet menu.

[0078] Specifically, the data filling information of each sub-table is obtained, and the data filling information refers to the status of each sub-table being filled with data, including not started filling, filling in progress, and filling completed, as well as the specific number of filled cells.

[0079] Based on the data filling information of each sub-table, the filling statistics of each sub-table are generated. The filling statistics can be displayed through bar charts, pie charts, etc. The filling statistics of each sub-table can be displayed through the worksheet menu, which is convenient and intuitive to obtain the situation of each sub-table. It can be understood that the filling statistics of the worksheet / online report can also be generated and displayed.

[0080] In this embodiment, data filling information of each sub-table is obtained, and filling statistics information of each sub-table is generated based on the data filling information of each sub-table. The filling statistics information of each sub-table is displayed through the worksheet menu, so that the filling status of each sub-table can be easily and intuitively obtained, thereby facilitating the operation and management of online reports.

[0081] The present application can be applied to fields such as finance and insurance. In these fields, a large number of reports often need to be generated based on business needs. The online report processing method in each embodiment of the present application can quickly generate online reports that meet the needs, and realize the sharing and management of reports within the organization / department, thereby improving the efficiency of online report processing.

[0082] It should be emphasized that in order to further ensure the privacy and security of the above-mentioned local reports, the above-mentioned local reports can also be stored in a node of a blockchain.

[0083] The blockchain referred to in this application is a new application model of computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanism, encryption algorithm, etc. Blockchain is essentially a decentralized database, a string of data blocks generated by cryptographic methods. Each data block contains a batch of network transaction information, which is used to verify the validity of its information (anti-counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, platform product service layer, and application service layer.

[0084] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through computer-readable instructions, and the computer-readable instructions can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, the aforementioned storage medium can be a non-volatile storage medium such as a disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).

[0085] It should be understood that, although the steps in the flowchart of the accompanying drawings are displayed in sequence as indicated by the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least a part of the steps in the flowchart of the accompanying drawings may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be executed in turn or alternately with other steps or at least a part of the sub-steps or stages of other steps.

[0086] Further references Figure 3 , as a response to the above Figure 2 The present application provides an embodiment of an online report processing device, and the embodiment of the device is Figure 2 Corresponding to the method embodiment shown, the device can be specifically applied to various electronic devices.

[0087] like Figure 3 As shown, the online report processing device 300 described in this embodiment includes: a report acquisition module 301, a report parsing module 302, a file generation module 303 and a report generation module 304, wherein:

[0088] The report acquisition module 301 is used to acquire a local report in response to a report processing instruction.

[0089] The report parsing module 302 is used to parse the local report to obtain report parsing information of the local report.

[0090] The file generation module 303 is used to map the report parsing information to a pre-established data model to generate a rendering configuration file of the local report according to the data model.

[0091] The report generation module 304 is used to perform page rendering processing of the local report according to the rendering configuration file to obtain an online report corresponding to the local report.

[0092] In this embodiment, in response to a report processing instruction, a local report is obtained; the local report is parsed to obtain report parsing information, which includes detailed information of various aspects of the local report; the report parsing information is mapped to a pre-established data model, which is a benchmark and specification for establishing online reports, and the report parsing information is standardized before online display and operation according to the data model to obtain a rendering configuration file, which determines the form and content of the online report; page rendering processing of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report; the present application can generate online reports of various local reports by standardizing and programming local reports, thereby improving the efficiency of online report processing.

[0093] In some optional implementations of this embodiment, the report acquisition module 301 may include: a security verification submodule and a report acquisition submodule, wherein:

[0094] The security verification submodule is used to perform security verification with the client when receiving a report processing instruction sent by the client.

[0095] The report acquisition submodule is used to obtain the local report from the client through the secure transport layer protocol when the security verification is passed, and to verify the local report through the secure transport layer protocol.

[0096] The report parsing module 302 is further configured to parse the local report to obtain report parsing information of the local report when the local report verification passes.

[0097] In this embodiment, security verification is performed with the client. When the security verification is passed, local reports are obtained from the client via the secure transport layer protocol, and the local reports are verified via the secure transport layer protocol, thereby ensuring the accuracy of the received local reports and further ensuring the accuracy of the generated online reports.

[0098] In some optional implementations of this embodiment, the report parsing module 302 may include: a report parsing submodule and an information generating submodule, wherein:

[0099] The report parsing submodule is used to parse the local report to obtain the report structure information, cell information, formula information, style information and interaction information of the local report.

[0100] The information generation submodule is used to generate report parsing information of a local report based on report structure information, cell information, formula information, style information and interaction information.

[0101] In this embodiment, the local report is parsed to obtain report structure information, cell information, formula information, style information and interaction information, so that detailed information of various aspects of the local report can be obtained and report parsing information of the local report can be obtained.

[0102] In some optional implementations of this embodiment, the file generation module 303 may include: an information mapping submodule, a data determination submodule, and a file generation submodule, wherein:

[0103] The information mapping submodule is used to map the report analysis information to the pre-established data model to obtain standard report information.

[0104] The data determination submodule is used to determine the rendering data of the local report according to the standard report information.

[0105] The file generation submodule is used to store the rendering data in a preset data format to obtain a rendering configuration file, wherein the preset data format includes a JSON format.

[0106] In this embodiment, the report parsing information is mapped to the data model for standardization processing to obtain standard report information; the rendering data of the local report is determined based on the standard report information, and then stored in a preset data format to obtain a rendering configuration file. The preset data format includes a JSON format, which can efficiently represent and manage structured rendering data.

[0107] In some optional implementations of this embodiment, when the report parsing information includes formula information, the information mapping submodule may include: an engine acquisition unit and a standard generation unit, wherein:

[0108] The engine acquisition unit is used to acquire the formula engine in the data model.

[0109] The standard generation unit is used to parse the formula information in the report parsing information through the formula engine to obtain standard formula information matching the local report. The standard formula information includes calculation functions, operators, data types and cell reference information.

[0110] In this embodiment, when the report parsing information contains formula information, the formula information in the report parsing information is parsed by the formula engine in the data model to obtain standard formula information that matches the local report standard, including calculation functions, operators, data types, and cell reference information, to ensure that the calculation results of the formulas in subsequent online reports are completely consistent with the local reports.

[0111] In some optional implementations of this embodiment, the online report processing device 300 may further include: a range acquisition module, a worksheet division module, and a menu generation module, wherein:

[0112] The range acquisition module is used to obtain the row number range of each worksheet in the online report.

[0113] The worksheet partitioning module is used to divide a worksheet into multiple sub-sheets according to the row number range.

[0114] The menu generation module is used to generate a worksheet menu of a worksheet in a preset area of ​​an online report, and to add control buttons of each sub-sheet to the worksheet menu.

[0115] In this embodiment, for each worksheet in the online report, the row number range of the worksheet is obtained; the worksheet is divided into multiple sub-sheets according to the row number range; a worksheet menu of the worksheet is generated in a preset area of ​​the online report, and control buttons for each sub-sheet are added to the worksheet menu to facilitate various functional controls of each sub-sheet through the control buttons.

[0116] In some optional implementations of this embodiment, the online report processing device 300 may further include: an information acquisition module, a statistics generation module, and a statistics display module, wherein:

[0117] The information acquisition module is used to obtain the data filling information of each sub-table.

[0118] The statistics generation module is used to generate the filled-in statistical information of each sub-table according to the data filled-in information of each sub-table.

[0119] The statistical display module is used to display the filled statistical information of each sub-table through the worksheet menu.

[0120] In this embodiment, data filling information of each sub-table is obtained, and filling statistics information of each sub-table is generated based on the data filling information of each sub-table. The filling statistics information of each sub-table is displayed through the worksheet menu, so that the filling status of each sub-table can be easily and intuitively obtained, thereby facilitating the operation and management of online reports.

[0121] To solve the above technical problems, the present application also provides a computer device. Figure 4 , Figure 4 This is a basic structural block diagram of the computer device in this embodiment.

[0122] The computer device 4 includes a memory 41, a processor 42, and a network interface 43 that are interconnected through a system bus. It should be noted that the figure only shows a computer device 4 with components 41-43, but it should be understood that it is not required to implement all the components shown, and more or fewer components can be implemented instead. Among them, those skilled in the art can understand that the computer device here is a device that can automatically perform numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes but is not limited to microprocessors, application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), digital processors (DSPs), embedded devices, etc.

[0123] The computer device may be a computing device such as a desktop computer, a notebook, a PDA, a cloud server, etc. The computer device may interact with a user through a keyboard, a mouse, a remote controller, a touch pad, or a voice control device.

[0124] The memory 41 includes at least one type of readable storage medium, and the readable storage medium includes flash memory, hard disk, multimedia card, card-type memory (for example, SD or DX memory, etc.), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, disk, optical disk, etc. In some embodiments, the memory 41 can be an internal storage unit of the computer device 4, such as a hard disk or memory of the computer device 4. In other embodiments, the memory 41 can also be an external storage device of the computer device 4, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (FlashCard), etc. equipped on the computer device 4. Of course, the memory 41 can also include both the internal storage unit of the computer device 4 and its external storage device. In this embodiment, the memory 41 is generally used to store the operating system and various application software installed on the computer device 4, such as computer-readable instructions of the online report processing method, etc. In addition, the memory 41 can also be used to temporarily store various types of data that have been output or are to be output.

[0125] The processor 42 may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chips in some embodiments. The processor 42 is generally used to control the overall operation of the computer device 4. In this embodiment, the processor 42 is used to run the computer-readable instructions stored in the memory 41 or process data, such as running the computer-readable instructions of the online report processing method.

[0126] The network interface 43 may include a wireless network interface or a wired network interface. The network interface 43 is generally used to establish a communication connection between the computer device 4 and other electronic devices.

[0127] The computer device provided in this embodiment can execute the above-mentioned online report processing method. Here, the online report processing method can be the online report processing method of each of the above-mentioned embodiments.

[0128] In this embodiment, in response to a report processing instruction, a local report is obtained; the local report is parsed to obtain report parsing information, which includes detailed information of various aspects of the local report; the report parsing information is mapped to a pre-established data model, which is a benchmark and specification for establishing online reports, and the report parsing information is standardized before online display and operation according to the data model to obtain a rendering configuration file, which determines the form and content of the online report; page rendering processing of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report; the present application can generate online reports of various local reports by standardizing and programming local reports, thereby improving the efficiency of online report processing.

[0129] The present application also provides another implementation, namely, providing a computer-readable storage medium, wherein the computer-readable storage medium stores computer-readable instructions, and the computer-readable instructions can be executed by at least one processor to enable the at least one processor to perform the steps of the online report processing method as described above.

[0130] In this embodiment, in response to a report processing instruction, a local report is obtained; the local report is parsed to obtain report parsing information, which includes detailed information of various aspects of the local report; the report parsing information is mapped to a pre-established data model, which is a benchmark and specification for establishing online reports, and the report parsing information is standardized before online display and operation according to the data model to obtain a rendering configuration file, which determines the form and content of the online report; page rendering processing of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report; the present application can generate online reports of various local reports by standardizing and programming local reports, thereby improving the efficiency of online report processing.

[0131] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk), and includes a number of instructions for a terminal device (which can be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in each embodiment of the present application.

[0132] Obviously, the embodiments described above are only some embodiments of the present application, rather than all embodiments. The preferred embodiments of the present application are given in the accompanying drawings, but they do not limit the patent scope of the present application. The present application can be implemented in many different forms. On the contrary, the purpose of providing these embodiments is to make the understanding of the disclosure of the present application more thorough and comprehensive. Although the present application is described in detail with reference to the aforementioned embodiments, for those skilled in the art, it is still possible to modify the technical solutions recorded in the aforementioned specific implementation methods, or to perform equivalent replacement of some of the technical features therein. Any equivalent structure made using the contents of the specification and drawings of this application, directly or indirectly used in other related technical fields, is similarly within the scope of patent protection of this application.

Claims

1. An online report processing method, It is characterized in that The steps include: Responding to the report processing instruction, obtaining a local report; Parsing the local report to obtain report parsing information of the local report; Mapping the report parsing information to a pre-established data model to generate a rendering configuration file for the local report according to the data model; The page rendering process of the local report is performed according to the rendering configuration file to obtain an online report corresponding to the local report.

2. The online report processing method according to claim 1, It is characterized in that The step of obtaining a local report in response to the report processing instruction includes: When receiving a report processing instruction sent by a client, performing security verification with the client; When the security verification is passed, a local report is obtained from the client through a secure transport layer protocol, and the local report is verified through the secure transport layer protocol; When the local report is verified to be passed, the step of parsing the local report to obtain report parsing information of the local report is performed.

3. The online report processing method according to claim 1, It is characterized in that The step of parsing the local report to obtain report parsing information of the local report includes: Parsing the local report to obtain report structure information, cell information, formula information, style information, and interaction information of the local report; Report parsing information of the local report is generated according to the report structure information, the cell information, the formula information, the style information and the interaction information.

4. The online report processing method according to claim 1, It is characterized in that The step of mapping the report parsing information to a pre-established data model to generate a rendering configuration file for the local report according to the data model includes: Mapping the report parsing information to a pre-established data model to obtain standard report information; Determine rendering data of the local report according to the standard report information; The rendering data is stored in a preset data format to obtain a rendering configuration file, wherein the preset data format includes a JSON format.

5. The online report processing method according to claim 4, It is characterized in that When the report parsing information includes formula information, the step of mapping the report parsing information to a pre-established data model to obtain standard report information includes: Get the formula engine in the data model; The formula information in the report parsing information is parsed by the formula engine to obtain standard formula information matching the local report, wherein the standard formula information includes calculation functions, operators, data types and cell reference information.

6. The online report processing method according to claim 1, It is characterized in that After the step of performing page rendering processing of the local report according to the rendering configuration file to obtain an online report corresponding to the local report, the method further includes: For each worksheet in the online report, obtaining the row number range of the worksheet; Dividing the worksheet into a plurality of subsheets according to the row number range; A worksheet menu of the worksheet is generated in a preset area of ​​the online report, and control buttons of each sub-sheet are added to the worksheet menu.

7. The online report processing method according to claim 6, It is characterized in that The method further comprises: Obtaining data filling information of each sub-table; Generate filling statistics information of each sub-table according to the data filling information of each sub-table; The filling statistics information of each sub-table is displayed through the worksheet menu.

8. An online report processing device, It is characterized in that include: A report acquisition module, used to acquire a local report in response to a report processing instruction; A report parsing module, used to parse the local report to obtain report parsing information of the local report; A file generation module, used for mapping the report parsing information to a pre-established data model, so as to generate a rendering configuration file of the local report according to the data model; The report generation module is used to perform page rendering processing of the local report according to the rendering configuration file to obtain an online report corresponding to the local report.

9. A computer device, It is characterized in that The method comprises a memory and a processor, wherein the memory stores computer-readable instructions, and the processor implements the steps of the online report processing method according to any one of claims 1 to 7 when executing the computer-readable instructions.

10. A computer-readable storage medium, It is characterized in that The computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, the steps of the online report processing method according to any one of claims 1 to 7 are implemented.

Images