CN116880733B - Table data processing method, apparatus, device and storage medium - Google Patents
Table data processing method, apparatus, device and storage medium Download PDFInfo
- Publication number
- CN116880733B CN116880733B CN202310653837.5A CN202310653837A CN116880733B CN 116880733 B CN116880733 B CN 116880733B CN 202310653837 A CN202310653837 A CN 202310653837A CN 116880733 B CN116880733 B CN 116880733B
- Authority
- CN
- China
- Prior art keywords
- tool
- target
- operation control
- importing
- control
- 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.)
- Active
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 16
- 238000012545 processing Methods 0.000 claims abstract description 63
- 230000008676 import Effects 0.000 claims abstract description 51
- 230000004044 response Effects 0.000 claims abstract description 26
- 238000000034 method Methods 0.000 claims abstract description 23
- 238000004891 communication Methods 0.000 claims description 11
- 238000012217 deletion Methods 0.000 claims description 6
- 230000037430 deletion Effects 0.000 claims description 6
- 230000001960 triggered effect Effects 0.000 claims description 4
- 238000010586 diagram Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000007723 transport mechanism Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/04842—Selection of displayed objects or displayed text elements
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/04817—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance using icons
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0486—Drag-and-drop
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides a table data processing method, a device, equipment and a storage medium, wherein the method comprises the steps of displaying an editing interface and a canvas interface, wherein the editing interface comprises an import tool, an export tool and a plurality of selectable operation controls, and the selectable operation controls are used for carrying out data processing on an input table according to preset data processing rules; dragging an import tool to a canvas interface, and importing a target source form from the import tool; dragging the target operation control to a canvas interface, and generating and displaying an associated connecting line in response to clicking operation on the importing tool and releasing operation on the target operation control, wherein the associated connecting line is used for indicating the flow direction of data; dragging the export tool to a canvas interface, and generating and displaying an associated connecting line in response to clicking operation on a target operation control and releasing operation on the export tool; in response to the configuration completion operation, a form processing tool is generated from the import tool, the target operation control, and the export tool. Thereby improving the efficiency of table data processing.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, and a storage medium for processing table data.
Background
The application range of the current table is wider and wider, and people pay more attention to the processing of table data. Processing of table data by means of Excel et al software is currently still in existence, but requires a skilled person to grasp the associated skills, keeping in mind the calculation formulas therein, which is very difficult for novice. This also results in a user consuming more time and effort and being less efficient when dealing with form data processing.
Disclosure of Invention
The present invention aims to solve at least one of the technical problems existing in the prior art. Therefore, the invention provides a method, a device, equipment and a storage medium for processing table data, which can improve the efficiency of table data processing.
In a first aspect, an embodiment of the present invention provides a table data processing method, including:
displaying an editing interface and a canvas interface, wherein the editing interface comprises an import tool, an export tool and a plurality of selectable operation controls, the selectable operation controls are used for carrying out data processing on an input form according to a preset data processing rule, the import tool is used for importing the form, and the export tool is used for exporting the form;
dragging the importing tool to the canvas interface, and importing a target source form from the importing tool;
dragging a target operation control to the canvas interface, responding to clicking operation of the importing tool and releasing operation of the target operation control, and generating and displaying an associated connecting line, wherein the associated connecting line is used for indicating the flow direction of data, and the target operation control is the selected selectable operation control;
dragging the export tool to the canvas interface, and generating and displaying the associated connection line in response to clicking operation on the target operation control and releasing operation on the export tool;
in response to a configuration completion operation, a form processing tool is generated from the import tool, the target operational control, and the export tool.
According to some embodiments of the invention, dragging the import tool to the canvas interface imports a target source form from the import tool, comprising:
dragging the import tool at least twice, and generating and displaying at least two import tools on the canvas interface;
and respectively importing the corresponding target source tables into each importing tool.
According to some embodiments of the invention, the dragging the target operation control to the canvas interface, generating and displaying an associated join line in response to a click operation on the import tool and a release operation on the target operation control, includes:
dragging the selectable operation control at least twice to generate at least two target operation controls;
and generating and displaying the associated connecting lines based on clicking operation of the importing tool and releasing operation of the target operation control each time, wherein the number of the associated connecting lines is at least 2, and each importing tool is connected with at least one target operation control through the associated connecting lines.
According to some embodiments of the invention, the dragging the export tool to the canvas interface, generating and displaying the associated join line in response to a click operation on the target operation control and a release operation on the export tool, comprises:
dragging the selectable operation control at least twice to generate at least two target operation controls;
and generating and displaying the associated connecting lines based on clicking operation of the target operation control and releasing operation of the export tool each time, wherein the number of the associated connecting lines is at least 2, and each export tool is at least connected with one target operation control through the associated connecting lines.
According to some embodiments of the invention, the method for generating the target source table includes:
constructing a data source according to the API address;
and acquiring the data source through a direct connection mode, and determining the data source as the target source table.
According to some embodiments of the invention, after the generating a form processing tool from the import tool, the target operation control, and the export tool in response to the configuration completion operation, the method comprises:
when the table processing tool is triggered to run, the importing tool acquires the target source table, and sends the target source table to the target operation control for processing to obtain a target table;
when a table acquisition operation is detected, the target table is exported by the export tool.
According to some embodiments of the invention, a deletion control is disposed on the association link, and the table data processing method further includes:
acquiring an association record of the association connection line, wherein the association record comprises an access object and an access object of the association connection line;
deleting the associated connection line in response to clicking operation of the deletion control;
and when the association connection line is detected to be deleted, acquiring a connected-out object of the association connection line in the association record, and deleting the data in the connected-out object.
In a second aspect, an embodiment of the present invention provides a tabular data processing apparatus, including at least one control processor and a memory for communication connection with the at least one control processor; the memory stores instructions executable by the at least one control processor to enable the at least one control processor to perform the tabular data processing method as described in the first aspect above.
In a third aspect, an embodiment of the present invention provides an electronic device, which includes a table data processing apparatus as described in the second aspect.
In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, where the computer-readable storage medium stores computer-executable instructions for causing a computer to perform the table data processing method according to the first aspect.
The method, the device, the equipment and the storage medium for processing the table data have at least the following beneficial effects: displaying an editing interface and a canvas interface, wherein the editing interface comprises an import tool, an export tool and a plurality of selectable operation controls, the selectable operation controls are used for carrying out data processing on an input form according to a preset data processing rule, the import tool is used for importing the form, and the export tool is used for exporting the form; dragging the importing tool to the canvas interface, and importing a target source form from the importing tool; dragging a target operation control to the canvas interface, responding to clicking operation of the importing tool and releasing operation of the target operation control, and generating and displaying an associated connecting line, wherein the associated connecting line is used for indicating the flow direction of data, and the target operation control is the selected selectable operation control; dragging the export tool to the canvas interface, and generating and displaying the associated connection line in response to clicking operation on the target operation control and releasing operation on the export tool; in response to a configuration completion operation, a form processing tool is generated from the import tool, the target operational control, and the export tool. The method comprises the steps of importing a target source form through an importing tool, and carrying out data processing on the target form through a preset data processing rule in a target operation control, wherein a mapping connecting line exists between the importing tool and the target operation control to transmit data, and a mapping connecting line also exists between the target operation control and an exporting tool to transmit data.
Drawings
FIG. 1 is a flow chart of a tabular data processing method provided by an embodiment of the present invention;
FIG. 2 is a flow chart of a method for dragging an importation tool to a canvas interface provided in accordance with another embodiment of the present invention;
FIG. 3 is a flow chart of a method for associating an import tool with a target operational control provided in another embodiment of the present invention;
FIG. 4 is a flow chart of a method for associating a target operational control with a export tool provided by another embodiment of the present invention;
FIG. 5 is a flowchart of a method for obtaining a target source table according to another embodiment of the present invention;
FIG. 6 is a flow chart of a method of operating a form processing tool provided in accordance with another embodiment of the present invention;
FIG. 7 is a flow chart of a method for deleting an associated link according to another embodiment of the present invention;
FIG. 8 is a schematic diagram of an import tool configuration interface provided in another embodiment of the present invention;
FIG. 9 is a schematic diagram of an import tool, a target operational control, and an export tool provided by another embodiment of the present invention;
FIG. 10 is a schematic diagram of a destination table provided by another embodiment of the present invention;
fig. 11 is a block diagram of a tabular data processing apparatus according to another embodiment of the present invention.
Detailed Description
Embodiments of the present invention are described in detail below, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to like or similar elements or elements having like or similar functions throughout. The embodiments described below by referring to the drawings are illustrative only and are not to be construed as limiting the invention.
In the description of the present invention, it should be understood that references to orientation descriptions such as upper, lower, front, rear, left, right, etc. are based on the orientation or positional relationship shown in the drawings, are merely for convenience of description of the present invention and to simplify the description, and do not indicate or imply that the apparatus or elements referred to must have a particular orientation, be constructed and operated in a particular orientation, and thus should not be construed as limiting the present invention.
In the description of the present invention, a number means one or more, a number means two or more, and greater than, less than, exceeding, etc. are understood to not include the present number, and above, below, within, etc. are understood to include the present number. The description of the first and second is for the purpose of distinguishing between technical features only and should not be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated or implicitly indicating the precedence of the technical features indicated.
In the description of the present invention, unless explicitly defined otherwise, terms such as arrangement, installation, connection, etc. should be construed broadly and the specific meaning of the terms in the present invention can be reasonably determined by a person skilled in the art in combination with the specific contents of the technical scheme.
Referring to fig. 1 and 8, fig. 1 is a flowchart of a table data processing method according to an embodiment of the present invention, including steps S110 to S150:
step S110, displaying an editing interface 1 and a canvas interface 2, wherein the editing interface 1 comprises an importing tool, an exporting tool and a plurality of selectable operation controls, the selectable operation controls are used for carrying out data processing on an input form according to a preset data processing rule, the importing tool is used for importing the form, and the exporting tool is used for exporting the form;
step S120, dragging an import tool to the canvas interface 2, and importing a target source form from the import tool;
step S130, dragging a target operation control to the canvas interface 2, generating and displaying an associated connection line in response to clicking operation of an importing tool and releasing operation of the target operation control, wherein the associated connection line is used for indicating the flow direction of data, and the target operation control is a selected selectable operation control;
step S140, dragging the export tool to the canvas interface 2, and generating and displaying an associated connecting line in response to clicking operation on a target operation control and releasing operation on the export tool;
in response to the configuration completion operation, a table processing tool is generated from the import tool, the target operation control, and the export tool, step S150.
It should be noted that, the editing interface 1 and the canvas interface 2 are arranged in parallel, so that the proportion of the canvas interface 2 can be increased for the convenience of user operation. Referring to fig. 8, the left side is an editing interface 1, the input data set is an import tool, the output data set is an export tool, gray squares below are used for indicating different selectable operation controls, in practical application, icons of the import tool, the export tool and the different selectable operation controls can be set to be different texts for distinguishing, and corresponding names are marked below according to functions, so that the user can conveniently distinguish and use, and the selectable operations include selection of checking weight, adding calculation columns and the like, and the position arrangement of the import tool, the export tool and the selectable operation controls is not limited herein; on the right is canvas interface 2, tools and controls may be dragged onto canvas interface 2 for layout.
It should be noted that, after dragging the import tool to the canvas interface 2, clicking the import tool on the canvas interface 2, referring to fig. 8, it can be seen that one import tool is already displayed by dragging, that is, the input dataset tool is on the canvas interface, clicking the dataset tool pops up a setting panel, different source table files and corresponding table data are displayed on the setting panel, and illustratively, source table files including project information, project month progress, project investment and the like are displayed on the setting panel, and selection is performed in the source table files as a target source table for import. Further, when a certain source table file is selected, the corresponding text content is displayed on the right side of the setting panel, so that the user can conveniently select the text content.
It should be noted that, an association connection is constructed between the import tool and the target operation control, the target source table data in the import tool is transmitted to the target operation control through the association connection, the target operation control is clicked to generate a configuration interface, and if the target operation control is an deduplication control, a configuration panel is generated after the deduplication control is clicked, and a column to be deduplicated in the target source table is selected on the configuration panel.
It should be noted that, the number of the target operation controls is not limited, and an association connection line can be constructed between the target operation controls.
It should be noted that, in response to a click operation on the target operation control and a release operation on the export tool, an association link is generated for transmitting data passing through the target operation control to the export tool. After the configuration is completed, a form processing tool is generated, and the target source form can automatically run among the import tool, the target operation control and the export tool only by executing the form processing control, so that a final target form is obtained. The user only needs to configure the tools and the controls according to the requirements, and the target source form can be processed to obtain a final target form. The data processing of the target source form is realized through dragging the tool and the control, meanwhile, the functions of the tool and the control are clear at a glance, the tool and the control are very easy to get up, a related form data processing formula is not needed, and the form data processing efficiency is improved.
In another embodiment, referring to FIG. 2, step S120 drags the import tool to the canvas interface, imports the target source form from the import tool, further comprising:
step S121, dragging the import tool at least twice, and generating and displaying at least two import tools on the canvas interface;
step S122, importing a corresponding target source table into each importing tool.
It should be noted that, the number of the importing tools is at least two, and the target source tables imported in each importing tool may be the same or different, and are adjusted according to the requirements of the users.
In another embodiment, referring to fig. 3 and 9, step S130, dragging the target operation control to the canvas interface, generating and displaying the associated link in response to the click operation on the import tool and the release operation on the target operation control, further includes:
s131, dragging the selectable operation controls at least twice to generate at least two target operation controls;
and S132, generating and displaying associated connecting lines based on clicking operation of the importing tools and releasing operation of the target operation controls each time, wherein the number of the associated connecting lines is at least 2, and each importing tool is connected with at least one target operation control through the associated connecting lines.
It should be noted that at least two target operation controls are provided on the canvas interface, and the types of the target operation controls may be the same or different. Based on clicking operation of the importing tool and releasing operation of the target operation control each time, an association connection line is generated between the importing tool and the target operation control, namely, the number of the association connection lines between the importing tool and the target operation control is at least 2, namely, the association connection line between the importing tool and the target operation control can be one-to-many, or many-to-many, namely, a plurality of importing tools exist, the plurality of importing tools are connected with the same target operation control through the association connection line, so that data processing is carried out on target source forms corresponding to different importing tools by the same target operation control, and further, data output by the importing tools after the target source forms are processed by the target operation control can be intersected with data of the target source forms imported by other importing tools in the same target operation control. In this way, the merging process of the plurality of source table data is realized. Illustratively, referring to fig. 9, 3 importing tools are dragged in the canvas interface, and the respectively imported target source forms include project information, project month progress and project month investment, and after the project information is processed by the heavy-duty control, the project information and the project month progress are intersected in the associated data control through the associated connecting line, i.e. a plurality of importing tools can be connected with the same target operation control through the associated connecting line.
In another embodiment, referring to FIG. 4, step S140, dragging the export tool to the canvas interface, generating and displaying an associated join line in response to a click operation on the target operational control and a release operation on the export tool, further comprises:
step S141, dragging the selectable operation control at least twice to generate at least two target operation controls;
in step S142, based on each click operation on the target operation control and release operation on the export tool, an associated connection line is generated and displayed, where the number of associated connection lines is at least 2, and each export tool is connected to at least one target operation control through the associated connection line.
It should be noted that, at least two target operation controls are generated on the canvas interface, there are associated lines between the target operation controls and the export tool, at least 2 associated lines are connected with at least one target operation control by the export tool through the associated lines, that is, the associated lines between the target operation controls and the export tool may be one-to-one or many-to-one, and the plurality of associated lines are connected with one export tool, that is, data in different target operation controls are transmitted to the same export tool for output. In this way, a common output of a plurality of table data is achieved.
In another embodiment, referring to fig. 5, the method for generating the target source table includes:
step S1201, constructing a data source according to the API address;
in step S1202, the data source is acquired through the direct connection mode, and the data source is determined as the target source table.
It should be noted that, the data source is constructed according to the data obtained from the API address, it can be understood that the data source can be modified by modifying the data in the API address or modifying the API address, and the data source is obtained as the target source table through the direct connection mode, that is, the data in the target source table is not fixed, and can be modified according to the actual requirement. Various form data can be flexibly processed.
In another embodiment, referring to fig. 6 and 10, after generating the form processing tool according to the import tool, the target operation control, and the export tool in response to the configuration completion operation, in step S150, it further includes:
step S151, when the form processing tool is triggered to run, the importing tool acquires a target source form, and sends the target source form to a target operation control for processing to obtain the target form;
in step S152, when the table obtaining operation is detected, the target table is exported by the export tool.
It should be noted that, the form processing tool only configures various tools and controls to obtain a control, after the form processing tool is triggered to run, the import tool or obtains the original imported target source form, and sends the target source form to the target operation control through the association line, the target operation control is pre-configured with a data processing rule, the target source form is processed based on the data processing rule, it can be understood that multiple target operation controls can be connected through the association line, the target source form sequentially passes through the processing of multiple target operation controls to obtain the target form, and sends the target form to the export tool, the export tool exports the target form, exemplarily, three import tools are dragged to a canvas interface, the import tool is configured, three source form files of project information, project month progress and project investment are imported to the import tool, then, for example, a duplicate control is selected, a list control, a parallel control and an associated data control are processed to the interface, finally, the export tool is dragged to the interface, the import tool, the target operation control is connected with the canvas through the association line, the export tool is processed, the target operation control is processed, the export tool is completed, the target form is configured through the association line, the input tool is completed, and finally, the target form is processed, and the target form is processed, if the target form is not processed, and the target form is processed, and finally, the target form is processed, and the input through the input tool is completed, and the input through the association tool. The target source form is imported and dragged to the canvas interface, and the target source form is processed by utilizing the preset data processing rule, so that the processing of the form data is realized, the whole process is very easy to understand and operate, and the processing efficiency of the form data is improved.
It should be noted that, after the target table is exported, the target table is displayed on a page, and the page includes a plurality of layout controls, and in response to the selection operation of the layout controls, the format of the target table can be adjusted.
In another embodiment, referring to fig. 7, the deletion control is disposed on the association link, and the table data processing method further includes:
step S1301, acquiring an association record of an association link, where the association record includes an access object and an outgoing object of the association link;
step S1302, in response to clicking operation of the deletion control, deleting the associated connection line;
in step S1303, when detecting that the associated link is deleted, the outgoing object of the associated link in the associated record is obtained, and the data in the outgoing object is deleted.
It should be noted that, each time the association connection line is constructed, an association record is generated, and the access object and the outgoing object are recorded. When deleting the association line, namely, the two objects which are originally connected through the association line are not associated any more, so that the data in the outgoing object is required to be deleted, and when other tools or controls are prevented from being re-associated with the outgoing object, various data are stored in the outgoing object, so that resource waste is caused, and even in subsequent data processing, abnormal processing can be caused.
As shown in the drawing, fig. 11 is a block diagram of a tabular data processing apparatus according to another embodiment of the present invention. The invention also provides a form data processing device, which comprises:
the processor 1110 may be implemented by a general-purpose central processing unit (Central Processing Unit, CPU), a microprocessor, an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), or one or more integrated circuits, etc., for executing relevant programs to implement the technical solutions provided in the embodiments of the present application;
the Memory 1120 may be implemented in the form of a Read Only Memory (ROM), a static storage device, a dynamic storage device, or a random access Memory (Random Access Memory, RAM). Memory 1120 may store an operating system and other application programs, and when the technical solutions provided in the embodiments of the present application are implemented in software or firmware, relevant program codes are stored in memory 1120, and the processor 1110 invokes a tabular data processing method for executing the embodiments of the present application;
an input/output interface 1130 for implementing information input and output;
the communication interface 1140 is configured to implement communication interaction between the present device and other devices, and may implement communication in a wired manner (e.g. USB, network cable, etc.), or may implement communication in a wireless manner (e.g. mobile network, WIFI, bluetooth, etc.);
a bus 1150 for transferring information between various components of the device (e.g., processor 1110, memory 1120, input/output interface 1130, and communication interface 1140);
wherein processor 1110, memory 1120, input/output interface 1130, and communication interface 1140 implement communication connections among each other within the device via bus 1150.
The embodiment of the application also provides electronic equipment, which comprises the table data processing device.
The embodiment of the application also provides a storage medium, which is a computer readable storage medium, and the storage medium stores a computer program, and the computer program realizes the table data processing method when being executed by a processor.
The memory, as a non-transitory computer readable storage medium, may be used to store non-transitory software programs as well as non-transitory computer executable programs. In addition, the memory may include high-speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, the memory optionally includes memory remotely located relative to the processor, the remote memory being connectable to the processor through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof. The apparatus embodiments described above are merely illustrative, in which the elements illustrated as separate components may or may not be physically separate, implemented to reside in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
Those of ordinary skill in the art will appreciate that all or some of the steps, systems, and methods disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. Some or all of the physical components may be implemented as software executed by a processor, such as a central processing unit, digital signal processor, or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes both volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as known to those skilled in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can be accessed by a computer. Furthermore, as is well known to those of ordinary skill in the art, communication media typically include computer readable instructions, data structures, program modules, or other data in a modulated data signal, such as a carrier wave or other transport mechanism, and may include any information delivery media.
While the preferred embodiment of the present invention has been described in detail, the present invention is not limited to the above embodiments, and those skilled in the art can make various equivalent modifications or substitutions without departing from the spirit and scope of the present invention, and these equivalent modifications or substitutions are included in the scope of the present invention as defined in the appended claims.
Claims (8)
1. A form data processing method, comprising:
displaying an editing interface and a canvas interface, wherein the editing interface comprises an import tool, an export tool and a plurality of selectable operation controls, the selectable operation controls are used for carrying out data processing on an input form according to a preset data processing rule, the import tool is used for importing the form, and the export tool is used for exporting the form;
dragging the importing tool to the canvas interface, clicking the importing tool, and generating a setting panel, wherein the setting panel comprises a plurality of source table files and corresponding table data; selecting operation is carried out in the source table file, the selected source table file is used as a target source table, and the target source table is imported, specifically comprising: dragging the import tool at least twice, and generating and displaying at least two import tools on the canvas interface; respectively importing the corresponding target source tables into each importing tool;
dragging a target operation control to the canvas interface, and generating and displaying an associated connection line in response to clicking operation on the importing tool and releasing operation on the target operation control, wherein the associated connection line is used for indicating the flow direction of data, and the target operation control is the selected selectable operation control and specifically comprises: dragging the selectable operation control at least twice to generate at least two target operation controls; generating and displaying the associated connecting lines based on clicking operation of the importing tool and releasing operation of the target operation control each time, wherein the number of the associated connecting lines is at least 2, and each importing tool is connected with at least one target operation control through the associated connecting lines;
dragging the export tool to the canvas interface, and generating and displaying the associated connection line in response to clicking operation on the target operation control and releasing operation on the export tool;
in response to a configuration completion operation, a form processing tool is generated from the import tool, the target operational control, and the export tool.
2. The method of claim 1, wherein dragging the export tool to the canvas interface generates and displays the associated join line in response to a click operation on the target operational control and a release operation on the export tool, comprising:
dragging the selectable operation control at least twice to generate at least two target operation controls;
and generating and displaying the associated connecting lines based on clicking operation of the target operation control and releasing operation of the export tool each time, wherein the number of the associated connecting lines is at least 2, and each export tool is at least connected with one target operation control through the associated connecting lines.
3. The table data processing method according to claim 1, wherein the target source table generating method includes:
constructing a data source according to the API address;
and acquiring the data source through a direct connection mode, and determining the data source as the target source table.
4. The method of claim 1-2, after said generating a form processing tool from said import tool, said target operation control, and said export tool in response to a configuration completion operation, comprising:
when the table processing tool is triggered to run, the importing tool acquires the target source table and stores the target source table
The form is sent to the target operation control for processing, and a target form is obtained;
when a table acquisition operation is detected, the target table is exported by the export tool.
5. The method according to claim 1, wherein a deletion control is provided on the associated link, the method further comprising:
acquiring an association record of the association connection line, wherein the association record comprises an access object and an access object of the association connection line;
deleting the associated connection line in response to clicking operation of the deletion control;
and when the association connection line is detected to be deleted, acquiring a connected-out object of the association connection line in the association record, and deleting the data in the connected-out object.
6. A tabular data processing apparatus comprising at least one control processor and a memory for communication connection with said at least one control processor; the memory stores instructions executable by the at least one control processor to enable the at least one control processor to perform the tabular data processing method as claimed in any one of claims 1 to 5.
7. An electronic device comprising the tabular data processing apparatus as claimed in claim 6.
8. A computer-readable storage medium storing computer-executable instructions for causing a computer to perform the tabular data processing method as claimed in any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310653837.5A CN116880733B (en) | 2023-06-02 | 2023-06-02 | Table data processing method, apparatus, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310653837.5A CN116880733B (en) | 2023-06-02 | 2023-06-02 | Table data processing method, apparatus, device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116880733A CN116880733A (en) | 2023-10-13 |
| CN116880733B true CN116880733B (en) | 2024-03-12 |
Family
ID=88270519
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310653837.5A Active CN116880733B (en) | 2023-06-02 | 2023-06-02 | Table data processing method, apparatus, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116880733B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109614601A (en) * | 2018-10-23 | 2019-04-12 | 深圳微迅信息科技有限公司 | Form processing method, device, equipment and readable medium based on web |
| CN113407078A (en) * | 2021-06-07 | 2021-09-17 | 远光软件股份有限公司 | Method and device for editing character icon, storage medium and terminal |
| CN114518908A (en) * | 2022-02-17 | 2022-05-20 | 杭州网易云音乐科技有限公司 | Service arranging method, medium, device and computing equipment |
| CN115793914A (en) * | 2023-02-08 | 2023-03-14 | 广州市玄武无线科技股份有限公司 | Multi-round scene interaction flow chart generation method, electronic equipment and storage medium thereof |
| CN115840567A (en) * | 2022-12-22 | 2023-03-24 | 蓝卓数字科技有限公司 | Application editing method and related equipment |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10552030B2 (en) * | 2012-10-15 | 2020-02-04 | Kirusa, Inc. | Multi-gesture media recording system |
| US10652280B2 (en) * | 2017-04-24 | 2020-05-12 | Unisys Corporation | User interface features for enterprise security management |
-
2023
- 2023-06-02 CN CN202310653837.5A patent/CN116880733B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109614601A (en) * | 2018-10-23 | 2019-04-12 | 深圳微迅信息科技有限公司 | Form processing method, device, equipment and readable medium based on web |
| CN113407078A (en) * | 2021-06-07 | 2021-09-17 | 远光软件股份有限公司 | Method and device for editing character icon, storage medium and terminal |
| CN114518908A (en) * | 2022-02-17 | 2022-05-20 | 杭州网易云音乐科技有限公司 | Service arranging method, medium, device and computing equipment |
| CN115840567A (en) * | 2022-12-22 | 2023-03-24 | 蓝卓数字科技有限公司 | Application editing method and related equipment |
| CN115793914A (en) * | 2023-02-08 | 2023-03-14 | 广州市玄武无线科技股份有限公司 | Multi-round scene interaction flow chart generation method, electronic equipment and storage medium thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116880733A (en) | 2023-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10609140B2 (en) | Dynamic resource management systems and methods | |
| CN108153670A (en) | A kind of interface test method, device and electronic equipment | |
| CN110851308A (en) | Test method, test device, electronic equipment and storage medium | |
| CN105472045A (en) | Database migration method and database migration device | |
| JP6547488B2 (en) | INFORMATION PROCESSING APPARATUS AND INFORMATION PROCESSING PROGRAM | |
| CN111078695B (en) | Method and device for calculating association relation of metadata in enterprise | |
| KR101525984B1 (en) | Apparatus and method for document managements determining file names based on rules | |
| CN116880733B (en) | Table data processing method, apparatus, device and storage medium | |
| US11392548B2 (en) | Apparatus for managing folder and method for the same | |
| AU2015207036B2 (en) | Information processing system | |
| US10152039B2 (en) | Method and apparatus for the display of multiple errors on a human-machine interface | |
| US8245182B2 (en) | Class selectable design sharing | |
| US9342530B2 (en) | Method for skipping empty folders when navigating a file system | |
| JP2013131107A (en) | Information process system, information processing unit, information processing method, and computer program | |
| CN106657227B (en) | The method and device of resource is subscribed in a kind of change | |
| US9275358B1 (en) | System, method, and computer program for automatically creating and submitting defect information associated with defects identified during a software development lifecycle to a defect tracking system | |
| CN116679856B (en) | Visual application interface construction method, device, equipment and storage medium | |
| CN105027012A (en) | Programmable controller system, programmable display therefor, and program | |
| JP2013130872A (en) | Map image providing system, map image providing method and program | |
| CN116661762B (en) | System application platform configuration method, device, equipment and storage medium | |
| US20200322289A1 (en) | Information processing apparatus and non-transitory computer readable medium | |
| US20200293496A1 (en) | Information processing apparatus and non-transitory computer readable medium | |
| CN113626409B (en) | Test data processing method, device, equipment and storage medium | |
| JP6279969B2 (en) | Communication device | |
| US20230394386A1 (en) | System and method for creating product compatibility rules for enterprise resource planning system |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |