CN115935917A - Data processing method, device and equipment for visual chart and storage medium - Google Patents
Data processing method, device and equipment for visual chart and storage medium Download PDFInfo
- Publication number
- CN115935917A CN115935917A CN202211644709.6A CN202211644709A CN115935917A CN 115935917 A CN115935917 A CN 115935917A CN 202211644709 A CN202211644709 A CN 202211644709A CN 115935917 A CN115935917 A CN 115935917A
- Authority
- CN
- China
- Prior art keywords
- data
- attribute
- cell
- style
- row
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a data processing method, a device, equipment and a storage medium of a visual chart, wherein data description attributes, column attributes, row attributes and style attributes corresponding to each cell data in original table data are obtained by performing data extraction on the obtained original table data; rendering original table data into a visual on-line excel table according to the data description attribute, the column attribute, the row attribute and the style attribute; when a table modification instruction is received, acquiring a first column attribute and a first row attribute in the table modification instruction, positioning a first cell position to be modified, and acquiring a data modification value in the table modification instruction to modify data of the first cell so as to update and store an online excel table; compared with the prior art, the technical scheme of the invention directly modifies the excel table data on the line, thereby facilitating the modification of the data by a user and improving the working efficiency of the user.
Description
Technical Field
The invention relates to the technical field of big data, in particular to a data processing method, a data processing device, data processing equipment and a storage medium for a visual chart.
Background
With the development of the era, in the prior art, based on the actual needs of a user, data of an offline excel form is often mapped onto an online line for visual display, but when the online excel form needs to be modified, data in the offline data form often needs to be changed first, and the updated offline excel form data is mapped onto the online line again for display, and when the offline data is modified, the entire online excel form often needs to be updated due to difficulty in confirming specific modification contents, which is not beneficial to improving the efficiency of modifying and editing the form by the user, and thus the working efficiency of the user is low.
Disclosure of Invention
The technical problem to be solved by the invention is as follows: the method, the device, the equipment and the storage medium for processing the data of the visual chart are provided, the data can be modified conveniently by a user through directly modifying the data of the on-line excel table, and the working efficiency of the user is improved.
In order to solve the above technical problem, the present invention provides a data processing method, apparatus, device and storage medium for a visual chart, including:
acquiring original table data based on a designated back-end data API, and performing data extraction on the original table data to obtain data description attributes, column attributes, row attributes and style attributes corresponding to each cell data in the original table data;
rendering the original table data into a visualized on-line excel table according to the data description attribute, the column attribute, the row attribute and the style attribute;
when a table modification instruction is received, acquiring the table modification instruction, wherein the table modification instruction comprises a data modification value, a first column attribute and a first row attribute;
and positioning a first cell position required to be modified according to the first column attribute and the first row attribute, and modifying the data of the first cell according to the data modification value so as to update and store the on-line excel table.
In a possible implementation manner, modifying the data of the first cell according to the data modification value so as to update the online excel table specifically includes:
when the data modification value is a first data description attribute, judging whether the first data description attribute is the same as the data description attribute of the first cell position, if not, replacing the data description attribute with the first data description attribute, and if so, not modifying;
and when the data modification value is a first style attribute, judging whether the first style attribute is the same as the style attribute of the first cell position, if not, replacing the style attribute with the first style attribute, and if so, not modifying.
In a possible implementation manner, performing data extraction on the original table data to obtain a data description attribute, a column attribute, a row attribute, and a style attribute corresponding to each cell data in the original table data specifically includes:
acquiring all worksheets in the original form data, traversing each cell data in each worksheet, acquiring the row number and the column number of each cell data, taking the row number as the row attribute of the cell data, and taking the column number as the column attribute of the cell data;
simultaneously acquiring a style value of each cell datum, and taking the style value as a style attribute of the cell datum, wherein the style value comprises a background color, a frame, a character color, a character size and a character alignment mode;
and acquiring the content value of each cell data, and taking the content value as the data description attribute of the cell data.
In a possible implementation manner, after the online excel table is updated and saved, the method further includes:
acquiring an updated on-line ecxel table, and acquiring an on-line data description attribute, an on-line column attribute, an on-line row attribute and an on-line style attribute of cell data on each line in the on-line excel table;
and converting the online excel form into original form data according to the online data description attribute, the online column attribute, the online row attribute and the online style attribute, and storing the original form data.
The invention also provides a data processing device of the visual chart, which comprises the following components: the system comprises a data attribute extraction module, a data rendering module, a modification instruction receiving module and a data modification module;
the data attribute extraction module is used for acquiring original table data based on a designated back-end data API (application programming interface), and performing data extraction on the original table data to obtain data description attributes, column attributes, row attributes and style attributes corresponding to each cell data in the original table data;
the data rendering module is used for rendering the original table data into a visual on-line excel table according to the data description attribute, the column attribute, the row attribute and the style attribute;
the modification instruction receiving module is used for acquiring a table modification instruction when the table modification instruction is received, wherein the table modification instruction comprises a data modification value, a first column attribute and a first row attribute;
and the data modification module is used for positioning a first cell position to be modified according to the first column attribute and the first row attribute, and modifying the data of the first cell according to the data modification value so as to update and store the on-line excel table.
In a possible implementation manner, the modification instruction receiving module is configured to modify the data of the first cell according to the data modification value, so as to update the online excel table, and specifically includes:
when the data modification value is a first data description attribute, judging whether the first data description attribute is the same as the data description attribute of the first cell position, if not, replacing the data description attribute with the first data description attribute, and if so, not modifying;
and when the data modification value is a first style attribute, judging whether the first style attribute is the same as the style attribute of the first cell position, if not, replacing the style attribute with the first style attribute, and if so, not modifying.
In a possible implementation manner, the data attribute extraction module is configured to perform data extraction on the raw table data to obtain a data description attribute, a column attribute, a row attribute, and a style attribute corresponding to each cell data in the raw table data, and specifically includes:
acquiring all worksheets in the original form data, traversing each cell data in each worksheet, acquiring the row number and the column number of each cell data, taking the row number as the row attribute of the cell data, and taking the column number as the column attribute of the cell data;
simultaneously acquiring a style value of each cell datum, and taking the style value as a style attribute of the cell datum, wherein the style value comprises a background color, a frame, a character color, a character size and a character alignment mode;
and acquiring the content value of each cell data, and taking the content value as the data description attribute of the cell data.
The invention provides a data processing device of a visual chart, which further comprises: a data inverse conversion module;
the data inverse conversion module is used for acquiring the updated on-line ecxel table and acquiring an on-line data description attribute, an on-line column attribute, an on-line row attribute and an on-line style attribute of cell data on each line in the on-line excel table;
and the data inverse conversion module is used for converting the online excel table into original table data according to the online data description attribute, the online column attribute, the online row attribute and the online style attribute, and storing the original table data.
The invention also provides a terminal device, which comprises a processor, a memory and a computer program stored in the memory and configured to be executed by the processor, wherein the processor implements the data processing method of the visual chart according to any item when executing the computer program.
The invention also provides a computer-readable storage medium, which includes a stored computer program, wherein when the computer program runs, the apparatus where the computer-readable storage medium is located is controlled to execute the data processing method of the visual chart as described in any one of the above.
Compared with the prior art, the data processing method, the data processing device, the data processing equipment and the storage medium of the visual chart have the following beneficial effects that:
data description attributes, column attributes, row attributes and style attributes corresponding to each cell data in the original table data are obtained by performing data extraction on the obtained original table data; rendering original table data into a visual online excel table according to the data description attribute, the column attribute, the row attribute and the style attribute; when a table modification instruction is received, acquiring a first column attribute and a first row attribute in the table modification instruction, positioning a first cell position to be modified, and acquiring a data modification value in the table modification instruction to modify data of the first cell so as to update and store an online excel table; compared with the prior art, the technical scheme of the invention maps the original form data to the online excel form, and the user only needs to modify the data in the online excel form when modifying the data, thereby facilitating the modification of the data by the user, improving the processing efficiency of the user on the data and simultaneously improving the working efficiency of the user.
Drawings
FIG. 1 is a schematic flow chart diagram illustrating an embodiment of a data processing method for a visual chart according to the present invention;
fig. 2 is a schematic structural diagram of an embodiment of a data processing apparatus for visualizing charts provided in the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example 1
Referring to fig. 1, fig. 1 is a schematic flowchart of an embodiment of a data processing method for a visual chart according to the present invention, as shown in fig. 1, the method includes steps 101 to 104, which are specifically as follows:
step 101: based on a designated back-end data API, acquiring original table data, and performing data extraction on the original table data to obtain data description attributes, column attributes, row attributes and style attributes corresponding to each cell data in the original table data.
In an embodiment, the source of the original table data can be obtained through a designated backend data API, and similarly, the source of the original table data can also be obtained based on a file stream of an import offline excel table.
In one embodiment, the required table data is selected based on a user or a system, and a back-end data API is specified based on the table data binding for obtaining the original table data.
In an embodiment, all the worksheets in the original form data are acquired, each cell data in each worksheet is traversed, the row number and the column number of each cell data are acquired, the row number is used as the row attribute of the cell data, and the column number is used as the column attribute of the cell data.
Specifically, the sheet number in the original form data is acquired, the number of the worksheets in the original form data is acquired based on the sheet number, and the relevant parameters in each cell data are acquired by sequentially traversing each worksheet in the original form data and traversing each cell data in each worksheet according to a preset sequence. The preset sequence can be from top to bottom and then from left to right; the preset sequence may also be from left to right first and then from top to bottom.
Preferably, when two or more worksheets exist in the original form data, each worksheet is numbered, so that each worksheet is distinguished based on the worksheet number.
In an embodiment, a style value of each cell data is obtained at the same time, and the style value is used as a style attribute of the cell data, wherein the style value includes a background color, a frame, a text color, a text size, and a text alignment mode.
In one embodiment, a content value of each cell data is obtained, and the content value is used as a data description attribute of the cell data.
Specifically, when the data of each cell data is acquired, the data description attribute, the row attribute and the style attribute of the acquired cell data are sorted into an array form for storage based on the worksheet number corresponding to the worksheet.
Preferably, each cell data is arranged into the following array format: [ work sheet number; a data description attribute; a line attribute; a column attribute; style properties ]; and integrating the arrays corresponding to all the cell data in the single worksheet to obtain the array set.
Step 102: rendering the original table data into a visualized on-line excel table according to the data description attribute, the column attribute, the row attribute and the style attribute.
In an embodiment, based on each obtained array in the array set, based on an arrangement mode of the arrays, related data of cell data corresponding to the arrays are obtained, and the obtained data is rendered into a visual on-line excel table.
Specifically, each array in the array set is obtained, and is divided based on the semicolon symbol so as to divide a plurality of attribute data contained in the array, and the attribute data are distinguished based on the division sequence; if the first semicolon symbol in the array is traversed, acquiring attribute data before the first semicolon symbol, judging to acquire the attribute data before the first semicolon symbol as a worksheet number based on the array format, acquiring the attribute data before the second semicolon symbol when the second semicolon symbol in the array is traversed, and judging to acquire the attribute data before the second semicolon symbol as a data description attribute based on the array format; when traversing to a third mark symbol in the array, acquiring attribute data before the third mark symbol, and judging the attribute data before the third mark symbol as a row attribute based on the array format; when traversing to a fourth number mark in an array, acquiring attribute data before the fourth number mark, and judging that the attribute data before the fourth number mark is acquired as a column attribute based on an array format; and when traversing to the array without the semicolon symbol, acquiring the attribute data after the fourth semicolon symbol, and judging the attribute data after acquiring the fourth semicolon symbol to be the style attribute based on the array format.
In one embodiment, the data description attribute, the column attribute, the row attribute and the style attribute of each cell data in a worksheet are obtained based on extracting attribute data of each array in an array set, and the raw table data is rendered into a visualized on-line excel table based on the data description attribute, the column attribute, the row attribute and the style attribute.
Step 103: when a table modification instruction is received, the table modification instruction is obtained, wherein the table modification instruction comprises a data modification value, a first column attribute and a first row attribute.
In one embodiment, when an online excel table needs to be modified, a first row attribute and a first column attribute of cell data needing to be modified are obtained so as to enable the cell data needing to be modified to be positioned, and a table modification instruction is generated according to the first row attribute and the first column attribute and by combining a modified data value of single cell data needing to be modified.
Preferably, the online excel form can be modified online by triggering a modification key on the online excel form, and the modification process is recorded based on the modification of the user.
Step 104: and positioning a first cell position required to be modified according to the first column attribute and the first row attribute, and modifying the data of the first cell according to the data modification value so as to update and store the on-line excel table.
In an embodiment, when the data modification value is a first data description attribute, it is determined whether the first data description attribute is the same as the data description attribute of the first cell position, if not, the data description attribute is replaced with the first data description attribute, and if so, the data description attribute is not modified.
In an embodiment, when the data modification value is a first style attribute, it is determined whether the first style attribute is the same as the style attribute at the first cell position, if not, the style attribute is replaced with the first style attribute, and if so, the style attribute is not modified.
In one embodiment, when the online excel table is stored, the online excel table is stored to a preset position through a preset data storage API.
In one embodiment, after the on-line excel table is updated and saved, the updated on-line ecxel table is also obtained, and an on-line data description attribute, an on-line column attribute, an on-line row attribute and an on-line style attribute of cell data on each line in the on-line excel table are obtained; and converting the online data description attribute, the online column attribute, the online row attribute and the online style attribute into an array format, so that the online excel table is converted into original table data based on the online data description attribute, the online column attribute, the online row attribute and the online style attribute in the array format, and the original table data is stored.
Preferably, after the online excel table is modified and stored, whether a table modification instruction exists is judged, if yes, data extraction is performed on a modified part in the online excel table based on the table modification instruction to obtain online modified data, the original table data is updated based on the online modified data, so that data in the online excel table and data in the original table data are kept consistent, and if no table modification instruction exists, data extraction is performed on the modified part in the online excel table based on a recorded modification process to obtain online modified data, and the original table data is updated based on the online modified data, so that data in the online excel table and data in the original table data are kept consistent.
Preferably, when the user reenters the online excel form, the system can retrieve the data saved last time and visually display the data.
Example 2
Referring to fig. 2, fig. 2 is a schematic structural diagram of an embodiment of a data processing apparatus for visualizing a chart according to the present invention, as shown in fig. 2, the apparatus includes a data attribute extraction module 201, a data rendering module 202, a modification instruction receiving module 203, and a data modification module 204, which are as follows:
the data attribute extraction module 201 is configured to obtain original table data based on a specified backend data API, perform data extraction on the original table data, and obtain a data description attribute, a column attribute, a row attribute, and a style attribute corresponding to each cell data in the original table data.
The data rendering module 202 is configured to render the original table data into a visualized on-line excel table according to the data description attribute, the column attribute, the row attribute, and the style attribute.
The modification instruction receiving module 203 is configured to, when a table modification instruction is received, obtain the table modification instruction, where the table modification instruction includes a data modification value, a first column attribute, and a first row attribute.
The data modification module 204 is configured to locate a first cell position to be modified according to the first column attribute and the first row attribute, and modify the data of the first cell according to the data modification value, so as to update and store the online excel table.
In an embodiment, the modification instruction receiving module 203 is configured to modify the data of the first cell according to the data modification value, so as to update the online excel table, and specifically includes: when the data modification value is a first data description attribute, judging whether the first data description attribute is the same as the data description attribute of the first cell position, if not, replacing the data description attribute with the first data description attribute, and if so, not modifying; and when the data modification value is a first style attribute, judging whether the first style attribute is the same as the style attribute of the first cell position, if not, replacing the style attribute with the first style attribute, and if so, not modifying.
In an embodiment, the data attribute extraction module 201 is configured to perform data extraction on the raw table data to obtain a data description attribute, a column attribute, a row attribute, and a style attribute corresponding to each cell data in the raw table data, and specifically includes: acquiring all worksheets in the original form data, traversing each cell data in each worksheet, acquiring the row number and the column number of each cell data, taking the row number as the row attribute of the cell data, and taking the column number as the column attribute of the cell data; simultaneously acquiring a style value of each cell datum, and taking the style value as a style attribute of the cell datum, wherein the style value comprises a background color, a frame, a character color, a character size and a character alignment mode; and acquiring the content value of each cell data, and taking the content value as the data description attribute of the cell data.
The data processing device for a visual chart provided by the embodiment further comprises: and a data inverse conversion module.
In one embodiment, the data inverse transformation module is configured to obtain an updated on-line ecxel table, and obtain an on-line data description attribute, an on-line column attribute, an on-line row attribute, and an on-line style attribute of cell data on each line in the on-line excel table; and converting the online excel form into original form data according to the online data description attribute, the online column attribute, the online row attribute and the online style attribute, and storing the original form data.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working process of the apparatus described above may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.
It should be noted that the above embodiments of the data processing apparatus for visualizing charts are merely illustrative, wherein the modules described as separate components may or may not be physically separate, and the components displayed as modules may or may not be physical units, may be located in one place, or may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
On the basis of the above embodiment of the data processing method for a visual chart, another embodiment of the present invention provides a data processing terminal device for a visual chart, which includes a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, and when the processor executes the computer program, the data processing method for a visual chart according to any one of the embodiments of the present invention is implemented.
Illustratively, the computer program in this embodiment may be partitioned into one or more modules that are stored in the memory and executed by the processor to implement the invention. The one or more modules may be a series of computer program instruction segments capable of performing specific functions, which are used for describing the execution process of the computer program in the data processing terminal device of the visual chart.
The data processing terminal device of the visual chart can be a desktop computer, a notebook computer, a palm computer, a cloud server and other computing devices. The data processing terminal device of the visual chart can comprise, but is not limited to, a processor and a memory.
The processor may be a Central Processing Unit (CPU), other general purpose processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. The general processor may be a microprocessor or the processor may be any conventional processor, etc., and the processor is a control center of the data processing terminal device of the visual chart, and various interfaces and lines are used to connect various parts of the data processing terminal device of the whole visual chart.
The memory can be used for storing the computer program and/or the module, and the processor can realize various functions of the data processing terminal equipment of the visual chart by operating or executing the computer program and/or the module stored in the memory and calling the data stored in the memory. The memory may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function, and the like; the storage data area may store data created according to the use of the mobile phone, and the like. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
On the basis of the above embodiment of the data processing method for the visual chart, another embodiment of the present invention provides a storage medium, where the storage medium includes a stored computer program, and when the computer program runs, the apparatus on which the storage medium is located is controlled to execute the data processing method for the visual chart according to any embodiment of the present invention.
In this embodiment, the storage medium is a computer-readable storage medium, and the computer program includes computer program code, which may be in source code form, object code form, executable file or some intermediate form, and so on. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, read-Only Memory (ROM), random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution medium, etc. It should be noted that the computer readable medium may contain content that is subject to appropriate increase or decrease as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, computer readable media does not include electrical carrier signals and telecommunications signals as is required by legislation and patent practice.
In summary, according to the data processing method, the data processing apparatus, the data processing device, the data processing apparatus, and the storage medium for a visual chart provided by the present invention, data description attributes, column attributes, row attributes, and style attributes corresponding to each cell data in the original table data are obtained by performing data extraction on the acquired original table data; rendering original table data into a visual on-line excel table according to the data description attribute, the column attribute, the row attribute and the style attribute; when a table modification instruction is received, acquiring a first column attribute and a first row attribute in the table modification instruction, positioning a first cell position to be modified, and acquiring a data modification value in the table modification instruction to modify data of the first cell so as to update and store an online excel table; compared with the prior art, the technical scheme of the invention has the advantages that the excel form data on the line is directly modified, the data modification of a user is facilitated, and the working efficiency of the user is improved.
The above description is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, many modifications and substitutions can be made without departing from the technical principle of the present invention, and these modifications and substitutions should also be regarded as the protection scope of the present invention.
Claims (10)
1. A method of data processing for visualizing a chart, comprising:
acquiring original table data based on a designated back-end data API, and performing data extraction on the original table data to obtain data description attributes, column attributes, row attributes and style attributes corresponding to each cell data in the original table data;
rendering the original table data into a visualized on-line excel table according to the data description attribute, the column attribute, the row attribute and the style attribute;
when a table modification instruction is received, acquiring the table modification instruction, wherein the table modification instruction comprises a data modification value, a first column attribute and a first row attribute;
and positioning a first cell position required to be modified according to the first column attribute and the first row attribute, and modifying the data of the first cell according to the data modification value so as to update and store the on-line excel table.
2. The data processing method of a visualization chart according to claim 1, wherein modifying the data of the first cell according to the data modification value so as to update the online excel table specifically comprises:
when the data modification value is a first data description attribute, judging whether the first data description attribute is the same as the data description attribute of the first cell position, if not, replacing the data description attribute with the first data description attribute, and if so, not modifying;
and when the data modification value is a first style attribute, judging whether the first style attribute is the same as the style attribute of the first cell position, if not, replacing the style attribute with the first style attribute, and if so, not modifying.
3. The data processing method of a visual chart according to claim 1, wherein performing data extraction on the original table data to obtain a data description attribute, a column attribute, a row attribute and a style attribute corresponding to each cell data in the original table data specifically comprises:
acquiring all worksheets in the original table data, traversing each cell data in each worksheet, acquiring the row number and column number of each cell data, taking the row number as the row attribute of the cell data, and taking the column number as the column attribute of the cell data;
simultaneously acquiring a style value of each cell datum, and taking the style value as a style attribute of the cell datum, wherein the style value comprises a background color, a frame, a character color, a character size and a character alignment mode;
and acquiring the content value of each cell data, and taking the content value as the data description attribute of the cell data.
4. A data processing method for a visualization chart as claimed in claim 1, further comprising, after updating and saving said online excel table:
acquiring an updated on-line ecxel table, and acquiring an on-line data description attribute, an on-line column attribute, an on-line row attribute and an on-line style attribute of cell data on each line in the on-line excel table;
and converting the online excel form into original form data according to the online data description attribute, the online column attribute, the online row attribute and the online style attribute, and storing the original form data.
5. A data processing apparatus for visualizing a chart, comprising: the system comprises a data attribute extraction module, a data rendering module, a modification instruction receiving module and a modification instruction receiving module;
the data attribute extraction module is used for acquiring original table data based on a designated back-end data API (application program interface), and performing data extraction on the original table data to obtain data description attributes, column attributes, row attributes and style attributes corresponding to each cell data in the original table data;
the data rendering module is used for rendering the original table data into a visual on-line excel table according to the data description attribute, the column attribute, the row attribute and the style attribute;
the modification instruction receiving module is used for acquiring a table modification instruction when the table modification instruction is received, wherein the table modification instruction comprises a data modification value, a first column attribute and a first row attribute;
and the data change module is used for positioning a first cell position to be modified according to the first column attribute and the first row attribute, and modifying the data of the first cell according to the data modification value so as to update and store the online excel table.
6. The data processing apparatus for visualizing a chart according to claim 5, wherein the modification instruction receiving module is configured to modify the data of the first cell according to the data modification value, so as to update the online excel table, and specifically comprises:
when the data modification value is a first data description attribute, judging whether the first data description attribute is the same as the data description attribute of the first cell position, if not, replacing the data description attribute with the first data description attribute, and if so, not modifying;
and when the data modification value is a first style attribute, judging whether the first style attribute is the same as the style attribute of the first cell position, if not, replacing the style attribute with the first style attribute, and if so, not modifying.
7. The data processing apparatus for a visual chart according to claim 5, wherein the data attribute extraction module is configured to perform data extraction on the original table data to obtain a data description attribute, a column attribute, a row attribute, and a style attribute corresponding to each cell data in the original table data, and specifically includes:
acquiring all worksheets in the original table data, traversing each cell data in each worksheet, acquiring the row number and column number of each cell data, taking the row number as the row attribute of the cell data, and taking the column number as the column attribute of the cell data;
simultaneously acquiring a style value of each cell datum, and taking the style value as a style attribute of the cell datum, wherein the style value comprises a background color, a frame, a character color, a character size and a character alignment mode;
and acquiring a content value of each cell data, and taking the content value as a data description attribute of the cell data.
8. A data processing apparatus for visualizing a chart as in claim 5, further comprising: a data inverse conversion module;
the data inverse conversion module is used for acquiring the updated on-line ecxel table and acquiring an on-line data description attribute, an on-line column attribute, an on-line row attribute and an on-line style attribute of cell data on each line in the on-line excel table;
and the data inverse conversion module is used for converting the online excel form into original form data according to the online data description attribute, the online column attribute, the online row attribute and the online style attribute, and storing the original form data.
9. A terminal device comprising a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, the processor implementing the data processing method of a visual chart according to any one of claims 1 to 4 when executing the computer program.
10. A computer-readable storage medium, comprising a stored computer program, wherein the computer program, when executed, controls an apparatus in which the computer-readable storage medium is located to perform a data processing method for visualizing a chart as in any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211644709.6A CN115935917A (en) | 2022-12-16 | 2022-12-16 | Data processing method, device and equipment for visual chart and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211644709.6A CN115935917A (en) | 2022-12-16 | 2022-12-16 | Data processing method, device and equipment for visual chart and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115935917A true CN115935917A (en) | 2023-04-07 |
Family
ID=86700658
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211644709.6A Pending CN115935917A (en) | 2022-12-16 | 2022-12-16 | Data processing method, device and equipment for visual chart and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115935917A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116127936A (en) * | 2023-04-04 | 2023-05-16 | 深圳市城市交通规划设计研究中心股份有限公司 | Method for compiling engineering unit matrix diagram, electronic equipment and storage medium |
-
2022
- 2022-12-16 CN CN202211644709.6A patent/CN115935917A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116127936A (en) * | 2023-04-04 | 2023-05-16 | 深圳市城市交通规划设计研究中心股份有限公司 | Method for compiling engineering unit matrix diagram, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110399420B (en) | Export method, electronic equipment and medium of configurable Excel format | |
| CN107977346B (en) | PDF document editing method and terminal equipment | |
| CN105549936B (en) | Data table display method and device | |
| CN107451112B (en) | Form tool data checking method, device, terminal equipment and storage medium | |
| CN111400387A (en) | Conversion method and device for import and export data, terminal equipment and storage medium | |
| CN109471893B (en) | Network data query method, equipment and computer readable storage medium | |
| CN117238433B (en) | Method for automatically isolating document data based on Libreoffice | |
| CN111611813A (en) | Document translation method and device, electronic equipment and storage medium | |
| CN115935917A (en) | Data processing method, device and equipment for visual chart and storage medium | |
| CN110413721B (en) | Vector map generation method and device | |
| US20200026749A1 (en) | Pdf extraction with text-based key | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN110647573B (en) | Chart visualization editing method and system based on database technology | |
| CN115167728A (en) | Menu bar merging and displaying method, device and computer readable storage medium | |
| CN115757174A (en) | Database difference detection method and device | |
| CN115202535A (en) | Icon editing method and device, electronic equipment and storage medium | |
| WO2021072776A1 (en) | Data merging method and apparatus, electronic device, and storage medium | |
| CN111444452A (en) | Conversion method, device and storage medium of webpage | |
| CN111949142A (en) | Time input method, terminal equipment and storage medium | |
| CN113127408A (en) | Data conversion method and device | |
| CN111881234A (en) | Land planning method and device, terminal equipment and storage medium | |
| CN111651531A (en) | Data import method, device, equipment and computer storage medium | |
| CN114004212B (en) | Data processing method, device and storage medium | |
| CN116384356B (en) | Method, device, equipment and medium for creating form row of OFD file | |
| CN107977455A (en) | Ceb files full-text search method, device and computer-readable recording medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |