Data processing method and data processing system

Abstract

The invention provides a data processing method and a data processing system, which are applied to a client, and the method comprises the following steps: obtaining a new cell value of each changed target cell in response to a table editing operation of a user for a target table; according to the identifier of each target cell and the new cell value of each target cell, updating a variable value of a table variable corresponding to the target table to obtain a new variable value; determining a table name, a table header parameter and a query parameter in response to a table export operation of a user for the target table; generating an export request according to the new variable value, the header parameter and the query parameter, and sending the export request to a server; and receiving table file data generated by the server based on the export request, and storing the target table according to the table file data and the table name in response to a table storage operation of a user for the target table, so that efficient and dynamic export of the target table edited by the client is realized.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and more specifically, to a data processing method and a data processing system. Background Technology

[0002] In the field of low-code development, tables are a core component for data display, interaction, and export, and downloading tables is a frequent requirement for enterprise applications. With the development of front-end technologies, tables have evolved from simple data display to a composite form that combines data display, online editing, and dynamic calculation. Users can input data online or complete numerical conversions, summaries, and other operations through preset formulas. This real-time updated dynamic data is only stored in front-end variables and is not synchronized to the back-end database.

[0003] Currently, the mainstream export solution is backend database query-based export. After a user triggers the export, the backend queries the database for raw data via an interface, populates it into a spreadsheet (e.g., Excel) template, and returns it to the frontend. This approach cannot adapt to dynamic interactive scenarios, resulting in inconsistencies between the exported data and the real-time editing or calculation results on the frontend. Furthermore, the secondary database query on the backend increases database pressure and network overhead, leading to low export efficiency. To synchronize frontend data during export, additional interfaces need to be developed, increasing system complexity and maintenance costs, making it difficult to meet the core requirements of enterprise-level applications for accurate and efficient spreadsheet export. Summary of the Invention

[0004] The purpose of this application is to address the shortcomings of the prior art by providing a data processing method and system to solve the problem that the backend database query-based export in the prior art cannot meet the actual needs of enterprise applications for the accuracy and efficiency of table export.

[0005] To achieve the above objectives, the technical solutions adopted in the embodiments of this application are as follows: In a first aspect, embodiments of this application provide a data processing method applied to a client, the method comprising: Responding to user table editing operations on the target table, retrieve the new values ​​of each target cell that has changed; Based on the identifier of each target cell and the new value of each target cell, the variable values ​​of the table variables corresponding to the target table are updated to obtain the new variable values; Respond to the user's table export operation for the target table, and determine the table name, header parameters, and query parameters; Based on the new value of the variable, the header parameters, and the query parameters, an export request is generated and sent to the server. Receive the table file data generated by the server based on the export request, and respond to the user's table save operation for the target table. Save the target table according to the table file data and the table name.

[0006] As an optional implementation, obtaining the new cell values ​​of each changed target cell includes: Based on the editing type of each target cell, obtain the new cell value for each target cell.

[0007] As an optional implementation, obtaining the new cell value of each target cell based on its edit type includes: If the editing type of the target cell is input type, then when the data input of the target cell is detected to be completed, the cell data input by the user is trimmed and validated to obtain the new cell value of the target cell; If the editing type of the target cell is formula calculation type, then the pre-set formula function is called to perform the cell formula calculation, the calculation result is obtained, and the calculation result is formatted to obtain the new cell value of the target cell.

[0008] As an optional implementation, updating the variable values ​​of the table variables corresponding to the target table based on the identifiers and new values ​​of each target cell to obtain new variable values ​​includes: Based on the identifier of the target cell, the target parameter item corresponding to the target cell in the table variable is determined, wherein the table variable is represented by a two-dimensional array, and each column parameter of each row of the two-dimensional array is a parameter item, and each parameter item corresponds to a cell in the target table; Assign the new value of the target cell to the target parameter item; After all the variable values ​​in the table have been updated, the new value of the variable is obtained.

[0009] As an optional implementation, the response to a user's table export operation for the target table, determining the table name, header parameters, and query parameters, includes: In response to a user's table export operation for a target table, the loading state is initiated, and the table name is generated according to the pre-set table configuration information, wherein the table configuration information is used to indicate whether the table name contains an export prefix and a time suffix; Determine the header type and generate the header parameters based on the header type. The header parameters include dynamic header parameters or static header parameters. The user permission information, query conditions, extended parameters, and session storage parameters are obtained separately, and the user permission information, query conditions, extended parameters, and session storage parameters are integrated into the query parameters.

[0010] As an optional implementation, determining the header type and generating the header parameters based on the header type includes: If the dynamic header function is enabled and a dynamic header interface address exists, then the header type is determined to be a dynamic header, the dynamic header interface address is encapsulated as the dynamic header parameter, and the dynamic header parameter is used as the header parameter. Otherwise, if the header type is determined to be a static header, a deep copy operation is performed on the table column configuration data to obtain the copied column configuration data. Based on the copied column configuration data, the column headers are dynamically bound and converted and then encapsulated as the static header parameters. The static header parameters are then used as the header parameters.

[0011] Secondly, embodiments of this application provide a data processing method applied to a server, the method comprising: Receive an export request sent by the client, parse the export request, and obtain the parsing result, which includes the new values ​​of the table variables, the table header parameters, and the query parameters; Based on the parsing results, a table file of data is generated and sent to the client.

[0012] As an optional implementation, generating the table file data based on the parsing result includes: The new value of the variable is formatted to obtain the converted new value of the variable, and the converted new value of the variable is validated and matched according to the header parameters. After verification and successful field matching, a streaming workbook is created, and a table header is created based on the table header parameters and the query parameters, and the table header format is determined. Based on the new values ​​of the transformed variables, data rows are created row by row in the streaming workbook, and the cell value is filled by calling the set cell value function, and the data row format is determined; Each data row is normalized to obtain a processed streaming workbook, which is then written to a memory output stream. The memory output stream is then converted to a preset format to generate the table file data.

[0013] As an optional implementation, the step of creating data rows row by row in the streaming workbook based on the new values ​​of the transformed variables, and calling the cell value setting function to fill the cell values, includes: Based on the current field in the new value of the converted variable, determine the identifier of the cell to be filled in the current data row of the streaming workbook, wherein each field in the new value of the converted variable corresponds to a cell in the streaming workbook; The function to set cell value is invoked to assign the value of the current field to the cell to be filled.

[0014] Thirdly, embodiments of this application provide a data processing apparatus corresponding to a data processing method executed by a client, the data processing apparatus comprising: The retrieval module is used to respond to user table editing operations on the target table and retrieve the new values ​​of each target cell that has changed. The update module is used to update the variable values ​​of the table variables corresponding to the target table based on the identifier of each target cell and the new value of each target cell, so as to obtain the new variable values; The determination module is used to respond to the user's table export operation for the target table, and to determine the table name, table header parameters, and query parameters; The generation module is used to generate an export request based on the new value of the variable, the header parameters, and the query parameters, and send the export request to the server. The save module is used to receive the table file data generated by the server based on the export request, and respond to the user's table save operation for the target table, and save the target table according to the table file data and the table name.

[0015] As an optional implementation, the acquisition module is specifically used for: Based on the editing type of each target cell, obtain the new cell value for each target cell.

[0016] As an optional implementation, the acquisition module is specifically used for: If the editing type of the target cell is input type, then when the data input of the target cell is detected to be completed, the cell data input by the user is trimmed and validated to obtain the new cell value of the target cell; If the editing type of the target cell is formula calculation type, then the pre-set formula function is called to perform the cell formula calculation, the calculation result is obtained, and the calculation result is formatted to obtain the new cell value of the target cell.

[0017] As an optional implementation, the update module is specifically used for: Based on the identifier of the target cell, the target parameter item corresponding to the target cell in the table variable is determined, wherein the table variable is represented by a two-dimensional array, and each column parameter of each row of the two-dimensional array is a parameter item, and each parameter item corresponds to a cell in the target table; Assign the new value of the target cell to the target parameter item; After all the variable values ​​in the table have been updated, the new value of the variable is obtained.

[0018] As an optional implementation, the determining module is specifically used for: In response to a user's table export operation for a target table, the loading state is initiated, and the table name is generated according to the pre-set table configuration information, wherein the table configuration information is used to indicate whether the table name contains an export prefix and a time suffix; Determine the header type and generate the header parameters based on the header type. The header parameters include dynamic header parameters or static header parameters. The user permission information, query conditions, extended parameters, and session storage parameters are obtained separately, and the user permission information, query conditions, extended parameters, and session storage parameters are integrated into the query parameters.

[0019] As an optional implementation, the determining module is specifically used for: If the dynamic header function is enabled and a dynamic header interface address exists, then the header type is determined to be a dynamic header, the dynamic header interface address is encapsulated as the dynamic header parameter, and the dynamic header parameter is used as the header parameter. Otherwise, if the header type is determined to be a static header, a deep copy operation is performed on the table column configuration data to obtain the copied column configuration data. Based on the copied column configuration data, the column headers are dynamically bound and converted and then encapsulated as the static header parameters. The static header parameters are then used as the header parameters.

[0020] Fourthly, embodiments of this application provide a data processing apparatus corresponding to a data processing method executed by a server, the data processing apparatus comprising: The parsing module is used to receive the export request sent by the client, parse the export request, and obtain the parsing result, which includes the new values ​​of the table variables, the table header parameters, and the query parameters. The generation module is used to generate table file data based on the parsing results and send the table file data to the client.

[0021] As an optional implementation, the generation module is specifically used for: The new value of the variable is formatted to obtain the converted new value of the variable, and the converted new value of the variable is validated and matched according to the header parameters. After verification and successful field matching, a streaming workbook is created, and a table header is created based on the table header parameters and the query parameters, and the table header format is determined. Based on the new values ​​of the transformed variables, data rows are created row by row in the streaming workbook, and the cell value is filled by calling the set cell value function, and the data row format is determined; Each data row is normalized to obtain a processed streaming workbook, which is then written to a memory output stream. The memory output stream is then converted to a preset format to generate the table file data.

[0022] As an optional implementation, the generation module is specifically used for: Based on the current field in the new value of the converted variable, determine the identifier of the cell to be filled in the current data row of the streaming workbook, wherein each field in the new value of the converted variable corresponds to a cell in the streaming workbook; The function to set cell value is invoked to assign the value of the current field to the cell to be filled.

[0023] Fifthly, embodiments of this application provide an electronic device, which is either the client or the server. The electronic device includes a processor, a memory, and a bus. The memory stores machine-readable instructions executable by the processor. When the electronic device is running, the processor communicates with the memory via the bus, and the processor executes the machine-readable instructions to perform the method steps as described in the first aspect or the second aspect of the above-described client or server.

[0024] Sixthly, embodiments of this application provide a data processing system, which includes a client and a server; The client is used to execute the data processing method described in the first aspect above; The server is used to execute the data processing method described in the second aspect above.

[0025] The beneficial effects of this application are: This application provides a data processing method and system. The client responds to a user's table editing operation on a target table, obtains the new values ​​of each changed target cell, updates the values ​​of the corresponding table variables based on the identifiers and new values ​​of each target cell, and then responds to the user's table export operation on the target table, determining the table name, header parameters, and query parameters. Based on the new variable values, header parameters, and query parameters, the client generates an export request and sends it to the server. The server parses the export request, obtains the new values ​​of the table variables, header parameters, and query parameters, generates table file data based on these parameters, and sends the table file data to the client. The client responds to the user's table save operation on the target table, saving the user-edited target table based on the table file data and the table name. Since the new values ​​of the table variables corresponding to the target table integrate the original data and the changed data in the target table, the new values ​​of the variables are used as the data source for exporting the edited target table. This ensures that the data in the exported edited target table is consistent with the data in the user-edited target table displayed on the client. This enables dynamic and efficient export of the edited target table from the client without querying the database. Attached Figure Description

[0026] To more clearly illustrate the technical solutions of the embodiments of this application, the accompanying drawings used in the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of this application and should not be regarded as a limitation of the scope. For those skilled in the art, other related drawings can be obtained based on these drawings without creative effort.

[0027] Figure 1 This is a schematic diagram of the architecture of the data processing system provided in the embodiments of this application; Figure 2 Flowchart of the data processing method provided in the embodiments of this application Figure 1 ; Figure 3 Flowchart of the data processing method provided in the embodiments of this application Figure 2 ; Figure 4 Flowchart of the data processing method provided in the embodiments of this application Figure 3 ; Figure 5 Flowchart of the data processing method provided in the embodiments of this application Figure 4 ; Figure 6 Flowchart of the data processing method provided in the embodiments of this application Figure 5 ; Figure 7Flowchart of the data processing method provided in the embodiments of this application Figure 6 ; Figure 8 Flowchart of the data processing method provided in the embodiments of this application Figure 7 ; Figure 9 A module structure diagram of a data processing device provided in an embodiment of this application; Figure 10 A module structure diagram of another data processing apparatus provided in the embodiments of this application; Figure 11 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application. Detailed Implementation

[0028] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. It should be understood that the accompanying drawings in this application are for illustrative and descriptive purposes only and are not intended to limit the scope of protection of this application. Furthermore, it should be understood that the schematic drawings are not drawn to scale. The flowcharts used in this application illustrate operations implemented according to some embodiments of this application. It should be understood that the operations in the flowcharts may not be implemented in sequence, and steps without logical contextual relationships may be reversed or implemented simultaneously. In addition, those skilled in the art, guided by the content of this application, may add one or more other operations to the flowcharts, or remove one or more operations from the flowcharts.

[0029] Furthermore, the described embodiments are merely some, not all, of the embodiments of this application. The components of the embodiments of this application described and illustrated herein can typically be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of this application provided in the accompanying drawings is not intended to limit the scope of the claimed application, but merely to illustrate selected embodiments of the application. All other embodiments obtained by those skilled in the art based on the embodiments of this application without inventive effort are within the scope of protection of this application.

[0030] It should be noted that the term "comprising" will be used in the embodiments of this application to indicate the presence of the features declared thereafter, but does not exclude the addition of other features.

[0031] In the low-code development field, downloading spreadsheets is a frequent requirement for enterprise applications. Spreadsheets have evolved from simple data display to a composite format encompassing data display, online editing, and dynamic calculations. Users can input data online or perform numerical conversions and summary statistics using preset formulas. This real-time updated dynamic data is stored only in front-end variables and is not synchronized to the back-end database. Current mainstream export solutions rely on back-end database query-based export, which cannot adapt to dynamic interactive scenarios, resulting in inconsistencies between exported data and front-end real-time editing or calculation results. Furthermore, secondary back-end database queries increase database pressure and network overhead, leading to low export efficiency. Synchronizing front-end data during export requires additional interface development, increasing system complexity and maintenance costs, making it difficult to meet the core requirements of enterprise applications for accurate and efficient spreadsheet export.

[0032] Based on the above-mentioned problems, this application provides a data processing method that integrates the original data, formula calculation results, and online input data in the target table of the client through the new values ​​of the table variables. The server does not need to query the database and can directly achieve efficient and dynamic export of the target table after editing by the client based on the new values ​​of the table variables.

[0033] Figure 1 This is a schematic diagram of the architecture of the data processing system provided in the embodiments of this application, such as... Figure 1 As shown, the data processing system includes a client and a server.

[0034] The client is the local terminal that the user directly operates; that is, the client is the front end. The server runs on a remote server; that is, the server is the back end.

[0035] Specifically, the client responds to user input operations or formula calculations in the table cells, storing / updating the resulting real-time data in table variables. This makes the table variables the sole data carrier of the table, integrating the original data, input data, and formula calculation results. The client also responds to user export requests for the target table, sending an export request containing the table variables to the server.

[0036] The server generates a table file based on the export request carrying table variables and sends it to the client. This table file data includes the original data, input data, and formula calculation results from the table, matching the data displayed on the client. The client responds to the user's save operation for the target table and saves the table based on the table file data.

[0037] Since the data in the table file is consistent with the data in the table displayed on the client, without the need for the server to query the database, the table variables carried in the export request sent by the client to the server ensure that the exported table is consistent with the user-edited table displayed on the client. This allows for the dynamic and efficient export of the client-edited table.

[0038] Figure 2 Flowchart of the data processing method provided in the embodiments of this application Figure 1 Taking the interaction between the client and server in a data processing system as an example, the flow of the data processing method is explained. Figure 2 As shown, the method includes: S101. The client responds to the user's table editing operation on the target table and obtains the new values ​​of each target cell that has changed.

[0039] Optionally, the user performs table editing operations on the target table displayed on the client. The client responds to the table editing operation, identifies each target cell that has changed, and accurately captures the user's editing results for each target cell in the target table, thereby obtaining the new cell value of each target cell.

[0040] The new value of the cell is the new value of the target cell after being edited by the user.

[0041] S102. The client updates the variable values ​​of the table variables corresponding to the target table based on the identifier of each target cell and the new value of each target cell, and obtains the new variable values.

[0042] Optionally, the client updates the new cell value of each target cell to the corresponding table variable of the target table based on the identifier of each target cell. For example, the table variable corresponding to the target table can be... .

[0043] Specifically, the client adjusts the table variables corresponding to the target table based on the identifier of each target cell and the new value of each target cell. The corresponding variable value is updated to obtain the new value of the variable.

[0044] Among them, the table variables corresponding to the target table The table variable is the sole data carrier for the target table. After the variable values ​​are updated to the new values, the original data in the target table (i.e., the data in each cell that has not been edited by the user) and the changed data (i.e., the new cell values ​​of each target cell that have been changed by the user) are integrated.

[0045] Through the table variables corresponding to the target table The new value of the variable in the client will temporarily store the user's editing results for the target table in the front-end variable (i.e., the table variable corresponding to the target table in the client). In this context, the new values ​​of variables can serve as the data source for the subsequently exported and edited target table, ensuring that the data in the exported and edited target table is consistent with the data in the user-edited target table displayed on the client side.

[0046] S103. The client responds to the user's table export operation for the target table, determining the table name, header parameters, and query parameters.

[0047] Optionally, the user clicks the export button or export control displayed on the client page to export the target table. The client responds to the table export operation and confirms the export configuration information.

[0048] The exported configuration information may include the table name, table header parameters, and query parameters. The table name is used to determine the name of the target table to be exported, the header parameters are used to determine the header configuration of the target table to be exported, and the query parameters are used to determine the table name. This is used to supplement auxiliary configuration information for the target table to be exported, such as export time range, permissions, data format, etc.

[0049] S104. The client generates an export request based on the new variable values, table header parameters, and query parameters.

[0050] Optionally, the client will use the table variables corresponding to the target table. New values ​​for variables, header parameters, and query parameters in the table. Encapsulate it as export request parameters.

[0051] Among the export request parameters, the core data is the new values ​​of the variables, and the auxiliary data consists of the table header parameters and query parameters. .

[0052] The client generates an export request based on the export request parameters, which include the table variables corresponding to the target table. New values ​​for variables, header parameters, and query parameters in the table. .

[0053] S105. The client sends the export request to the server.

[0054] Optionally, the client sends an export request to the server via network communication, and the server receives the export request from the client.

[0055] Among these, the core data in the export request parameters carried by the export request is the table variable corresponding to the target table. It can be used as a data source for exporting the edited target table.

[0056] S106. The server parses the export request and obtains the parsing results, which include the new values ​​of the table variables, the table header parameters, and the query parameters.

[0057] Optionally, the server parses the export request sent by the client to obtain the parsing result, which is the table variable corresponding to the target table. New values ​​for variables, header parameters, and query parameters in the table. .

[0058] Among them, the table variables corresponding to the target table To export the data source, header parameters, and query parameters of the edited target table. This is used to determine auxiliary configuration information such as the header configuration, export time range, permissions, and data format of the target table to be exported.

[0059] S107. The server generates table file data based on the parsing results.

[0060] Optionally, the server determines the table variables corresponding to the parsed target table. New values ​​for variables, header parameters, and query parameters in the table. It generates style-specific table file data based on the Streaming eXtensible Markup Language SpreadSheet Format Workbook (SXSSFWorkbook).

[0061] Because the table variable corresponding to the target table The new values ​​of the variables integrate the original data (i.e., the data in each cell that has not been edited by the user) and the changed data (i.e., the new values ​​of each target cell that have been edited by the user). The server does not need to query the database; it can obtain the new values ​​from the table variables corresponding to the target table. The new variable value efficiently and accurately exports the edited table data displayed on the client to the table file data, that is, efficiently and accurately exports the edited table data displayed on the client, realizing what you see is what you export.

[0062] S108. The server sends the table file data to the client.

[0063] Optionally, the server sends the table file data to the client through network communication, and the client receives the table file data from the server.

[0064] The table file data is in Base64 format, meaning the table file data contains Base64 formatted strings.

[0065] S109. The client responds to the user's table save operation for the target table, and saves the target table based on the table file data and the table name.

[0066] Optionally, after receiving the table file data, the client decodes the Base64 format string into a Binary Large Object (Blob), creates a download link, and triggers the table download mechanism. Users can perform table saving operations such as setting the local save path for the target table on the client page. The client responds to the table saving operation by generating an Excel file based on the Blob converted from the table file data, and stores the Excel file in the local save path set by the user after naming it with the table name. In other words, the target table edited by the user is stored locally on the client.

[0067] In this embodiment, the client responds to the user's table editing operation on the target table, obtains the new values ​​of each changed target cell, updates the variable values ​​of the corresponding table variables based on the identifiers and new values ​​of each target cell, obtains the new variable values, and responds to the user's table export operation on the target table, determines the table name, header parameters, and query parameters, generates an export request based on the new variable values, header parameters, and query parameters, and sends it to the server. The server parses the export request, obtains the new variable values, header parameters, and query parameters, generates table file data based on the new variable values, header parameters, and query parameters, and sends the table file data to the client. The client responds to the user's table save operation on the target table, saving the user-edited target table based on the table file data and table name. Since the new values ​​of the table variables corresponding to the target table integrate the original data and the changed data in the target table, the new values ​​of the variables are used as the data source for exporting the edited target table. This ensures that the data in the exported edited target table is consistent with the data in the user-edited target table displayed on the client. This enables dynamic and efficient export of the edited target table from the client without querying the database.

[0068] As an optional implementation, obtaining the new cell values ​​of each changed target cell in step S101 above includes: Based on the editing type of each target cell, obtain the new cell value for each target cell.

[0069] Optionally, the client identifies the type of editing the user makes on each target cell in the target table, where the editing type can be either an input type or a formula calculation type.

[0070] The client retrieves the new value of each target cell based on the identified edit type and the corresponding new value retrieval method for that edit type.

[0071] In this embodiment, the client obtains the new cell value of each target cell based on the editing type of each target cell, ensuring the accuracy of the new cell value.

[0072] Figure 3 Flowchart of the data processing method provided in the embodiments of this application Figure 2 ,like Figure 2 As shown, the above steps involve obtaining the new cell value for each target cell based on its edit type, including: S201. If the editing type of the target cell is input type, when the data input of the target cell is completed, the cell data entered by the user is trimmed and validated to obtain the new cell value of the target cell.

[0073] Optionally, if the client detects that the edit type of the target cell is input, such as when a user enters data into the target cell, the client can trigger a cell out-of-focus event, such as through... Event monitoring targets the completion of data input in the target cell.

[0074] For example, if the client detects that the user clicks on an area outside the target cell (such as other cells or blank areas of the table) or presses the Enter key, a cell out-of-focus event is triggered, indicating that the data input of the target cell has been completed.

[0075] When the target cell data input is detected as complete, the client trims the user-inputted cell data, removing meaningless characters such as leading and trailing spaces. The trimmed cell data is then validated to obtain valid input data. This validated cell data is then assigned to the table field of the target cell, resulting in the new cell value.

[0076] By trimming and validating the cell data entered by the user, the compliance and validity of the new cell value of the target cell are ensured.

[0077] S202. If the editing type of the target cell is formula calculation type, then the pre-set formula function is called to perform the cell formula calculation, the calculation result is obtained, and the calculation result is formatted to obtain the new cell value of the target cell.

[0078] Optionally, if the client detects that the editing type of the target cell is a formula calculation type, such as when the user modifies the formula dependency field of the target cell, the client triggers formula calculation, calls the pre-set formula function to execute the calculation logic of the cell formula calculation, and obtains the calculation result.

[0079] The client formats the calculation result and assigns it to the table field of the target cell to obtain the new cell value.

[0080] In this embodiment, if the target cell's edit type is input, the client will trim and validate the user-inputted cell data upon detecting the completion of data input, thus obtaining the new value of the target cell. If the target cell's edit type is formula calculation, a pre-set formula function will be called to perform the cell formula calculation, obtain the calculation result, and format the result to obtain the new value of the target cell. This improves the flexibility and accuracy of determining the new value of the target cell.

[0081] Figure 4 Flowchart of the data processing method provided in the embodiments of this application Figure 3 ,like Figure 4 As shown, in step S102 above, the client updates the variable values ​​of the table variables corresponding to the target table based on the identifiers of each target cell and the new values ​​of each target cell, obtaining the new variable values, including: S301. Based on the identifier of the target cell, determine the target parameter item corresponding to the target cell in the table variable. The table variable is represented by a two-dimensional array, and each column of each row of the two-dimensional array is a parameter item, and each parameter item corresponds to a cell in the target table.

[0082] Optionally, the table variable corresponding to the target table It is represented by a two-dimensional array, where each row of the two-dimensional array corresponds to a row of data in the target table, and each column in each row of the two-dimensional array is a parameter item, and each parameter item corresponds to a cell in the target table.

[0083] The client, based on the identifier of the target cell, in the table variable The target parameter item corresponding to the target cell is determined in the middle.

[0084] Specifically, when rendering the target table format on the client side, the target cell in the current editing row is in the table variable. The reference object in is That is, the target parameter item corresponding to the target cell currently being edited is .

[0085] S302. Assign the new value of the target cell to the target parameter item.

[0086] Optionally, the new cell value of the target cell obtained after trimming and validation can be directly assigned to the target parameter item. ,because For the target cell in the table variable The referenced objects in the table can be updated synchronously through the reference relationship. The corresponding variable value.

[0087] S303. After all the variable values ​​in the table have been updated, the new values ​​of the variables are obtained.

[0088] Optionally, when the user has completed the editing operations of all the target cells that need to be edited, and the new value of each target cell has been passed by the corresponding target parameter item... Synchronize updates to table variables Then, the table variables are obtained. The new value of the variable.

[0089] Among them, table variables As the sole data carrier of the target table, all table editing operations (input operations and formula calculation operations) can modify table variables. The variable values ​​are used to obtain the table variables. The new value of the variable. Table variable. The new values ​​of the variables include the original data (i.e., the data in each cell that the user has not edited), the input data, and the formula calculation results, which are consistent with the table data in the edited target table rendered by the client.

[0090] In this embodiment, the client determines the target parameter item corresponding to the target cell in the table variable based on the identifier of the target cell, and assigns the new cell value of the target cell to the target parameter item. After all variable values ​​in the table variable have been updated, the new variable value is obtained. As the sole data carrier of the target table, the table variable can be modified by both input operations and formula calculation operations, ensuring that the new value of the table variable includes the original data, input data, and formula calculation results, which is consistent with the table data in the edited target table rendered by the client.

[0091] Figure 5 Flowchart of the data processing method provided in the embodiments of this application Figure 4 ,like Figure 5 As shown, in step S103 above, the client responds to the user's table export operation for the target table, determining the table name, header parameters, and query parameters, including: S401. Respond to the user's table export operation for the target table, start the loading state, and generate a table name according to the pre-set table configuration information, wherein the table configuration information is used to indicate whether the table name contains an export prefix and a time suffix.

[0092] Optionally, the client responds to the user's table export operation for the target table by starting a loading state, such as graying out the download or export button (or control) and displaying a loading spinning circle, to prevent the user from triggering the table export multiple times in a short period of time, thereby avoiding the server receiving the same export request multiple times.

[0093] During the loading state, the client reads the pre-set naming-related table configuration information from the global configuration of the target table. The table configuration information is used to indicate whether the table name contains an export prefix and a time suffix.

[0094] For example, the client via The configuration option determines whether the generated table name includes the "export" prefix. If the configuration option is true, the "export" prefix is ​​retained; otherwise, the "export" prefix is ​​removed. The client accesses via... The configuration option determines whether the generated table name includes a time suffix. If the configuration option is true, the current time will be included as a time suffix when generating table names; otherwise, the time suffix will not be included when generating table names.

[0095] The client also obtains the base name of the target table. and custom code corresponding to the business type of the target table. According to the base name Custom code In the table configuration information Configuration items and Configuration item: Generate table name, enabling personalized naming of the target table to be exported in different business scenarios.

[0096] S402. Determine the header type and generate header parameters based on the header type. The header parameters include dynamic header parameters or static header parameters.

[0097] Optionally, the client determines the header type based on the header configuration information, where the header type includes dynamic headers and static headers.

[0098] The client generates the corresponding header parameters based on the header type, using the header parameter generation strategy appropriate to that type. Specifically, the client generates dynamic header parameters based on the type of dynamic header, or static header parameters based on the type of static header.

[0099] S403. Obtain user permission information, query conditions, extended parameters, and session storage parameters respectively, and integrate user permission information, query conditions, extended parameters, and session storage parameters into query parameters.

[0100] Optionally, the client can obtain user permission information from multiple sources, such as session storage and local storage. Query conditions Extended parameters and session storage parameters .

[0101] Client access to user permission information Query conditions Extended parameters and session storage parameters Perform multi-source merging and integrate into query parameters. This serves as supplementary configuration information to the target table to be exported.

[0102] In this embodiment, the client responds to the user's table export operation for the target table, starts the loading state, generates a table name based on pre-set table configuration information, determines the table header type, and generates table header parameters based on the table header type. The client obtains user permission information, query conditions, extended parameters, and session storage parameters respectively, and integrates these into query parameters. This enables personalized naming of the target table to be exported in the business scenario and determines the table header configuration and auxiliary configuration information of the target table to be exported.

[0103] Figure 6 Flowchart of the data processing method provided in the embodiments of this application Figure 5 ,like Figure 6 As shown, step S402 above, which determines the header type and generates header parameters based on the header type, includes: S501. If the dynamic header function is enabled and a dynamic header interface address exists, then the header type is determined to be dynamic header, the dynamic header interface address is encapsulated as a dynamic header parameter, and the dynamic header parameter is used as the header parameter.

[0104] Optionally, the client determines whether the dynamic header function is enabled and whether a dynamic header interface address exists based on the header configuration information, and determines the header type.

[0105] Specifically, if the client determines that the dynamic header function is enabled (e.g., in the header configuration information) (Configuration item is set to true), and a dynamic header interface address exists. Then, the header type is determined to be dynamic header, and the dynamic header interface address is set. Encapsulated as dynamic header parameters and dynamic header parameters As a header parameter.

[0106] S502. Otherwise, if the header type is determined to be static header, perform a deep copy operation on the column configuration data to obtain the copied column configuration data. Based on the copied column configuration data, dynamically bind and convert the column headers and encapsulate them as static header parameters, and use the static header parameters as header parameters.

[0107] Optionally, if the client determines that the dynamic header function is not enabled or the dynamic header interface address does not exist, If so, the header type is determined to be static header.

[0108] The client configures data for the preset table columns. Perform a deep copy to obtain the copied column configuration data, which includes the title, field name, style, and other configuration data for each column.

[0109] The client has configuration options. The column headers are dynamically bound and converted, then encapsulated into static header parameters. and static header parameters As a header parameter.

[0110] In this embodiment, if the dynamic header function is enabled and a dynamic header interface address exists, the client determines the header type to be dynamic, encapsulates the dynamic header interface address into a dynamic header parameter, and uses the dynamic header parameter as the header parameter. Otherwise, the client determines the header type to be static, performs a deep copy operation on the table column configuration data to obtain the copied column configuration data, and dynamically binds and converts the column headers according to the copied column configuration data, encapsulates them into static header parameters, and uses the static header parameters as the header parameter. This improves the flexibility of the header parameters to adapt to both dynamic and static headers.

[0111] Figure 7 Flowchart of the data processing method provided in the embodiments of this application Figure 6 ,like Figure 7 As shown, in step S107 above, the server generates table file data based on the parsing results, including: S601. Convert the format of the new variable value to obtain the converted new variable value, and verify and match the converted new variable value according to the header parameters.

[0112] Optionally, table variables in the parsing results The new values ​​of the variables are in the format of a two-dimensional array, and the server handles the table variables. The new value of the variable is formatted and converted into a List. <map>List data table in format The new value of the variable after transformation. Among them, List <map>The format is the standard format for Java to process tabular data.

[0113] Server-side data table for list After conversion, the new values ​​of the variables are validated. If the validation results are found in the list data table... If the new value of the variable after the conversion is empty, an error message is returned to the client to avoid invalid export.

[0114] After verifying the list data table After the transformation, the new value of the variable is not empty (i.e., the validation is compliant), and the server determines the value based on the header parameters (dynamic header parameters). Or static header parameters Retrieve the header configuration and match it with the list data table. After conversion, the fields in the new variable values ​​are used to ensure a one-to-one correspondence between the table data and the table header. Field matching ensures that the table header and data fields accurately match when generating table files, avoiding data misalignment.

[0115] S602. After the validation is compliant and the fields are successfully matched, create a streaming workbook, create a table header based on the table header parameters and query parameters, and determine the table header format.

[0116] Optionally, after verification and successful field matching, the server initiates the table file data generation process, creates a streaming workbook (SXSSFWorkbook), and sets up temporary file compression to reduce disk input / output operations. In other words, the streaming workbook (SXSSFWorkbook) only retains a preset number of data rows (e.g., 100 rows) in memory; any excess data rows are written to a temporary file and compressed, preventing memory overflow when exporting a large number of data rows and ensuring stable server operation.

[0117] The server uses the header parameters and query parameters. Create a header row in the SXSSFWorkbook and apply header formatting / styles, including color fill, font settings, font position settings, and header borders.

[0118] S603. Based on the new values ​​of the converted variables, create data rows one by one in the flow workbook, call the set cell value function to fill the cell values, and determine the data row format.

[0119] Optionally, the server uses the list data table. After the variable is transformed, the new value is used to create data rows one by one in the SXSSFWorkbook, and then the cell value setting function is called. The function fills in the cell values ​​of each cell in a data row.

[0120] After filling in the cell values ​​of the current data row, the server uses the query parameters... Apply the data row format of the current data row. After validation is successful and fields match, create a streaming workbook, and create table headers based on the header parameters and query parameters, and determine the header format.

[0121] S604. Normalize the format of each data row to obtain the processed streaming workbook, write the processed streaming workbook to the memory output stream, convert the memory output stream to the preset format, and generate table file data.

[0122] Optionally, the server performs normalization format processing on each data row to obtain a processed streaming workbook. This normalization format processing may include controlling the decimal places, thousands separators, date formatting, and converting zero values ​​to null characters in each cell value within each data row.

[0123] The server writes the processed streaming workbook to a memory output stream. and the memory output stream Convert to a preset format, which can be Base64 format, and generate table file data, that is, the table file data is a string in Base64 format.

[0124] In this embodiment, the server performs format conversion on the new variable values ​​to obtain the converted new variable values, and then validates and matches the converted new variable values ​​against the header parameters. Based on the converted new variable values, data rows are created row by row in the streaming workbook, and cell value setting functions are called to fill cell values ​​and determine the data row format. Normalization processing is performed on each data row to obtain a processed streaming workbook, which is then written to a memory output stream. The memory output stream is converted to a preset format to generate a table file. The server achieves large-scale data export of the target table through streaming processing, avoiding memory overflow, and performs format standardization processing on the header and each data row to improve the readability of the exported target file.

[0125] Figure 8 Flowchart of the data processing method provided in the embodiments of this application Figure 7 ,like Figure 8 As shown, in step S603 above, data rows are created row by row in the streaming workbook based on the new values ​​of the converted variables, and the cell value is filled by calling the set cell value function, including: S701. Based on the current field in the new value of the converted variable, determine the identifier of the cell to be filled in the current data row of the streaming workbook, where each field in the new value of the converted variable corresponds to a cell in the streaming workbook.

[0126] Optionally, list data table In the new values ​​of the transformed variables, each field corresponds to a cell in a data row of the SXSSFWorkbook.

[0127] Server-side traversal of list data tables The new value of the transformed variable, when traversing to the current field, determines the identifier of the cell to be filled in the current data row of the SXSSFWorkbook corresponding to the current field.

[0128] S702. Call the set cell value function to assign the value of the current field to the cell to be filled.

[0129] Optionally, the server calls the function to set the cell value. The function, based on the identifier of the cell to be filled, converts the list data table... The value of the current field in the new value of the transformed variable is assigned to the cell to be filled.

[0130] In this embodiment, the server determines the identifier of the cell to be filled in the current data row of the streaming workbook based on the current field in the new value of the converted variable, and calls the cell value setting function to assign the field value of the current field in the new value of the converted variable to the cell to be filled according to the identifier of the cell to be filled. This ensures the accuracy of the data in the cell to be filled in the current data row of the streaming workbook.

[0131] Based on the same inventive concept, this application also provides a data processing device corresponding to the data processing method executed by the client. Since the principle of the device in this application is similar to the data processing method executed by the client in the above-mentioned application, the implementation of the device can refer to the implementation of the method, and the repeated parts will not be described again.

[0132] Figure 9 A module structure diagram of a data processing device provided in an embodiment of this application is shown below. Figure 9 As shown, the device includes: The acquisition module 901 is used to respond to the user's table editing operation on the target table and acquire the new values ​​of each target cell that has changed; The update module 902 is used to update the variable values ​​of the table variables corresponding to the target table based on the identifier of each target cell and the new value of each target cell, so as to obtain the new variable values; The determination module 903 is used to respond to the user's table export operation for the target table, and to determine the table name, table header parameters, and query parameters; The generation module 904 is used to generate an export request based on the new variable values, table header parameters, and query parameters, and then send the export request to the server. The save module 905 is used to receive table file data generated by the server based on the export request, and respond to the user's table save operation for the target table, and save the target table according to the table file data and the table name.

[0133] As an optional implementation, the acquisition module 901 is specifically used for: Based on the editing type of each target cell, obtain the new cell value for each target cell.

[0134] As an optional implementation, the acquisition module 901 is specifically used for: If the editing type of the target cell is input type, then when the data input of the target cell is completed, the cell data entered by the user is trimmed and validated to obtain the new cell value of the target cell; If the target cell's edit type is formula calculation, then the pre-set formula function is called to perform the cell formula calculation, the calculation result is obtained, and the calculation result is formatted to obtain the new cell value of the target cell.

[0135] As an optional implementation, the update module 902 is specifically used for: Based on the identifier of the target cell, determine the target parameter item corresponding to the target cell in the table variable. The table variable is represented by a two-dimensional array, and each column of each row of the two-dimensional array is a parameter item, and each parameter item corresponds to a cell in the target table. Assign the new value of the target cell to the target parameter item; After all the variable values ​​in the table have been updated, the new values ​​of the variables are obtained.

[0136] As an optional implementation, the determining module 903 is specifically used for: In response to a user's table export operation for the target table, the loading state is started, and a table name is generated according to the pre-set table configuration information. The table configuration information is used to indicate whether the table name contains an export prefix and a time suffix. Determine the header type and generate header parameters based on the header type. Header parameters can be either dynamic or static. The system retrieves user permission information, query conditions, extended parameters, and session storage parameters separately, and then integrates these into a single query parameter.

[0137] As an optional implementation, the determining module 903 is specifically used for: If the dynamic header function is enabled and a dynamic header interface address exists, then the header type is determined to be dynamic header, the dynamic header interface address is encapsulated as a dynamic header parameter, and the dynamic header parameter is used as the header parameter. Otherwise, if the header type is determined to be static, a deep copy operation is performed on the column configuration data to obtain the copied column configuration data. Based on the copied column configuration data, the column headers are dynamically bound and converted and then encapsulated as static header parameters. These static header parameters are then used as the header parameters.

[0138] Based on the same inventive concept, this application also provides a data processing device corresponding to the data processing method executed by the server. Since the principle of the device in this application is similar to the data processing method executed by the server in the above-mentioned application, the implementation of the device can refer to the implementation of the method, and the repeated parts will not be described again.

[0139] Figure 10 A module structure diagram of another data processing device provided in the embodiments of this application is shown below. Figure 10 As shown, the device includes: The parsing module 1001 is used to receive the export request sent by the client, parse the export request, and obtain the parsing result, which includes the new values ​​of the table variables, the table header parameters, and the query parameters. The generation module 1002 is used to generate table file data based on the parsing results and send the table file data to the client.

[0140] As an optional implementation, the generation module 1002 is specifically used for: The new value of the variable is formatted to obtain the converted new value, and the converted new value is validated and matched according to the header parameters. After verification and successful field matching, create a streaming workbook, create table headers based on the header parameters and query parameters, and determine the header format; Based on the new values ​​of the transformed variables, create data rows one by one in the streaming workbook, call the set cell value function to fill the cell values, and determine the data row format; The data rows are normalized to obtain a processed streaming workbook, which is then written to a memory output stream. The memory output stream is then converted to a preset format to generate a table file.

[0141] As an optional implementation, the generation module 1002 is specifically used for: Based on the current field in the new value of the converted variable, determine the identifier of the cell to be filled in the current data row of the streaming workbook, where each field in the new value of the converted variable corresponds to a cell in the streaming workbook; Call the function to set the cell value, and assign the value of the current field to the cell to be filled.

[0142] This application also provides an electronic device, which can be the client or server described above. For example... Figure 11 The diagram shown is a structural schematic of an electronic device provided in an embodiment of this application, including a processor 111, a memory 112, and a bus 113. The memory 112 stores machine-readable instructions executable by the processor 111. When the electronic device is running, the processor 111 communicates with the memory 112 via the bus 113, and the processor 111 executes the machine-readable instructions to perform the method steps executed by the client or server described above.

[0143] This application also provides a data processing system, such as... Figure 1 As shown, the data processing system includes a client and a server.

[0144] The client and server are respectively used to execute the method steps described in the foregoing embodiments.

[0145] Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the specific working processes of the systems and devices described above can be referred to the corresponding processes in the method embodiments, and will not be repeated here. In the several embodiments provided in this application, it should be understood that the disclosed systems, devices, and methods can be implemented in other ways. The device embodiments described above are merely illustrative. For example, the division of modules is only a logical functional division, and in actual implementation, there may be other division methods. Furthermore, multiple modules or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the displayed or discussed mutual coupling or direct coupling or communication connection can be through some communication interfaces; the indirect coupling or communication connection of devices or modules can be electrical, mechanical, or other forms.

[0146] Furthermore, the functional units in the various embodiments of this application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. If the functions are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this application. The aforementioned storage medium includes: USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, optical disks, and other media capable of storing program code.

[0147] The above are merely specific embodiments of this application, but the scope of protection of this application is not limited thereto. Any changes or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this application should be included within the scope of protection of this application.< / map> < / map>

Claims

1. A data processing method, characterized in that, Applied to a client, the method includes: Responding to user table editing operations on the target table, retrieve the new values ​​of each target cell that has changed; Based on the identifier of each target cell and the new value of each target cell, the variable values ​​of the table variables corresponding to the target table are updated to obtain the new variable values; Respond to the user's table export operation for the target table, and determine the table name, header parameters, and query parameters; Based on the new value of the variable, the header parameters, and the query parameters, an export request is generated and sent to the server. Receive the table file data generated by the server based on the export request, and respond to the user's table save operation for the target table. Save the target table according to the table file data and the table name.

2. The method according to claim 1, characterized in that, The step of obtaining the new values ​​of each target cell that has changed includes: Based on the editing type of each target cell, obtain the new cell value for each target cell.

3. The method according to claim 2, characterized in that, The step of obtaining the new cell value for each target cell based on its edit type includes: If the editing type of the target cell is input type, then when the data input of the target cell is detected to be completed, the cell data input by the user is trimmed and validated to obtain the new cell value of the target cell; If the editing type of the target cell is formula calculation type, then the pre-set formula function is called to perform the cell formula calculation, the calculation result is obtained, and the calculation result is formatted to obtain the new cell value of the target cell.

4. The method according to claim 1, characterized in that, The step of updating the variable values ​​of the table variables corresponding to the target table based on the identifiers and new values ​​of each target cell to obtain new variable values ​​includes: Based on the identifier of the target cell, the target parameter item corresponding to the target cell in the table variable is determined, wherein the table variable is represented by a two-dimensional array, and each column parameter of each row of the two-dimensional array is a parameter item, and each parameter item corresponds to a cell in the target table; Assign the new value of the target cell to the target parameter item; After all the variable values ​​in the table have been updated, the new value of the variable is obtained.

5. The method according to claim 1, characterized in that, The response to the user's table export operation for the target table determines the table name, header parameters, and query parameters, including: In response to a user's table export operation for a target table, the loading state is initiated, and the table name is generated according to the pre-set table configuration information, wherein the table configuration information is used to indicate whether the table name contains an export prefix and a time suffix; Determine the header type and generate the header parameters based on the header type. The header parameters include dynamic header parameters or static header parameters. The user permission information, query conditions, extended parameters, and session storage parameters are obtained separately, and the user permission information, query conditions, extended parameters, and session storage parameters are integrated into the query parameters.

6. The method according to claim 5, characterized in that, The step of determining the header type and generating the header parameters based on the header type includes: If the dynamic header function is enabled and a dynamic header interface address exists, then the header type is determined to be a dynamic header, the dynamic header interface address is encapsulated as the dynamic header parameter, and the dynamic header parameter is used as the header parameter. Otherwise, if the header type is determined to be a static header, a deep copy operation is performed on the column configuration data to obtain the copied column configuration data. Based on the copied column configuration data, the column headers are dynamically bound and converted and then encapsulated as the static header parameters. The static header parameters are then used as the header parameters.

7. A data processing method, characterized in that, Applied to the server side, the method includes: Receive an export request sent by the client, parse the export request, and obtain the parsing result, which includes the new values ​​of the table variables, the table header parameters, and the query parameters; Based on the parsing results, a table file of data is generated and sent to the client.

8. The method according to claim 7, characterized in that, The step of generating the table file data based on the parsing result includes: The new value of the variable is formatted to obtain the converted new value of the variable, and the converted new value of the variable is validated and matched according to the header parameters. After verification and successful field matching, a streaming workbook is created, and a table header is created based on the table header parameters and the query parameters, and the table header format is determined. Based on the new values ​​of the transformed variables, data rows are created row by row in the streaming workbook, and the cell value is filled by calling the set cell value function, and the data row format is determined; Each data row is normalized to obtain a processed streaming workbook, which is then written to a memory output stream. The memory output stream is then converted to a preset format to generate the table file data.

9. The method according to claim 8, characterized in that, The step of creating data rows row by row in the streaming workbook based on the new values ​​of the transformed variables and filling the cell values ​​by calling the set cell value function includes: Based on the current field in the new value of the converted variable, determine the identifier of the cell to be filled in the current data row of the streaming workbook, wherein each field in the new value of the converted variable corresponds to a cell in the streaming workbook; The function to set cell value is invoked to assign the value of the current field to the cell to be filled.

10. A data processing system, characterized in that, The data processing system includes a client and a server; The client is used to execute the data processing method according to any one of claims 1-6; The server is used to execute the data processing method according to any one of claims 7-9.

Images