A report filling method, system, device and storage medium based on collaborative platform
Through the report filling method based on the collaborative platform, the process and replacement of formulas in reports is automatically processed and replaced, and the problem of cumbersome formula replacement operations in Excel files is solved, the accuracy and filling efficiency of data is improved, and the online sharing and management of data is realized.
Patent Information
- Application Number
- CN202411070909.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-06
- Publication Date
- 2024-11-01
- Estimated Expiration
- 2044-08-06
AI Technical Summary
In the prior art, the filling and management of production and operation reports rely on Excel files, which leads to cumbersome and error-prone formula replacement operations, affecting the accuracy and filling efficiency of data, and making it difficult to realize data sharing and exchange.
The report filling method based on the collaboration platform is adopted to obtain and parse the content information of the newly added sheet page, judge and replace the application formula, generate the target sheet page, and upload the target report data to the collaboration platform to realize automated formula replacement and data sharing.
The formula replacement operation is simplified, the data accuracy and filling efficiency are improved, the online storage and management of report data is realized, and the sharing of data and the full utilization of value is promoted.
Smart Images

Figure CN118586368B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a report filling method, system, device and storage medium based on a collaborative platform. Background Art
[0002] Currently, the filling and management of production and operation reports mainly rely on Excel files. In production and operation, one month's data is generally stored in an Excel file, and each day's production and operation data is filled in different sheet pages. Some cells in the sheet page are embedded with formulas for calculating related production and operation indicators, and some formulas are designed with reference functions, which can reference the cell data in the previous sheet page, thereby realizing the associative calculation of data.
[0003] At present, when adding a new report sheet page every day, due to work needs, the formulas in some cells in the sheet page need to be replaced. The existing operation method requires manual replacement of a large number of formulas, which is cumbersome and error-prone, affecting the accuracy of data and the efficiency of report filling. In addition, since the report data is stored and managed offline, it is difficult to share and exchange data, resulting in the data value not being fully mined and utilized. Summary of the invention
[0004] In order to solve the above technical problems, the present application provides a report filling method, system, device and storage medium based on a collaborative platform.
[0005] The technical solution provided in this application is described below:
[0006] The first aspect of the present application provides a report filling method based on a collaborative platform, the method comprising:
[0007] Obtaining an accounting plan in the collaboration platform, wherein the accounting plan includes report data and accounting content;
[0008] When receiving a request for adding a sheet page to the report data, obtaining content information of the added sheet page;
[0009] Parsing the content information of the newly added sheet page;
[0010] Obtaining the application formula in the content information of the newly added sheet page according to the analysis result;
[0011] Determining whether the application formula is a formula that needs to be replaced according to the calculation content;
[0012] If yes, then replacing the application formula in the newly added sheet page according to a formula replacement engine to generate a target sheet page, wherein the formula replacement engine includes a formula replacement rule;
[0013] Combining the target sheet page with the report data to generate target report data;
[0014] The target report data is uploaded to the collaboration platform.
[0015] Optionally, after obtaining the accounting solution in the collaboration platform, the method further includes:
[0016] Obtaining the formula type in the accounting scheme;
[0017] Arrange the first letters of the formula types in order;
[0018] Respectively identifying cells in the report data in the order of the arrangement, and extracting formula text;
[0019] The formula text is classified and sorted according to the row number or column number in the cell to obtain the formula list.
[0020] Optionally, replacing the application formula in the newly added sheet page according to a formula replacement engine to generate a target sheet page includes:
[0021] Determine application formula replacement rules, wherein the application formula rules include formula reference replacement, function replacement, variable replacement, and algorithm replacement;
[0022] Integrating the application formula replacement rule and the formula list into the formula replacement engine;
[0023] The application formula in the newly added sheet page is replaced according to the formula replacement engine to generate a target sheet page.
[0024] Optionally, when receiving a request for adding a sheet page to the report data, obtaining content information of the added sheet page includes:
[0025] When receiving a request for adding a sheet page to the report data, determining whether the request for adding the sheet page is from a legitimate source;
[0026] If yes, obtain the content information of the newly added sheet page;
[0027] If not, trace the request source of the newly added sheet page, and upload the tracing report to the collaboration platform.
[0028] Optionally, determining whether the application formula is a formula that needs to be replaced according to the calculation content includes:
[0029] Acquire the calculation content in the calculation scheme, wherein the calculation content includes the output value type and calculation formula;
[0030] It is determined whether the application formula is a formula that needs to be replaced based on the calculation content.
[0031] Optionally, after determining whether the application formula is a formula that needs to be replaced according to the calculation content, the method further includes:
[0032] If not, combining the sheet page containing the application formula with the report data to generate application report data;
[0033] The application report data is uploaded to the collaboration platform.
[0034] Optionally, after uploading the target report data to the collaboration platform, the method further includes:
[0035] Backing up the target report data;
[0036] The target report data is converted into formatted data and uploaded to the database.
[0037] The second aspect of the present application provides a report filling system based on a collaborative platform, the system comprising:
[0038] A first acquisition unit is used to acquire an accounting plan in the collaboration platform, wherein the accounting plan includes report data;
[0039] A second acquisition unit is used to acquire content information of the newly added sheet page when receiving a request for adding a sheet page to the report data;
[0040] A parsing unit, used for parsing the content information of the newly added sheet page;
[0041] A third acquisition unit is used to acquire the application formula in the content information of the newly added sheet page according to the analysis result;
[0042] A judging unit, configured to judge whether the applied formula is a formula that needs to be replaced according to the calculation content;
[0043] a replacement unit, configured to replace the application formula in the newly added sheet page according to a formula replacement engine to generate a target sheet page when the judgment unit determines that the application formula is a formula that needs to be replaced, wherein the formula replacement engine includes a formula replacement rule;
[0044] A generating unit, used for combining the target sheet page with the report data to generate target report data;
[0045] The uploading unit is used to upload the target report data to the collaboration platform.
[0046] The third aspect of the present application provides a report filling device based on a collaborative platform, the device comprising:
[0047] Processor, memory, input-output unit, and bus;
[0048] The processor is connected to the memory, the input and output unit, and the bus;
[0049] The memory stores a program, and the processor calls the program to execute the first aspect and any optional method in the first aspect.
[0050] The fourth aspect of our application provides a computer-readable storage medium, on which a program is stored. When the program is executed on a computer, it executes the first aspect and any optional method in the first aspect.
[0051] It can be seen from the above technical solutions that this application has the following advantages:
[0052] In the report filling method based on the collaborative platform of the present application, firstly, an accounting scheme in the collaborative platform is obtained, and the accounting scheme includes report data and accounting content; when a request for adding a sheet page of report data is received, content information of the added sheet page is obtained, and then the content information of the added sheet page is parsed, and further, the application formula in the content information of the sheet page is obtained according to the parsing result; then, it is determined whether the application formula is a formula that needs to be replaced according to the accounting content; if so, the application formula in the added sheet page is replaced according to the formula replacement engine to generate a target sheet page; the target sheet page is combined with the report data to generate target report data, and finally the target report data is uploaded to the collaborative platform.
[0053] It can be further seen that the formulas in the newly added sheet page can be replaced according to the formula replacement engine, and the replaced sheet page can be combined with the report data. Finally, the target report data generated after the combination can be uploaded to the collaboration platform. The operation is relatively simple and does not require a large number of manual formula replacement operations, which improves the accuracy of the data and the efficiency of report filling. The report data can be stored and managed online, which can realize data sharing and exchange and make full use of the data value. BRIEF DESCRIPTION OF THE DRAWINGS
[0054] In order to more clearly illustrate the technical solution in the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only 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.
[0055] Figure 1 A flowchart of an embodiment of a report filling method based on a collaborative platform is provided for this application;
[0056] Figure 2 Another embodiment of the method for filling in a report based on a collaborative platform is provided for this application;
[0057] Figure 3 Another embodiment of the method for filling in a report based on a collaborative platform is provided for this application;
[0058] Figure 4 Another embodiment of the method for filling in a report based on a collaborative platform is provided for this application;
[0059] Figure 5 A flowchart of an embodiment of a report filling system based on a collaborative platform is provided for this application;
[0060] Figure 6 A flow chart of an embodiment of a report filling device based on a collaborative platform is provided for this application. DETAILED DESCRIPTION
[0061] It should be noted that the report filling method based on the collaborative platform provided in this application can be applied to a terminal, a system, or a server. For example, the terminal can be a smart phone or a computer, a tablet computer, a portable computer terminal, or a fixed terminal such as a desktop computer. For the convenience of explanation, this application uses the terminal as an example for explanation.
[0062] See also Figure 1 The present application provides an embodiment of a report filling method based on a collaborative platform, the embodiment comprising:
[0063] 101. Obtaining an accounting plan in the collaboration platform, wherein the accounting plan includes report data and accounting content;
[0064] In the embodiment of the present application, a variety of accounting schemes will be saved in the collaboration platform. When obtaining an accounting scheme, it is necessary to query the relevant accounting scheme information from the database of the collaboration platform and ensure that the latest version or the user-specified version is obtained. The accounting scheme is stored in formats such as XML or JSON. When files in the above formats are obtained on the collaboration platform, these formats need to be parsed to obtain the specific content of the accounting scheme. The accounting scheme contains important information such as the structure, format, and accounting method of the report data. The obtained accounting scheme is the basis for subsequent processing, and the newly added sheet pages can be correctly processed and calculated according to the accounting scheme.
[0065] 102. When receiving a request for adding a sheet page to the report data, obtaining content information of the added sheet page;
[0066] In an embodiment of the present application, when a request for adding a new sheet page is received, the identity and authority of the requester need to be verified to ensure that only authorized users or systems can initiate such a request. After the verification, the content information of the new sheet page is further obtained, and the data, format, formula and other information of the sheet page are obtained from the content information of the new sheet page, and stored in an appropriate data structure for subsequent use. After obtaining the content information of the new sheet page, the obtained content information needs to be further parsed, that is, step 103 is executed.
[0067] 103. Parse the content information of the newly added sheet page;
[0068] In the embodiment of the present application, the newly added sheet page content is parsed to extract key data, format, formula and other information from it. Specifically, according to the specific format of the sheet page, such as Excel, CSV, etc., ApachePOI, OpenXML4J or CSV parser is selected, and the above tools are used to extract key data, format, formula and other information from it.
[0069] Read and parse the sheet page content, parse the sheet page to identify and separate different types of data such as text, numbers, dates, etc., and further extract the formulas in the sheet page and parse them further to ensure that the structure and content of the formulas in the sheet page are correctly captured. The parsed data is usually stored in a structured form, such as an object, dictionary, or database table, for subsequent processing and access.
[0070] It should be noted that the formula in the sheet page is parsed into its components and structure for subsequent replacement or verification.
[0071] 104. Obtaining an application formula in the content information of the newly added sheet page according to the analysis result;
[0072] In an embodiment of the present application, the application formula in the sheet page content is obtained from the parsing result for subsequent formula replacement or verification, wherein the application formula is a key formula for calculation or data processing in the sheet page. Specifically, in the parsed data structure, the part containing the application formula is located, which is usually a specific field or attribute for storing the application formula in the cell, and then all the application formulas are extracted from the parsed data structure, and the application formulas are stored in a separate collection or list for subsequent processing.
[0073] For each extracted application formula, its structure and content need to be further parsed, including identifying the components of the application formula, such as function name, parameters, operators, etc., and determining the calculation order and dependencies of the application formula.
[0074] 105. Determine whether the application formula is a formula that needs to be replaced according to the calculation content;
[0075] In an embodiment of the present application, after extracting the application formulas in the sheet page, it is determined whether the application formulas in the newly added sheet page need to be replaced according to the accounting content in the accounting plan, so as to meet the calculation requirements of the newly added sheet. Specifically, it is first necessary to clarify the specific content and requirements of the accounting in the accounting content, wherein the specific content and requirements of the accounting come from business needs, industry specifications or internal management regulations, etc. This part of information is entered into the collaboration platform and is stored in the collaboration platform. Further, the accounting content is analyzed to determine whether the extracted application formula needs to be replaced. It should be noted that multiple application formulas are extracted, and when determining whether replacement is required, the application formula needs to be judged and analyzed.
[0076] Furthermore, each extracted application formula is compared with the accounting rules, including checking whether the function name, parameters or operators of the application formula meet the requirements. If the application formula uses an unallowed function or operation, or its structure does not conform to the accounting rules, or does not conform to the accounting content, the application formula may need to be replaced.
[0077] Before replacing the applied formula, the dependencies and calculation order of the applied formula must be analyzed to ensure that the replacement operation does not destroy the overall structure and calculation results of the report.
[0078] Therefore, when it is determined according to the calculation content that the application formula is a formula that needs to be replaced, step 106 is executed.
[0079] 106. Replace the application formula in the newly added sheet page according to a formula replacement engine to generate a target sheet page, wherein the formula replacement engine includes a formula replacement rule;
[0080] In an embodiment of the present application, when it is determined that the application formula is a formula that needs to be replaced based on the accounting content, the application formula in the newly added sheet page is replaced according to the formula replacement engine. Specifically, the formula replacement engine can recognize the formula in the Excel table. The formula replacement engine will search for the formula that matches the search content in the entire worksheet or specified area. There are many different formulas and replacement rules saved in the formula replacement engine. Therefore, when it is found that the application formula in the newly added sheet page needs to be replaced, the formula replacement engine will first match the position of the application formula that needs to be replaced, and then the formula replacement engine will perform the replacement operation according to the replacement content, that is, the new formula or text, and replace the new formula or text to the position of the original application formula.
[0081] In addition to replacing basic formulas, the formula replacement engine can also handle related logical judgments for situations where replacement based on conditions is required. For example, the IF function can be combined with other search and replace functions such as SEARCH and FIND to implement search and replacement based on specific conditions.
[0082] The formula replacement engine can also handle errors or exceptions that may occur during the replacement process, such as unrecognizable formula formats, circular references, etc., and provide corresponding error prompts or solutions.
[0083] By replacing the formulas that need to be modified, you can ensure that the data in the report is calculated according to the latest accounting requirements or standards, thereby improving the accuracy of the data. Compared with manually finding and replacing formulas, using automated tools or methods, such as Excel's find and replace function, VLOOKUP function, macros, etc., can greatly improve work efficiency and reduce human errors.
[0084] After replacing the applied formula in the newly added sheet page through the formula replacement engine, a target sheet page can be generated after the replacement. The replaced formula is saved in the target sheet page, and content information is also calculated based on the formula in the target sheet page.
[0085] 107. Combining the target sheet page with the report data to generate target report data;
[0086] In an embodiment of the present application, the target sheet page after the formula is replaced is combined with the original report data to generate new target report data that meets the accounting requirements. When combining the target sheet page and the original report data, the consistency of the data structure and format must be ensured. After the combination is completed, the target report data will be verified and tested to ensure the accuracy and completeness of the data.
[0087] 108. Upload the target report data to the collaboration platform.
[0088] In an embodiment of the present application, the generated target report data will be used for subsequent uploading to the collaboration platform for use or analysis by users or systems.
[0089] By processing the request for adding a new sheet page to the report data in the collaboration platform, necessary replacements are made to the application formulas therein to ensure that the report data meets the specific accounting content requirements, thereby improving the efficiency and accuracy of report data processing and reducing the workload of staff.
[0090] See also Figure 2 The present application provides another embodiment of a report filling method based on a collaborative platform, the embodiment comprising:
[0091] 201. Obtaining an accounting plan in the collaboration platform, wherein the accounting plan includes report data and accounting content;
[0092] In the embodiment of the present application, step 201 is similar to the scheme of the aforementioned step 101 and will not be described again here.
[0093] 202. Obtaining a formula type in the calculation scheme;
[0094] In the embodiment of the present application, the accounting scheme is obtained from the collaboration platform, and the formula types used are identified and extracted from the accounting scheme. These formula types usually reflect different data processing logic and calculation rules. By clarifying the formula type, the formulas can be classified, sorted and processed more effectively.
[0095] Among them, formula types are usually divided according to the function, purpose or structure of the formula. For example, sum formula, average formula, maximum formula, etc. can all be regarded as different formula types. In the process of extracting formula types, regular expressions or text parsing tools are needed.
[0096] The extracted formula types need to be classified and organized for subsequent use. The organization process includes removing duplicate items, merging similar items, or sorting the formula types in a certain order.
[0097] 203. Arrange the first letters of the formula types in order;
[0098] In an embodiment of the present application, the first letters of the extracted formula types are arranged in order. By arranging the first letters of the formula types in order, the consistency and predictability of the processing process can be ensured, which facilitates subsequent data processing and analysis.
[0099] Specifically, first, it is necessary to obtain the extracted formula type list from step 202. This list should contain all formula types defined in the accounting plan, and then sort them by the first letter of the formula type. If the first letters are the same, the second letter can be compared, and so on.
[0100] After the sorting is complete, verify the results to ensure that the formula types have been correctly sorted in alphabetical order, either through manual inspection or using automated test scripts.
[0101] It should be noted that when performing sorting operations, uppercase and lowercase letters are considered the same. If the formula type contains special characters, such as numbers, spaces, punctuation marks, etc., choose to ignore them.
[0102] 204. Identify cells in the report data respectively according to the arrangement order, and extract formula text;
[0103] In the embodiment of the present application, the purpose of step 204 is to traverse the cells in the report data according to the order of formula types sorted in step 203, and identify and extract the formula text in the cells containing the formula.
[0104] Specifically, first, a list of formula types that have been arranged in alphabetical order is obtained from step 203. The list of formula types will be used as a basis for subsequent traversal and identification of formulas in cells. Then, all cells in the report data are traversed, which can be achieved through a loop structure in a programming language, such as a for loop or a while loop. In the process of traversing the cells, which cells contain formulas are identified. This can be done by checking whether the content of the cell starts with a specific formula prefix (such as "=" in Excel), or by using a regular expression to match the formula pattern.
[0105] Once it is identified that a cell contains a formula, the text of the formula is extracted, which can be achieved by intercepting the part of the cell content starting from the formula prefix to the end. The extracted formula text needs to be classified according to the formula type sorted in step 203, and finally, the extracted and classified formula text is stored in an appropriate data structure, such as a list, a dictionary or a database, etc., for subsequent data processing and analysis.
[0106] 205. Classify and sort the formula text according to the row number or column number in the cell to obtain the formula list;
[0107] In the embodiment of the present application, the purpose of step 205 is to classify and sort the formula text extracted and classified in step 204 according to the row number or column number in the report data, and finally obtain an ordered formula list.
[0108] Specifically, first, it is necessary to obtain the formula text that has been extracted and classified into each formula type from step 204, and then classify and sort the formula text according to the row number or column number of the cell. Usually, it can be sorted from small to large or from large to small according to the row number, or when the row numbers are the same, it can be sorted according to the column number.
[0109] In the process of classifying and sorting formula text, you can use the sorting function to implement this step. The sorting result should be a list of formula texts arranged in order of row and column numbers.
[0110] After classification and sorting are completed, the results need to be verified to ensure that the formula text has been arranged in the correct order and is consistent with the actual layout of the report data. This step can be completed through manual inspection or using automated test scripts.
[0111] Finally, the classified and sorted formula text list is output as a final formula list, which contains all the formulas in the accounting plan.
[0112] 206. When receiving a request for adding a sheet page to the report data, obtaining content information of the added sheet page;
[0113] 207. Parse the content information of the newly added sheet page;
[0114] 208. Obtaining an application formula in the content information of the sheet page according to the analysis result;
[0115] 209. Determine whether the application formula is a formula that needs to be replaced according to the calculation content;
[0116] In the embodiment of the present application, steps 206 to 209 are similar to the aforementioned steps 102 to 105 and are not described again here.
[0117] 210. Determine an application formula replacement rule, wherein the application formula rule includes formula reference replacement, function replacement, variable replacement, and algorithm replacement;
[0118] 211. Integrate the application formula replacement rule and the formula list into the formula replacement engine;
[0119] 212. Replace the application formula in the newly added sheet page according to the formula replacement engine to generate a target sheet page;
[0120] In an embodiment of the present application, after determining the application formula replacement rule, the application formula replacement rule and the formula list obtained in step 205 are integrated into a formula replacement engine, and the formula replacement engine includes formula rules, which include reference replacement, function replacement, variable replacement, and algorithm replacement, etc., which are not specifically limited here. The role and description of the formula replacement engine are in the aforementioned embodiments and descriptions, and will not be repeated here. Finally, the application formula in the newly added sheet page is replaced according to the formula replacement engine to generate a target sheet page.
[0121] 213. Combining the target sheet page with the report data to generate target report data;
[0122] 214. Upload the target report data to the collaboration platform.
[0123] In the embodiment of the present application, step 213 to step 214 are similar to the aforementioned step 107 to step 108 and are not described in detail here.
[0124] 215. Backing up the target report data;
[0125] 216. Convert the target report data into formatted data and upload the formatted data to a database.
[0126] In the embodiment of the present application, after uploading the target report to the collaboration platform, the target report will be backed up. After the back-up, when the original file has problems later, it can be restored through the backup file. And after the target report data is converted into formatted data, it is uploaded to the database to facilitate the subsequent call of the target report data.
[0127] See also Figure 3 , when receiving a request for adding a sheet page to the report data, obtaining content information of the added sheet page,
[0128] 301. When receiving a request for adding a sheet page to the report data, determining whether the request for adding the sheet page is from a legitimate source;
[0129] 302. If yes, obtain the content information of the newly added sheet page;
[0130] 303. If not, trace the request source of the newly added sheet page, and upload the tracing report to the collaboration platform.
[0131] In an embodiment of the present application, by performing a legal source check on the request for a newly added sheet page, the security of the content information of the newly added sheet page can be further guaranteed. Only when the source of the request for the newly added sheet page is legal, the content information of the newly added sheet page is obtained. When the source of the request for the newly added sheet page is illegal, the source of the request for the newly added sheet page will be checked, and a tracing report will be uploaded to the collaboration platform to facilitate the tracing of the source of the request to protect the security of the content information of the newly added sheet page.
[0132] See also Figure 4 According to some embodiments of the present invention, determining whether the application formula is a formula that needs to be replaced according to the calculation content may specifically include, but is not limited to, the following:
[0133] 401. Obtain the accounting content in the accounting scheme, where the accounting content includes an output value type and a calculation formula;
[0134] 402. Determine whether the application formula is a formula that needs to be replaced according to the calculation content;
[0135] 403. If not, combining the sheet page containing the application formula with the report data to generate application report data;
[0136] 404. Upload the application report data to the collaboration platform.
[0137] In an embodiment of the present application, when it is determined that the application formula is a formula that does not need to be replaced, there is no need to replace the formula. The sheet page containing the application formula is directly combined with the report data to generate application report data, and the application report data is uploaded to the collaboration platform for storage.
[0138] See also Figure 5 The present application provides an embodiment of a report filling system based on a collaborative platform, the embodiment comprising:
[0139] The first acquisition unit 501 is used to acquire an accounting plan in the collaboration platform, wherein the accounting plan includes report data;
[0140] The second acquisition unit 502 is configured to acquire content information of a newly added sheet page when receiving a request for adding a sheet page to the report data;
[0141] A parsing unit 503 is used to parse the content information of the newly added sheet page;
[0142] A third acquisition unit 504 is used to acquire the application formula in the content information of the sheet page according to the parsing result;
[0143] A judging unit 505, configured to judge whether the application formula is a formula that needs to be replaced according to the calculation content;
[0144] A replacement unit 506, configured to replace the application formula in the newly added sheet page according to a formula replacement engine to generate a target sheet page when the judgment unit determines that the application formula is a formula that needs to be replaced, wherein the formula replacement engine includes a formula replacement rule;
[0145] A generating unit 507, configured to combine the target sheet page with the report data to generate target report data;
[0146] The uploading unit 508 is used to upload the target report data to the collaboration platform.
[0147] See also Figure 6 The present application also provides a report filling device based on the collaborative platform, including:
[0148] Processor 601, memory 602, input and output unit 603, bus 604;
[0149] The processor 601 is connected to the memory 602, the input and output unit 603 and the bus 604;
[0150] The memory 602 stores a program, and the processor 601 calls the program to execute any of the above methods.
[0151] The present application also relates to a computer-readable storage medium on which a program is stored, wherein when the program is run on a computer, the computer is caused to execute any of the above methods.
[0152] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.
[0153] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, which can be electrical, mechanical or other forms.
[0154] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0155] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.
[0156] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions to enable a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, read-only memory), random access memory (RAM, random access memory), disk or optical disk and other media that can store program code.
Claims
1. A report filling method based on a collaborative platform, characterized in that: The method comprises: Obtaining an accounting plan in the collaboration platform, wherein the accounting plan includes report data and accounting content; Obtaining the formula type in the accounting scheme; Arrange the first letters of the formula types in order; Respectively identifying cells in the report data in the order of the arrangement, and extracting formula text; The formula texts are classified and sorted according to the row numbers or column numbers in the cells to obtain a formula list; When receiving a request for adding a sheet page to the report data, obtaining content information of the added sheet page; Parsing the content information of the newly added sheet page; Obtain the application formula in the content information of the newly added sheet page according to the analysis result; Acquire the calculation content in the calculation scheme, wherein the calculation content includes the output value type and calculation formula; Determining whether the application formula is a formula that needs to be replaced according to the calculation content; If yes, then replacing the application formula in the newly added sheet page according to a formula replacement engine to generate a target sheet page, wherein the formula replacement engine includes a formula replacement rule; Combining the target sheet page with the report data to generate target report data; Uploading the target report data to the collaboration platform; The replacing the application formula in the newly added sheet page according to the formula replacement engine to generate a target sheet page includes: Determine application formula replacement rules, wherein the application formula rules include formula reference replacement, function replacement, variable replacement, and algorithm replacement; Integrating the application formula replacement rule and the formula list into the formula replacement engine, wherein the formula replacement engine includes the formula replacement rule; The application formula in the newly added sheet page is replaced according to the formula replacement engine to generate a target sheet page.
2. The report filling method based on the collaborative platform according to claim 1 is characterized in that: When receiving a request for adding a sheet page to the report data, obtaining content information of the added sheet page includes: When receiving a request for adding a sheet page to the report data, determining whether the request for adding the sheet page is from a legitimate source; If yes, obtain the content information of the newly added sheet page; If not, trace the request source of the newly added sheet page, and upload the tracing report to the collaboration platform.
3. The report filling method based on the collaborative platform according to claim 1 is characterized in that: After determining whether the application formula is a formula that needs to be replaced according to the calculation content, the method further includes: If not, combining the sheet page containing the application formula with the report data to generate application report data; The application report data is uploaded to the collaboration platform.
4. The report filling method based on the collaborative platform according to claim 1 is characterized in that: After uploading the target report data to the collaboration platform, the method further includes: Backing up the target report data; The target report data is converted into formatted data and uploaded to the database.
5. A report filling system based on a collaborative platform, characterized in that: The system comprises: A first acquisition unit is used to acquire an accounting plan in the collaboration platform, wherein the accounting plan includes report data and accounting content; A second acquisition unit, used to acquire the formula type in the accounting scheme; an arrangement unit, used to arrange the first letters of the formula types in order; An extraction unit, used to respectively identify cells in the report data according to the arrangement order, and extract formula text; A third acquisition unit is used to classify and sort the formula text according to the row number or column number in the cell to obtain a formula list; A fourth acquisition unit, configured to acquire content information of a newly added sheet page when receiving a request for adding a sheet page to the report data; A parsing unit, used for parsing the content information of the newly added sheet page; A fifth acquisition unit, configured to acquire an application formula in the content information of the newly added sheet page according to the parsing result; A sixth acquisition unit, configured to acquire the accounting content in the accounting scheme, wherein the accounting content includes an output value type and a calculation formula; A judging unit, used for judging whether the applied formula is a formula that needs to be replaced according to the calculation content; A replacement unit, configured to determine an application formula replacement rule when the judgment unit determines that the application formula is a formula that needs to be replaced, wherein the application formula rule includes formula reference replacement, function replacement, variable replacement, and algorithm replacement; integrate the application formula replacement rule and the formula list into a formula replacement engine, wherein the formula replacement engine includes formula replacement rules; replace the application formula in the newly added sheet page according to the formula replacement engine to generate a target sheet page, wherein the formula replacement engine includes formula replacement rules; A generating unit, used for combining the target sheet page with the report data to generate target report data; The uploading unit is used to upload the target report data to the collaboration platform.
6. A report filling device based on a collaborative platform, characterized in that: The device comprises: Processor, memory, input-output unit, and bus; The processor is connected to the memory, the input and output unit, and the bus; The memory stores a program, and the processor calls the program to execute the method according to any one of claims 1 to 4.
7. A computer-readable storage medium having a program stored thereon, wherein the program, when executed on a computer, performs the method according to any one of claims 1 to 4.
Citation Information
Patent Citations
System for automatically generating report from industrial data
CN111538731A
Excel analysis method and system based on metadata driving
CN112099801A
Table-based data processing method, apparatus and device, and storage medium
CN115169307A
Excel report processing method and device
CN117574866A
Report processing method and system and storage medium
CN117892705A
