WO2023001281A1 - 表格数据处理方法、装置、终端和存储介质 - Google Patents

表格数据处理方法、装置、终端和存储介质 Download PDF

Info

Publication number
WO2023001281A1
WO2023001281A1 PCT/CN2022/107357 CN2022107357W WO2023001281A1 WO 2023001281 A1 WO2023001281 A1 WO 2023001281A1 CN 2022107357 W CN2022107357 W CN 2022107357W WO 2023001281 A1 WO2023001281 A1 WO 2023001281A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
field
field name
specified
data processing
Prior art date
Application number
PCT/CN2022/107357
Other languages
English (en)
French (fr)
Inventor
宁辽原
张心如
王聪
张广宇
张文斌
严亮
边金元
仇实
Original Assignee
北京字跳网络技术有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 北京字跳网络技术有限公司 filed Critical 北京字跳网络技术有限公司
Publication of WO2023001281A1 publication Critical patent/WO2023001281A1/zh
Priority to US18/523,862 priority Critical patent/US20240104298A1/en

Links

Images

Classifications

    • 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
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/103—Formatting, i.e. changing of presentation of documents
    • G06F40/106—Display of layout of documents; Previewing
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/903—Querying
    • G06F16/9032—Query formulation
    • 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/0482—Interaction with lists of selectable items, e.g. menus
    • 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
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/174—Form filling; Merging
    • 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
    • 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

Definitions

  • the present disclosure relates to the field of information technology, and in particular to a form data processing method and device, a terminal and a storage medium.
  • the present disclosure provides a form data processing method and device, a terminal and a storage medium.
  • the present disclosure adopts the following technical solutions.
  • an embodiment of the present disclosure provides a form data processing method, the form data processing method comprising: responding to a trigger operation of a specific control related to a specified form, displaying a field screening interface; wherein, the field Each candidate field name in the screening interface is a preset field name existing in at least one data system, and each candidate field name in the field screening interface corresponds to the field name corresponding to the filled column in the specified form has an association relationship; in response to the field name selection operation on the field screening interface, the selected field name is added to the specified form; and the data and fields of the filled columns are completed in the specified form The data corresponding to the name; wherein, the completed data is data from the at least one data system.
  • another embodiment of the present disclosure provides a form data processing device, the form data processing device comprising: a field screening interface display module configured to respond to a trigger operation of a specific control related to a specified form , displaying a field screening interface; wherein, each candidate field name in the field screening interface is a preset field name existing in at least one data system, and each candidate field name in the field screening interface is consistent with the specified
  • the field names corresponding to the filled columns in the table have an association relationship;
  • the field name adding module is configured to add the selected field name to the specified table in response to the field name selection operation on the field screening interface;
  • a data completion module configured to complete the data corresponding to the filled column data and each field name in the specified table; wherein, the completed data is data from the at least one data system.
  • the present disclosure provides a terminal, including: at least one memory and at least one processor; wherein, the memory is used to store program codes, and the processor is used to invoke the program codes stored in the memory to execute the above table data processing method.
  • the present disclosure provides a storage medium for storing program codes, and the program codes are used for executing the above method for processing tabular data.
  • the selected field name is added to the specified table, and the data corresponding to the filled column data and each field name is completed in the specified table , you can directly complete the information to the specified form in the browser or client, reducing the workload of downloading and editing files.
  • FIG. 1 is a flowchart of a tabular data processing method in some embodiments of the present disclosure.
  • Figure 2 is a schematic table of some embodiments of the present disclosure.
  • Fig. 3 is a schematic diagram of a field screening interface according to another embodiment of the present disclosure.
  • FIG. 4 is a schematic flowchart of a tabular data processing method according to another embodiment of the present disclosure.
  • FIG. 5 is a schematic diagram of logical layers of a server of some embodiments of the present disclosure.
  • Fig. 6 is some modules of the tabular data processing apparatus of some embodiments of the present disclosure.
  • FIG. 7 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure.
  • the term “comprise” and its variations are open-ended, ie “including but not limited to”.
  • the term “based on” is “based at least in part on”.
  • the term “one embodiment” means “at least one embodiment”; the term “another embodiment” means “at least one further embodiment”; the term “some embodiments” means “at least some embodiments.” Relevant definitions of other terms will be given in the description below.
  • FIG. 1 provides a flow chart of a tabular data processing method according to an embodiment of the present disclosure.
  • the form data processing method of the present disclosure includes step S101, displaying a field screening interface in response to a trigger operation of a specific control related to a specified form.
  • the specified form may be an online form or an offline form, and the offline form is an offline electronic form.
  • the online form generally refers to a form stored in a server rather than a specific terminal, so that the online form can be viewed at different terminals by logging in.
  • each candidate field name in the field screening interface is a preset field name existing in at least one data system, and has an association relationship with the field name corresponding to the filled column in the specified table.
  • at least one data system may refer to a server storing data, a productized data management system, or even a data file such as a spreadsheet storing data.
  • a table generally consists of rows and columns, with populated columns referring to columns that have been pre-populated with corresponding data (eg, product names).
  • each candidate field name in the field screening interface has an association relationship with the field name corresponding to the filled column in the specified table.
  • the filled column is a mobile phone product, such as the model of various mobile phones, then the field
  • the candidate field names in the screening interface are fields related to mobile phone products, such as memory, screen size, screen resolution and other mobile phone-related parameters. Therefore, when the field name (for example, product name, etc.) corresponding to the filled column changes, the candidate field names in the field screening interface also change accordingly.
  • each candidate field name in the field screening interface is a field related to skin care products, such as shelf life, main ingredients, etc.
  • the disclosed method further includes step S102, adding the selected field name to the specified form in response to the field name selection operation on the field screening interface.
  • the operation of selecting a field name on the field screening interface may include an operation of inputting or checking a corresponding field name.
  • FIG. 2 a schematic diagram of a specified form in some embodiments is shown, wherein the filled column is the first column, and the field name corresponding to the filled column is the model of the home appliance product (for example, product 1, product 2 etc.), in response to the field name selection operation on the field screening interface, the selected field name (for example, manufacturer, power, price, etc.) is added to the specified table.
  • the disclosed method further includes step S103, completing the data corresponding to the filled column data and each field name in the specified table.
  • the completed data is data from at least one data system. As shown in Figure 2, complete the data corresponding to the data in the filled columns (product 1, product 2, etc.) and the names of each field (manufacturer, power, price, etc.) in the specified table.
  • Embodiments of the present disclosure present a field screening interface by responding to a trigger operation of a specific control related to a specified form, responding to a field name selection operation on the field screening interface, adding the selected field name to the specified form, and
  • the data corresponding to the filled column data and each field name can be completed in the specified table, so that the information can be directly completed in the browser or client to the specified table, reducing the workload of downloading and editing files.
  • the conventional operation is to download corresponding data from various data systems, and then integrate them together.
  • data can be automatically obtained from at least one data system through the trigger operation of a specific control, and the obtained data can be supplemented. All into the specified form, greatly reducing the workload of editing and sorting out relevant data.
  • Fig. 3 shows a schematic diagram of a field screening interface in some embodiments.
  • the field screening interface further includes an input control for inserting a starting column.
  • adding the selected field names to the specified table includes: adding the selected field names to the specified table starting from the input insertion start column. For example, if the starting column for insertion determined on the field screening interface is column B, add the selected field name "manufacturer" to column B of the specified table; if the starting column for inserting determined on the field filtering interface is column H , then add the selected field name "manufacturer" to column H of the specified table. This allows the user to add the corresponding field name to the user-specified column.
  • the field screening interface further includes a field search control.
  • the form data processing method further includes: in response to information entered in the field search control, displaying field names matching the entered information, wherein the displayed field names are field names existing in at least one data system .
  • some field names may not be displayed in the current field filtering interface, at this time, they can be searched and displayed in the search control.
  • a field name "size” matching the input information "size” is displayed, and the field name "size” is a field name existing in at least one data system.
  • the table data processing method further includes: updating the data in the specified table in response to the operation of requesting data update, and displaying the changed data differently.
  • it is sometimes necessary to update the data information in the specified table because the data information in the data system may be updated over time. In this way, the above steps of completing the data can be repeated, and then the updated data overwrites the previous data to achieve the effect of data updating.
  • the data update of the designated form of the present disclosure can be performed on the basis of the previous version, which is very convenient for data update.
  • the corresponding cell or updated data may be displayed differently (eg, marked).
  • the distinctive display or indicia may include a change in color of the font and/or a highlighted background indicium.
  • the data update can be performed on the basis of the previous version, and the changed data can be updated. The difference is displayed, which greatly facilitates the user's data processing.
  • the specific control is a plug-in for the browser, and the tabular data processing method is performed by the plug-in.
  • a specified form for example, an online form
  • the form data processing method is implemented through a browser plug-in, which greatly facilitates form data processing and improves form data processing efficiency.
  • the tabular data processing method before the step of displaying the field screening interface, further includes: acquiring the field name corresponding to the filled column from the specified form, and sending a query request including the acquired field name to the server.
  • the field names used in different data systems may be different, and before querying each data system for the data corresponding to the corresponding field name, a file containing the obtained field name may be sent to the server. Query request to obtain the specific representation of the corresponding field name in each data system. Afterwards, the field name query request result fed back by the server is received.
  • the result of the field name query request is obtained by the server according to a pre-stored field name mapping list, and the field name mapping list stores the mapping relationship of each field name in at least one system.
  • the field name mapping list it is possible to use the same field name corresponding to the filled column obtained from the specified table to query the corresponding field name in multiple different data systems.
  • the populated column of the designated table is a pre-designated or first column.
  • the corresponding information is firstly filled in the first column, of course, any column can also be pre-designated as the filled column.
  • the form data processing method before completing the data corresponding to the data in the filled columns and the names of the fields in the specified form, the form data processing method further includes: sending the data containing the filled columns and the names of the fields in the form to the server data query request. For example, if you want to query the power of product 1, send a data query request including product 1 and the field name "power" to the server, and the server will query the corresponding data system for the corresponding data query result. Afterwards, the data query request result fed back by the server is received. In some embodiments, the result of the data query request is obtained by the server through query based on the data of at least one data system. Therefore, through the method of the present disclosure, the corresponding data query request result can be automatically received from the server, and the efficiency of data query can be improved.
  • the triggering operation of the specific control related to the specified form includes: triggering the operation of the specific control (eg, plug-in) of the browser on the online form page. This usually applies in the case of online forms.
  • the triggering operation of the specific control related to the specified form includes: inputting the identifier of the offline electronic form in the specific control and triggering the operation of the specific control.
  • This situation also applies to regular tables, such as Excel tables. For example, by installing the corresponding applet or client, and entering the identifier of the offline electronic form in the specific control of the applet or client, the electronic form as the operation object can be determined, and then the subsequent operations can be performed by triggering the operation of the specific control Data completion or update, etc.
  • the data for example, product number
  • field name of the filled column input or selected by the user are received, and a data query request is sent to the server.
  • the data query request includes the data of the filled column of the online form and the field name selected by the user Field Name.
  • the server will obtain the field names existing in the corresponding data system in the field name mapping list based on the field names, and map the corresponding field names to corresponding field names of other systems based on the field name mapping list, and enter the data access layer.
  • Data information (eg, data source A, data source B, and data source C) acquired from various data systems (eg, system A, system B, and system C) is returned to the data access layer. Then the corresponding data information output by the server is received, and the corresponding data information is completed into the cell corresponding to the data of the filled column of the specified table and the name of each field.
  • the server includes an access layer, an aggregation layer , the query layer and the data layer.
  • the access layer the data query request sent by the plug-in (or client, applet) of the browser is received.
  • the service authentication can be performed on the data query request to determine whether With the right to obtain data information, you can limit the flow when the real-time access to the server exceeds the first preset value, limit the amount of data transmission with the aggregation layer, and suspend receiving data when the real-time access exceeds the second preset value
  • a cache may be set in the access layer to temporarily store data query requests.
  • the aggregation layer receives the target object associated with the target information from the access layer and the type of preset information that needs to be searched, and then uses the GraphQL protocol to provide a unified entity information query language.
  • the aggregation layer has a resolver (Resolver) for information acquisition.
  • the request is parsed to generate the information query statement of the information source paragraph and the condition paragraph.
  • the specific generation method is the same as the above description.
  • the information query statement is transmitted to the query layer, and the information query statement is analyzed at the query layer. If you have the permission, you can connect with other systems through the connection ports accessible by other systems (such as information bases), so as to obtain the associated information stored in other systems.
  • Information different preset systems can use different databases, such as MySQL database, SheetDB database, etc. Different databases need to use different connectors, so you can use MySQL Provider, SheetDB Provider to connect to the corresponding database, or use Remote login is used to connect to other preset systems.
  • RPC Remote Procedure Call Protocol
  • Connector can be used to call the algorithm service through the authorization file License and password Passport to obtain associated information.
  • the server After the server obtains the information associated with the target information from other systems, it sends it to the first plug-in of the browser, so that the browser can aggregate and display it.
  • the server obtains the information associated with the target information from other systems The information associated with the target information is sent to the first plug-in of the browser of the terminal, so that the first plug-in performs information aggregation on the obtained related information, which is convenient for the user to view.
  • the embodiment of the present disclosure also provides a table data processing apparatus 600 , including a field screening interface display module 601 , a field name adding module 602 and a data completion module 603 .
  • the field screening interface display module 601 is configured to display a field screening interface in response to a trigger operation of a specific control related to a specified form; wherein, each candidate field name in the field screening interface is at least one preset data The field name that exists in the system and has an association relationship with the field name corresponding to the populated column in the specified table.
  • the field name adding module 602 is configured to add the selected field name to the specified form in response to a field name selection operation on the field screening interface.
  • the data completion module 603 is configured to complete the data corresponding to the filled column data and the names of the fields in the specified table; wherein, the completed data comes from the at least one data system The data.
  • the field screening interface also includes an input control for inserting the starting column; adding the selected field name to the specified table includes: adding the selected field name to the specified table starting from the input starting column. form.
  • the field screening interface also includes a field search control; the field screening interface display module is also configured to respond to the input information in the field search control, and display the field name matching the input information, wherein the displayed field name is a field name that exists in at least one data system.
  • the form data processing apparatus further includes: a data update module configured to update the data in the specified form in response to the operation of requesting data update, and display the changed data differently.
  • the specific control is a browser plug-in, and the form data processing method is executed by the plug-in.
  • the form data processing device further includes: a query request sending module, configured to obtain the field name corresponding to the filled column from the specified form before the step of displaying the field screening interface, and send the query request containing the obtained field name to the server. name query request; the request result receiving module is configured to receive the field name query request result fed back by the server; wherein, the field name query request result is obtained by the server according to the pre-stored field name mapping list, and the field name mapping list stores at least The mapping relationship of each field name in a system.
  • the populated column of the designated table is a pre-designated or first column.
  • the query request sending module is further configured to send the data containing the filled columns and the names of the fields in the table to the server before completing the data corresponding to the filled columns and the names of the fields in the specified table
  • the data query request; the request result receiving module is also configured to receive the data query request result fed back by the server; wherein, the data query request result is obtained by the server through query based on the data of at least one data system.
  • the triggering operation of the specific control related to the specified form includes: triggering the operation of the specific control of the browser on the online form page; or inputting the identifier of the offline electronic form in the specific control and triggering the operation of the specific control.
  • the form data processing method of the present disclosure can automatically query corresponding data information from a plurality of different data systems according to the data and field names of the filled columns, and then output them to the corresponding cells of the corresponding client to realize the data information in the specified form.
  • the intelligent sorting of data information greatly saves the workload of data sorting compared to the usual way of sorting out data after downloading it from each system separately.
  • the field name mapping list is stored in the server, and the field name mapping list includes the mapping relationship of field names in different data systems, and then through the mapping relationship of field names between different data systems, through a data system Query the field name in other data systems, and obtain the data information corresponding to the field name.
  • the present disclosure also provides a terminal, including: at least one memory and at least one processor; wherein, the memory is used to store program codes, and the processor is used to call the program codes stored in the memory to execute the above table data processing method.
  • the present disclosure also provides a computer storage medium, where the computer storage medium stores program codes, and the program codes are used to execute the above-mentioned form data processing method.
  • the form data processing method and device of the present disclosure have been described based on the embodiments and application examples.
  • the present disclosure also provides a terminal and a storage medium, which are described below.
  • FIG. 7 it shows a schematic structural diagram of an electronic device (such as a terminal device or a server) 400 suitable for implementing an embodiment of the present disclosure.
  • the terminal equipment in the embodiment of the present disclosure may include but not limited to such as mobile phone, notebook computer, digital broadcast receiver, PDA (personal digital assistant), PAD (tablet computer), PMP (portable multimedia player), vehicle terminal (such as mobile terminals such as car navigation terminals) and fixed terminals such as digital TVs, desktop computers and the like.
  • the electronic device shown in FIG. 7 is only an example, and should not limit the functions and application scope of the embodiments of the present disclosure.
  • an electronic device 400 may include a processing device (such as a central processing unit, a graphics processing unit, etc.) 401, which may be randomly accessed according to a program stored in a read-only memory (ROM) 402 or loaded from a storage device 408.
  • ROM read-only memory
  • RAM random access memory
  • various appropriate actions and processes are executed by programs in the memory (RAM) 403 .
  • RAM random access memory
  • various programs and data necessary for the operation of the electronic device 400 are also stored.
  • the processing device 401, the ROM 402, and the RAM 403 are connected to each other through a bus 404.
  • An input/output (I/O) interface 405 is also connected to bus 404 .
  • the following devices can be connected to the I/O interface 405: input devices 406 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; including, for example, a liquid crystal display (LCD), speaker, vibration an output device 407 such as a computer; a storage device 408 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 409.
  • the communication means 409 may allow the electronic device 400 to perform wireless or wired communication with other devices to exchange data. While FIG. 7 shows electronic device 400 having various means, it should be understood that implementing or having all of the means shown is not a requirement. More or fewer means may alternatively be implemented or provided.
  • embodiments of the present disclosure include a computer program product, which includes a computer program carried on a computer-readable medium, where the computer program includes program codes for executing the methods shown in the flowcharts.
  • the computer program may be downloaded and installed from a network via communication means 409, or from storage means 408, or from ROM 402.
  • the processing device 401 When the computer program is executed by the processing device 401, the above-mentioned functions defined in the methods of the embodiments of the present disclosure are performed.
  • the above-mentioned computer-readable medium in the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two.
  • a computer readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to, electrical connections with one or more wires, portable computer diskettes, hard disks, random access memory (RAM), read-only memory (ROM), erasable Programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination of the above.
  • a computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
  • a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave carrying computer-readable program code therein. Such propagated data signals may take many forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing.
  • a computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium, which can transmit, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device .
  • Program code embodied on a computer readable medium may be transmitted by any appropriate medium, including but not limited to wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.
  • the above-mentioned computer-readable medium may be included in the above-mentioned electronic device, or may exist independently without being incorporated into the electronic device.
  • the above-mentioned computer-readable medium carries one or more programs, and when the above-mentioned one or more programs are executed by the electronic device, the electronic device is made to execute the above-mentioned method of the present disclosure.
  • Computer program code for carrying out the operations of the present disclosure can be written in one or more programming languages, or combinations thereof, including object-oriented programming languages—such as Java, Smalltalk, C++, and conventional Procedural Programming Language - such as "C" or a similar programming language.
  • the program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server.
  • the remote computer can be connected to the user computer through any kind of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computer (such as through an Internet service provider). Internet connection).
  • LAN local area network
  • WAN wide area network
  • Internet service provider such as AT&T, MCI, Sprint, EarthLink, MSN, GTE, etc.
  • each block in a flowchart or block diagram may represent a module, program segment, or portion of code that contains one or more logical functions for implementing specified executable instructions.
  • the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or they may sometimes be executed in the reverse order, depending upon the functionality involved.
  • each block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations can be implemented by a dedicated hardware-based system that performs the specified functions or operations , or may be implemented by a combination of dedicated hardware and computer instructions.
  • the units involved in the embodiments described in the present disclosure may be implemented by software or by hardware. Wherein, the name of a unit does not constitute a limitation of the unit itself under certain circumstances.
  • FPGAs Field Programmable Gate Arrays
  • ASICs Application Specific Integrated Circuits
  • ASSPs Application Specific Standard Products
  • SOCs System on Chips
  • CPLD Complex Programmable Logical device
  • a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device.
  • a machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium.
  • a machine-readable medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing.
  • machine-readable storage media would include one or more wire-based electrical connections, portable computer discs, hard drives, random access memory (RAM), read only memory (ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, compact disk read only memory (CD-ROM), optical storage, magnetic storage, or any suitable combination of the foregoing.
  • RAM random access memory
  • ROM read only memory
  • EPROM or flash memory erasable programmable read only memory
  • CD-ROM compact disk read only memory
  • magnetic storage or any suitable combination of the foregoing.
  • Example 1 provides a form data processing method, characterized in that the form data processing method includes: responding to a trigger operation of a specific control related to a specified form, displaying Field screening interface; wherein, each candidate field name in the field screening interface is a preset field name existing in at least one data system, and is associated with the field name corresponding to the filled column in the specified form relationship; in response to the field name selection operation on the field screening interface, the selected field name is added to the specified table; and the data corresponding to the filled column and each field name are completed in the specified table data; wherein, the completed data is data from the at least one data system.
  • Example 2 provides the method described in Example 1, wherein, the field screening interface further includes an input control for inserting a starting column; the adding the selected field name to Adding to the specified table includes: adding the selected field name to the specified table starting from the input insertion start column.
  • Example 3 provides the method described in Example 1, wherein the field screening interface further includes a field search control; the form data processing method further includes: responding to the information input in the field search control, and display a field name matching the input information, wherein the displayed field name is a field name existing in the at least one data system.
  • Example 4 provides the method described in Example 1, wherein the form data processing method further includes: updating the specified form in response to the operation of requesting data update data, and display the changed data differently.
  • Example 5 provides the method described in Example 1, wherein the specific control is a browser plug-in, and the tabular data processing method is executed by the plug-in.
  • Example 6 provides the method described in Example 5, wherein, before the step of displaying the field screening interface, the form data processing method further includes: from the specified The form obtains the field name corresponding to the filled column, sends a query request containing the obtained field name to the server; receives the field name query request result fed back by the server; wherein, the field name query request result is obtained by the server according to the pre-stored field
  • the name mapping list is queried, and the mapping relationship of each field name in the at least one system is stored in the field name mapping list.
  • Example 7 provides the method described in Example 6, wherein the filled column of the specified table is a pre-specified column or the first column.
  • Example 8 provides the method described in Example 5, wherein, before completing the data corresponding to the filled column data and each field name in the specified table, the The form data processing method also includes: sending to the server a data query request containing the data of the filled column and each field name in the table; receiving the data query request result fed back by the server; wherein, the data query request result is It is obtained by querying based on the data of the at least one data system.
  • Example 9 provides the method described in Example 1, wherein the triggering operation of the specific control related to the specified form includes: triggering the specific control of the browser on the online form page The operation of the control; or input the identifier of the offline electronic form in a specific control and trigger the operation of the specific control.
  • Example 10 provides a form data processing device, the form data processing device includes: a field screening interface display module configured to respond to the specific control related to the specified form Trigger an operation to display a field screening interface; wherein, each candidate field name in the field screening interface is a field name that exists in at least one preset data system, and each candidate field name in the field screening interface is consistent with the field name
  • the field names corresponding to the filled columns in the specified form have an association relationship;
  • the field name adding module is configured to add the selected field name to the specified form in response to the field name selection operation on the field screening interface and a data completion module configured to complete the data corresponding to the filled column data and each field name in the specified form; wherein, the completed data comes from the at least one data system data.
  • Example 11 provides a terminal, including: at least one memory and at least one processor; wherein the at least one memory is used to store program codes, and the at least one processor The device is used to call the program code stored in the at least one memory to execute the method described in any one of the above Examples 1-9.
  • Example 12 provides a storage medium, the storage medium is used to store program code, and the program code is used to execute the method described in any one of Examples 1-9. method.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Human Computer Interaction (AREA)
  • Databases & Information Systems (AREA)
  • Mathematical Physics (AREA)
  • Data Mining & Analysis (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本公开提供表格数据处理方法及装置、终端和存储介质。表格数据处理方法包括：响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面；其中，字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称，且字段筛选界面中的各候选字段名称与指定表格中的已填充列所对应的字段名称具有关联关系；响应于字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到指定表格中；以及在指定表格中补全与已填充列的数据和各字段名称对应的数据；其中，所补全的数据是来自于至少一个数据系统中的数据。本公开的方法可以实现直接在浏览器或客户端中补全信息到指定表格，减少了下载、编辑文件的工作量。

Description

表格数据处理方法、装置、终端和存储介质
相关申请的交叉引用
本申请基于申请号为202110839653.9、申请日为2021年07月23日，名称为“表格数据处理方法、装置、终端和存储介质”的中国专利申请提出，并要求该中国专利申请的优先权，该中国专利申请的全部内容在此引入本申请作为参考。
技术领域
本公开涉及信息技术领域，尤其涉及表格数据处理方法及装置、终端和存储介质。
背景技术
在处理和分析一些数据(例如，产品数据)时，通常需要从不同的数据系统中获取数据到表格中进行分析。通常地，分别从多个数据系统中下载数据到多个csv/excel文件中，按照行的主字段(例如，产品名称、产品ID等)，手动编辑操作，将多份结果数据合并起来；或者，在excel等表格软件中，通过“从web”功能直接从在线应用程序编程接口(API)获取数据到表格中。
发明内容
为解决现有问题，本公开提供一种表格数据处理方法及装置、终端和存储介质。
本公开采用以下的技术方案。
在一些实施例中，本公开的实施例提供一种表格数据处理方法，所述表格数据处理方法包括：响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面；其中，所述字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称，且所述字段筛选界面中的各候选字段名称与所述指定表格中的已填充列所对应的字段名称具有关联关系；响应于所述字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到所述指 定表格中；以及在所述指定表格中补全与已填充列的数据和各字段名称对应的数据；其中，所补全的数据是来自于所述至少一个数据系统中的数据。
在一些实施例中，本公开的另一实施例提供了一种表格数据处理装置，所述表格数据处理装置包括：字段筛选界面展示模块，配置为响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面；其中，所述字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称，且所述字段筛选界面中的各候选字段名称与所述指定表格中的已填充列所对应的字段名称具有关联关系；字段名称添加模块，配置为响应于所述字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到所述指定表格中；以及数据补全模块，配置为在所述指定表格中补全与已填充列的数据和各字段名称对应的数据；其中，所补全的数据是来自于所述至少一个数据系统中的数据。
在一些实施例中，本公开提供一种终端，包括：至少一个存储器和至少一个处理器；其中，存储器用于存储程序代码，处理器用于调用所述存储器所存储的程序代码执行上述表格数据处理方法。
在一些实施例中，本公开提供一种存储介质，所述存储介质用于存储程序代码，所述程序代码用于执行上述表格数据处理方法。
本公开的实施例通过响应于字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到指定表格中，并且在指定表格中补全与已填充列的数据和各字段名称对应的数据，可以实现直接在浏览器或客户端中补全信息到指定表格，减少了下载、编辑文件的工作量。
附图说明
结合附图并参考以下具体实施方式，本公开各实施例的上述和其他特征、优点及方面将变得更加明显。贯穿附图中，相同或相似的附图标记表示相同或相似的元素。应当理解附图是示意性的，元件和元素不一定按照比例绘制。
图1是本公开的一些实施例的表格数据处理方法的流程图。
图2是本公开的一些实施例的示意性表格。
图3是本公开的另一实施例的字段筛选界面的示意图。
图4是本公开的另一实施例的表格数据处理方法的示意流程图。
图5是本公开的一些实施例的服务器的逻辑层的示意图。
图6是本公开的一些实施例的表格数据处理装置的部分模块。
图7是本公开实施例的电子设备的结构示意图。
具体实施方式
下面将参照附图更详细地描述本公开的实施例。虽然附图中显示了本公开的某些实施例，然而应当理解的是，本公开可以通过各种形式来实现，而且不应该被解释为限于这里阐述的实施例，相反提供这些实施例是为了更加透彻和完整地理解本公开。应当理解的是，本公开的附图及实施例仅用于示例性作用，并非用于限制本公开的保护范围。
应当理解，本公开的方法实施方式中记载的各个步骤可以按和/或并行执行。此外，方法实施方式可以包括附加的步骤和/或省略执行示出的步骤。本公开的范围在此方面不受限制。在本公开的实施例中，“和/或”可以表示描述的元素的一个或多个，既可以包括描述的全部元素，也可以省略其中的部分元素。本公开中的“A和/或B”表示包括并列的三种情况：A；B；A和B。即表示A和B中的至少一个。
本文使用的术语“包括”及其变形是开放性包括，即“包括但不限于”。术语“基于”是“至少部分地基于”。术语“一个实施例”表示“至少一个实施例”；术语“另一实施例”表示“至少一个另外的实施例”；术语“一些实施例”表示“至少一些实施例”。其他术语的相关定义将在下文描述中给出。
需要注意，本公开中提及的“第一”、“第二”等概念仅用于对不同的装置、模块或单元进行区分，并非用于限定这些装置、模块或单元所执行的功能的顺序或者相互依存关系。
需要注意，本公开中提及的“一个”的修饰是示意性而非限制性的，本领域技术人员应当理解，除非在上下文另有明确指出，否则应该理解为“一个或多个”。
本公开实施方式中的多个装置之间所交互的消息或者信息的名称仅用于说明性的目的，而并不是用于对这些消息或信息的范围进行限制。
图1提供了本公开的实施例的表格数据处理方法的流程图。本公开的表格数据处理方法包括步骤S101，响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面。
在一些实施例中，指定表格可以是在线表格或非在线表格，非在线表格即离线的电子表格。在一些实施例中，在线表格通常是指存储在服务器中而不是特定终端中的表格，使得可以在不同的终端进行登录查看在线表格。在一些实施例中，字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称，且与指定表格中的已填充列所对应的字段名称具有关联关系。在一些实施例中，至少一个数据系统可以是指存储有数据的服务器、产品化的数据管理系统，甚至可以是存储有数据的电子表格等数据文件。
在一些实施例中，表格通常由行和列组成，已填充列是指已经预先填充了相应数据(例如，产品名称)的列。在一些实施例中，字段筛选界面中的各候选字段名称与指定表格中的已填充列所对应的字段名称具有关联关系，例如，已填充列是手机产品，如各种手机的型号，则字段筛选界面中的候选字段名称是与手机产品相关的字段，如内存、屏幕尺寸、屏幕分辨率等手机相关的参数。因此，已填充列所对应的字段名称(例如，产品名称等)变化的情况下，字段筛选界面中的候选字段名称也相应变化。例如已填充列是护肤品时，字段筛选界面中的各候选字段名称是与护肤品相关的字段，如保质期、主要成分等。
本公开的方法还包括步骤S102，响应于字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到指定表格中。在一些实施例中，字段筛选界面上的字段名称选择操作可以包括相应字段名称的输入或勾选操作等。例如，如图2所示，示出了一些实施例中的指定表格的示意图，其中已填充列为第一列，已填充列所对应的字段名称为家电产品型号(例如，产品1、产品2等)，响应于字段筛选界面上的字段名称选择操作，将所选择的字段名称(例如，生产厂家、功率、价格等)添加到指定表格中。
本公开的方法还包括步骤S103，在指定表格中补全与已填充列的数据和各字段名称对应的数据。在一些实施例中，所补全的数据是来自于至少一个数据系统中的数据。如图2所示，在指定表格中补全与已填充列的数据(产品1、产品2等)和各字段名称(生产厂家、功率、价格等)对应的数据。
本公开的实施例通过响应于与指定表格相关的特定控件的触发操作，展 示字段筛选界面，响应于字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到指定表格中，并且在指定表格中补全与已填充列的数据和各字段名称对应的数据，从而可以实现直接在浏览器或客户端中补全信息到指定表格，减少了下载、编辑文件的工作量。常规的操作是从各个数据系统中下载相应的数据，然后整合在一起，通过采用本公开的方法，可以通过特定控件的触发操作等自动从至少一个数据系统中获取数据，并且将获取的数据补全到指定表格中，大大减少了编辑和整理相关数据的工作量。
图3示出了一些实施例中的字段筛选界面的示意图。如图3所示，在一些实施例中，字段筛选界面上还包括插入起始列输入控件。在一些实施例中，将所选择的字段名称添加到指定表格中包括：将所选择的字段名称从所输入的插入起始列开始添加到指定表格中。例如，假如字段筛选界面上确定的插入起始列为B列，则将所选择的字段名称“生产厂家”添加到指定表格的B列；假如字段筛选界面上确定的插入起始列为H列，则将所选择的字段名称“生产厂家”添加到指定表格的H列。如此，使得用户可以将相应字段名称添加到用户指定的列中。
如图3所示，在一些实施例中，字段筛选界面上还包括字段搜索控件。在一些实施例中，表格数据处理方法还包括：响应于字段搜索控件中输入的信息，展示与输入的信息相匹配的字段名称，其中所展示的字段名称是至少一个数据系统中存在的字段名称。例如，有一些字段名称可能未显示在当前的字段筛选界面中，此时可以通过搜索控件中搜索得到并且展示。例如，当在字段搜索控件中输入“大小”时，展示与输入的信息“大小”匹配的字段名称“尺寸”，而字段名称“尺寸”是至少一个数据系统中存在的字段名称。通过在字段筛选界面上设置字段搜索控件，可以使用户更便利地查找和选择相应的字段名称。
在一些实施例中，表格数据处理方法还包括：响应于请求更新数据的操作，更新指定表格中的数据，并将有变化的数据区别显示。在一些实施例中，有时需要对指定表格中的数据信息进行更新，因为数据系统中的数据信息可能随着时间会有更新。如此，可以重复上述补全数据的步骤，然后将更新的数据覆盖之前的数据，达到数据更新的效果。如此，本公开的指定表格的数据更新可以在上一版本的基础上进行，非常便利进行数据的更新。在一些实施例中，在更新的数据与之前的数据不同时，可以对相应的单元格或更新的 数据进行区别显示(例如，作标记)。即，在更新的数据与上一版本的数据不同时，此时相应的单元格的数据发生了改变。通过对单元格或更新的数据进行区别显示，可以让用户获知哪些数据发生了改变，便利用户对数据的处理。在一些实施例中，区别显示或标记可以包括字体的颜色的改变和/或高亮背景标记。在现有的表格数据更新方法中，通常是需要重新从数据系统下载，然后重新整合数据，通过采用本公开的方法，可以在上一版本的基础上进行数据更新，并且可以将变化的数据进行区别显示，大大便利了用户的数据处理。
在一些实施例中，特定控件是浏览器的插件，并且表格数据处理方法由插件执行。在一些实施例中，可以在浏览器中实时显示指定表格(例如，在线表格)，通过浏览器的插件实现表格数据处理方法，大大便利了表格的数据处理，提升了表格的数据处理的效率。
在一些实施例中，在展示字段筛选界面的步骤之前，表格数据处理方法还包括：从指定表格获取已填充列所对应的字段名称，向服务器发送包含所获取的字段名称的查询请求。在一些实施例中，针对同样的数据信息，不同的数据系统中所采用的字段名称可能不同，在向各个数据系统查询相应字段名称对应的数据之前，可以向服务器发送包含所获取的字段名称的查询请求，以获取相应的字段名称在各个数据系统中的具体表示。之后，接收服务器反馈的字段名称查询请求结果。在一些实施例中，字段名称查询请求结果是服务器根据预先存储的字段名称映射列表查询得到，字段名称映射列表中保存了至少一个系统中的各字段名称的映射关系。通过该字段名称映射列表，能够实现利用同样的从指定表格获取的已填充列所对应的字段名称，在多个不同的数据系统中进行相应字段名称的查询。
在一些实施例中，指定表格的已填充列为预先指定的列或第一列。通常地，首先在第一列填充相应的信息，当然，也可以预先指定任意列作为已填充列。
在一些实施例中，在指定表格中补全与已填充列的数据和各字段名称对应的数据之前，表格数据处理方法还包括：向服务器发送包含已填充列的数据和表格中的各字段名称的数据查询请求。例如，如果要查询产品1的功率，则将包含产品1和字段名称“功率”的数据查询请求发送至服务器，由服务器向相应的数据系统查询相应的数据查询请求结果。之后，接收服务器反馈的数据查询请求结果。在一些实施例中，数据查询请求结果是服务器基于至 少一个数据系统的数据进行查询得到的。因此，通过本公开的方法，可以自动地从服务器接收相应的数据查询请求结果，能够提高数据查询的效率。
在一些实施例中，与指定表格相关的特定控件的触发操作包括：在在线表格页面上触发浏览器的特定控件(例如，插件)的操作。这通常适用于在线表格的情况。
在一些实施例中，与指定表格相关的特定控件的触发操作包括：在特定控件中输入离线电子表格的标识并触发特定控件的操作。这种情况也适应于常规表格，例如Excel表格。例如，通过安装相应的小程序或客户端，在小程序或客户端的特定控件中输入离线电子表格的标识，从而可以确定作为操作对象的电子表格，之后通过触发特定控件的操作，来进行后续的数据补全或更新等。
下面结合图4进行上述表格数据处理方法的描述，以更好地理解本公开的实施例。如图4所示，接收用户输入或选择的已填充列的数据(例如，产品编号)和字段名称，向服务器发送数据查询请求，数据查询请求包括在线表格的已填充列的数据和用户选择的字段名称。然后，服务器会基于字段名称在字段名称映射列表中获取相应的数据系统中存在的字段名称，并且基于字段名称映射列表将相应的字段名称映射成相应其它系统的字段名称，进入数据访问层。从各个数据系统(例如，系统A、系统B和系统C)中获取的数据信息(例如，数据源A、数据源B和数据源C)返回到数据访问层。然后接收服务器输出的相应的数据信息，并且将相应的数据信息补全到与指定表格的已填充列的数据和各字段名称对应的单元格中。
在一些实施例中，为了清楚的说明本公开实施例中服务器的执行步骤，请参考图5，图5示意性的显示了服务器的架构，在一些实施例中，服务器包括接入层、聚合层、查询层和数据层，在接入层中接收浏览器的插件(或者客户端、小程序)发送的数据查询请求，在接收到数据查询请求后，可以对数据查询请求进行服务鉴权确定是否有获取数据信息的权限，可以在访问服务器的实时访问量超过第一预设值时进行限流，限制与聚合层的数据传输量，以及在实时访问量超过第二预设值时暂停接收数据查询请求，接入层中可以设置有缓存，用于暂时存储数据查询请求。在聚合层接收接入层传入的目标信息关联的目标对象和需要查找的预设信息种类，然后使用基于GraphQL协议提供统一的实体信息查询语言，聚合层具有解析器(Resolver),对信息获取请求进行解析生成信息源段落和条件段落的信息查询语句，具体 生成方式同上方描述，信息查询语句传输至查询层，在查询层对信息查询语句进行解析，先进行信息鉴权，确定具有获取预设的其他系统中关联的信息的权限，在具有该权限的情况下，通过其他系统(例如信息库)可访问的连接端口与其他系统进行连接，从而获取到其他系统存储的目标信息的关联的信息，不同的预设系统可以采用不同的数据库，例如可以采用MySQL数据库、SheetDB数据库等，不同的数据库需要采用不同的连接器，因此可以使用MySQL Provider、SheetDB Provider连接对应的数据库，也可以是采用远程登录的方式连接预设的其他系统，此时可以使用RPC(Remote Procedure Call Protocol)Connector，通过授权文件License和密码Passport调用算法服务以获取关联的信息。一些实施例中，服务器从其他系统中获取到目标信息关联的信息之后，发送到浏览器的第一插件，以使浏览器上进行聚合显示，一些实施例中，服务器将其他系统中获取到的与目标信息关联的信息发送到终端的浏览器的第一插件，以使第一插件对获取到的关联信息进行信息聚合，方便用户查看。
本公开的实施例还提供了一种表格数据处理装置600，包括字段筛选界面展示模块601、字段名称添加模块602和数据补全模块603。在一些实施例中，字段筛选界面展示模块601配置为响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面；其中，字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称，且与指定表格中的已填充列所对应的字段名称具有关联关系。在一些实施例中，字段名称添加模块602配置为响应于字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到指定表格中。在一些实施例中，数据补全模块603配置为在指定表格中补全与已填充列的数据和各字段名称对应的数据；其中，所补全的数据是来自于所述至少一个数据系统中的数据。
应该理解，关于表格数据处理方法描述的内容也适用于此处的表格数据处理装置600，为了简单的目的，在此不进行详细描述。
在一些实施例中，字段筛选界面上还包括插入起始列输入控件；将所选择的字段名称添加到指定表格中包括：将所选择的字段名称从所输入的插入起始列开始添加到指定表格中。在一些实施例中，字段筛选界面上还包括字段搜索控件；字段筛选界面展示模块还配置为响应于字段搜索控件中输入的信息，展示与输入的信息相匹配的字段名称，其中所展示的字段名称是至少一个数据系统中存在的字段名称。在一些实施例中，表格数据处理装置还包 括：数据更新模块，配置为响应于请求更新数据的操作，更新指定表格中的数据，并将有变化的数据区别显示。在一些实施例中，特定控件是浏览器的插件，表格数据处理方法由插件执行。在一些实施例中，表格数据处理装置还包括：查询请求发送模块，配置为在展示字段筛选界面的步骤之前，从指定表格获取已填充列所对应的字段名称，向服务器发送包含所获取的字段名称的查询请求；请求结果接收模块，配置为接收服务器反馈的字段名称查询请求结果；其中，字段名称查询请求结果是服务器根据预先存储的字段名称映射列表查询得到，字段名称映射列表中保存了至少一个系统中的各字段名称的映射关系。在一些实施例中，指定表格的已填充列为预先指定的列或第一列。在一些实施例中，查询请求发送模块还配置为在指定表格中补全与已填充列的数据和各字段名称对应的数据之前，向服务器发送包含已填充列的数据和表格中的各字段名称的数据查询请求；请求结果接收模块还配置为接收服务器反馈的数据查询请求结果；其中，数据查询请求结果是服务器基于至少一个数据系统的数据进行查询得到的。在一些实施例中，与指定表格相关的特定控件的触发操作包括：在在线表格页面上触发浏览器的特定控件的操作；或者在特定控件中输入离线电子表格的标识并触发特定控件的操作。
本公开的表格数据处理方法可以根据已填充列的数据和字段名称，自动从多个不同的数据系统中查询相应的数据信息，之后输出到相应的客户端的相应单元格中，实现指定表格中的数据信息的智能整理，相比于通常的从各个系统单独下载数据之后进行整理，大大节省了数据整理的工作量。另外，由于在服务器中存储了字段名称映射列表，而字段名称映射列表包括不同数据系统中的字段名称的映射关系，进而可以通过不同数据系统之间的字段名称的映射关系，通过一个数据系统中的字段名称查询其他数据系统中的字段名称，并且获取与该字段名称对应的数据信息。
此外，本公开还提供一种终端，包括：至少一个存储器和至少一个处理器；其中，所述存储器用于存储程序代码，所述处理器用于调用所述存储器所存储的程序代码以执行上述表格数据处理方法。
此外，本公开还提供一种计算机存储介质，该计算机存储介质存储有程序代码，程序代码用于执行上述表格数据处理方法。
以上，基于实施例和应用例说明了本公开的表格数据处理方法及装置。此外，本公开还提供一种终端及存储介质，以下说明这些终端和存储介质。
下面参考图7，其示出了适于用来实现本公开实施例的电子设备(例如终端设备或服务器)400的结构示意图。本公开实施例中的终端设备可以包括但不限于诸如移动电话、笔记本电脑、数字广播接收器、PDA(个人数字助理)、PAD(平板电脑)、PMP(便携式多媒体播放器)、车载终端(例如车载导航终端)等等的移动终端以及诸如数字TV、台式计算机等等的固定终端。图7示出的电子设备仅仅是一个示例，不应对本公开实施例的功能和使用范围带来任何限制。
如图7所示，电子设备400可以包括处理装置(例如中央处理器、图形处理器等)401，其可以根据存储在只读存储器(ROM)402中的程序或者从存储装置408加载到随机访问存储器(RAM)403中的程序而执行各种适当的动作和处理。在RAM403中，还存储有电子设备400操作所需的各种程序和数据。处理装置401、ROM 402以及RAM 403通过总线404彼此相连。输入/输出(I/O)接口405也连接至总线404。
通常，以下装置可以连接至I/O接口405：包括例如触摸屏、触摸板、键盘、鼠标、摄像头、麦克风、加速度计、陀螺仪等的输入装置406；包括例如液晶显示器(LCD)、扬声器、振动器等的输出装置407；包括例如磁带、硬盘等的存储装置408；以及通信装置409。通信装置409可以允许电子设备400与其他设备进行无线或有线通信以交换数据。虽然图7示出了具有各种装置的电子设备400，但是应理解的是，并不要求实施或具备所有示出的装置。可以替代地实施或具备更多或更少的装置。
特别地，根据本公开的实施例，上文参考流程图描述的过程可以被实现为计算机软件程序。例如，本公开的实施例包括一种计算机程序产品，其包括承载在计算机可读介质上的计算机程序，该计算机程序包含用于执行流程图所示的方法的程序代码。在这样的实施例中，该计算机程序可以通过通信装置409从网络上被下载和安装，或者从存储装置408被安装，或者从ROM 402被安装。在该计算机程序被处理装置401执行时，执行本公开实施例的方法中限定的上述功能。
需要说明的是，本公开上述的计算机可读介质可以是计算机可读信号介质或者计算机可读存储介质或者是上述两者的任意组合。计算机可读存储介质例如可以是——但不限于——电、磁、光、电磁、红外线、或半导 体的系统、装置或器件，或者任意以上的组合。计算机可读存储介质的更具体的例子可以包括但不限于：具有一个或多个导线的电连接、便携式计算机磁盘、硬盘、随机访问存储器(RAM)、只读存储器(ROM)、可擦式可编程只读存储器(EPROM或闪存)、光纤、便携式紧凑磁盘只读存储器(CD-ROM)、光存储器件、磁存储器件、或者上述的任意合适的组合。在本公开中，计算机可读存储介质可以是任何包含或存储程序的有形介质，该程序可以被指令执行系统、装置或者器件使用或者与其结合使用。而在本公开中，计算机可读信号介质可以包括在基带中或者作为载波一部分传播的数据信号，其中承载了计算机可读的程序代码。这种传播的数据信号可以采用多种形式，包括但不限于电磁信号、光信号或上述的任意合适的组合。计算机可读信号介质还可以是计算机可读存储介质以外的任何计算机可读介质，该计算机可读信号介质可以发送、传播或者传输用于由指令执行系统、装置或者器件使用或者与其结合使用的程序。计算机可读介质上包含的程序代码可以用任何适当的介质传输，包括但不限于：电线、光缆、RF(射频)等等，或者上述的任意合适的组合。
在一些实施方式中，客户端、服务器可以利用诸如HTTP(HyperText Transfer Protocol，超文本传输协议)之类的任何当前已知或未来研发的网络协议进行通信，并且可以与任意形式或介质的数字数据通信(例如，通信网络)互连。通信网络的示例包括局域网(“LAN”)，广域网(“WAN”)，网际网(例如，互联网)以及端对端网络(例如，ad hoc端对端网络)，以及任何当前已知或未来研发的网络。
上述计算机可读介质可以是上述电子设备中所包含的；也可以是单独存在，而未装配入该电子设备中。
上述计算机可读介质承载有一个或者多个程序，当上述一个或者多个程序被该电子设备执行时，使得该电子设备执行上述的本公开的方法。
可以以一种或多种程序设计语言或其组合来编写用于执行本公开的操作的计算机程序代码，上述程序设计语言包括面向对象的程序设计语言—诸如Java、Smalltalk、C++，还包括常规的过程式程序设计语言—诸如“C”语言或类似的程序设计语言。程序代码可以完全地在用户计算机上执行、部分地在用户计算机上执行、作为一个独立的软件包执行、部分在用户计 算机上部分在远程计算机上执行、或者完全在远程计算机或服务器上执行。在涉及远程计算机的情形中，远程计算机可以通过任意种类的网络——包括局域网(LAN)或广域网(WAN)—连接到用户计算机，或者，可以连接到外部计算机(例如利用因特网服务提供商来通过因特网连接)。
附图中的流程图和框图，图示了按照本公开各种实施例的系统、方法和计算机程序产品的可能实现的体系架构、功能和操作。在这点上，流程图或框图中的每个方框可以代表一个模块、程序段、或代码的一部分，该模块、程序段、或代码的一部分包含一个或多个用于实现规定的逻辑功能的可执行指令。也应当注意，在有些作为替换的实现中，方框中所标注的功能也可以以不同于附图中所标注的顺序发生。例如，两个接连地表示的方框实际上可以基本并行地执行，它们有时也可以按相反的顺序执行，这依所涉及的功能而定。也要注意的是，框图和/或流程图中的每个方框、以及框图和/或流程图中的方框的组合，可以用执行规定的功能或操作的专用的基于硬件的系统来实现，或者可以用专用硬件与计算机指令的组合来实现。
描述于本公开实施例中所涉及到的单元可以通过软件的方式实现，也可以通过硬件的方式来实现。其中，单元的名称在某种情况下并不构成对该单元本身的限定。
本文中以上描述的功能可以至少部分地由一个或多个硬件逻辑部件来执行。例如，非限制性地，可以使用的示范类型的硬件逻辑部件包括：现场可编程门阵列(FPGA)、专用集成电路(ASIC)、专用标准产品(ASSP)、片上系统(SOC)、复杂可编程逻辑设备(CPLD)等等。
在本公开的上下文中，机器可读介质可以是有形的介质，其可以包含或存储以供指令执行系统、装置或设备使用或与指令执行系统、装置或设备结合地使用的程序。机器可读介质可以是机器可读信号介质或机器可读储存介质。机器可读介质可以包括但不限于电子的、磁性的、光学的、电磁的、红外的、或半导体系统、装置或设备，或者上述内容的任何合适组合。机器可读存储介质的更具体示例会包括基于一个或多个线的电气连接、便携式计算机盘、硬盘、随机存取存储器(RAM)、只读存储器(ROM)、可擦除可编程只读存储器(EPROM或快闪存储器)、光纤、便捷式紧凑盘 只读存储器(CD-ROM)、光学储存设备、磁储存设备、或上述内容的任何合适组合。
根据本公开的一个或多个实施例，【示例1】提供了一种表格数据处理方法，其特征在于，所述表格数据处理方法包括：响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面；其中，所述字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称，且与所述指定表格中的已填充列所对应的字段名称具有关联关系；响应于所述字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到所述指定表格中；以及在所述指定表格中补全与已填充列的数据和各字段名称对应的数据；其中，所补全的数据是来自于所述至少一个数据系统中的数据。
根据本公开的一个或多个实施例，【示例2】提供了示例1所述的方法，其中，所述字段筛选界面上还包括插入起始列输入控件；所述将所选择的字段名称添加到所述指定表格中包括：将所选择的字段名称从所输入的插入起始列开始添加到所述指定表格中。
根据本公开的一个或多个实施例，【示例3】提供了示例1所述的方法，其中，所述字段筛选界面上还包括字段搜索控件；所述表格数据处理方法还包括：响应于所述字段搜索控件中输入的信息，展示与所述输入的信息相匹配的字段名称，其中所展示的字段名称是所述至少一个数据系统中存在的字段名称。
根据本公开的一个或多个实施例，【示例4】提供了示例1所述的方法，其中，所述表格数据处理方法还包括：响应于请求更新数据的操作，更新所述指定表格中的数据，并将有变化的数据区别显示。
根据本公开的一个或多个实施例，【示例5】提供了示例1所述的方法，其中，所述特定控件是浏览器的插件，所述表格数据处理方法由所述插件执行。
根据本公开的一个或多个实施例，【示例6】提供了示例5所述的方法，其中，在所述展示字段筛选界面的步骤之前，所述表格数据处理方法还包括：从所述指定表格获取已填充列所对应的字段名称，向服务器发送包含所获取的字段名称的查询请求；接收服务器反馈的字段名称查询请求结果；其中，所述字段名称查询请求结果是服务器根据预先存储的字段名称映射列表查询得到，所述字段名称映射列表中保存了所述至少一个系统中的各字段名称的映射关系。
根据本公开的一个或多个实施例，【示例7】提供了示例6所述的方法，其中，所述指定表格的已填充列为预先指定的列或第一列。
根据本公开的一个或多个实施例，【示例8】提供了示例5所述的方法，其中，在所述指定表格中补全与已填充列的数据和各字段名称对应的数据之前，所述表格数据处理方法还包括：向服务器发送包含所述已填充列的数据和表格中的各字段名称的数据查询请求；接收服务器反馈的数据查询请求结果；其中，所述数据查询请求结果是服务器基于所述至少一个数据系统的数据进行查询得到的。
根据本公开的一个或多个实施例，【示例9】提供了示例1所述的方法，其中，所述与指定表格相关的特定控件的触发操作包括：在在线表格页面上触发浏览器的特定控件的操作；或者在特定控件中输入离线电子表格的标识并触发所述特定控件的操作。
根据本公开的一个或多个实施例，【示例10】提供了一种表格数据处理装置，所述表格数据处理装置包括：字段筛选界面展示模块，配置为响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面；其中，所述字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称，且所述字段筛选界面中的各候选字段名称与所述指定表格中的已填充列所对应的字段名称具有关联关系；字段名称添加模块，配置为响应于所述字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到所述指定表格中；以及数据补全模块，配置为在所述指定表格中补全与已填充列的数据和各字段名称对应的数据；其中，所补全的数据是来自于所述至少一个数据系统中的数据。
根据本公开的一个或多个实施例，【示例11】提供了一种终端，包括：至少一个存储器和至少一个处理器；其中，所述至少一个存储器用于存储程序代码，所述至少一个处理器用于调用所述至少一个存储器所存储的程序代码执行上述示例1-9中任一项所述的方法。
根据本公开的一个或多个实施例，【示例12】提供了一种存储介质，所述存储介质用于存储程序代码，所述程序代码用于执行示例1-9中任一项所述的方法。
以上描述仅为本公开的较佳实施例以及对所运用技术原理的说明。本领域技术人员应当理解，本公开中所涉及的公开范围，并不限于上述技术特征的特定组合而成的技术方案，同时也应涵盖在不脱离上述公开构思的 情况下，由上述技术特征或其等同特征进行任意组合而形成的其它技术方案。例如上述特征与本公开中公开的(但不限于)具有类似功能的技术特征进行互相替换而形成的技术方案。
此外，虽然采用特定次序描绘了各操作，但是这不应当理解为要求这些操作以所示出的特定次序或以顺序次序执行来执行。在一定环境下，多任务和并行处理可能是有利的。同样地，虽然在上面论述中包含了若干具体实现细节，但是这些不应当被解释为对本公开的范围的限制。在单独的实施例的上下文中描述的某些特征还可以组合地实现在单个实施例中。相反地，在单个实施例的上下文中描述的各种特征也可以单独地或以任何合适的子组合的方式实现在多个实施例中。
尽管已经采用特定于结构特征和/或方法逻辑动作的语言描述了本主题，但是应当理解所附权利要求书中所限定的主题未必局限于上面描述的特定特征或动作。相反，上面所描述的特定特征和动作仅仅是实现权利要求书的示例形式。

Claims (12)

  1. 一种表格数据处理方法，其特征在于，所述表格数据处理方法包括：
    响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面；其中，所述字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称；
    响应于所述字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到所述指定表格中；以及
    在所述指定表格中补全与已填充列的数据和各字段名称对应的数据；其中，所补全的数据是来自于所述至少一个数据系统中的数据。
  2. 根据权利要求1所述的方法，其特征在于，所述字段筛选界面上还包括插入起始列输入控件；
    所述将所选择的字段名称添加到所述指定表格中包括：将所选择的字段名称从所输入的插入起始列开始添加到所述指定表格中。
  3. 根据权利要求1所述的方法，其特征在于，所述字段筛选界面上还包括字段搜索控件；
    所述表格数据处理方法还包括：响应于所述字段搜索控件中输入的信息，展示与所述输入的信息相匹配的字段名称，其中所展示的字段名称是所述至少一个数据系统中存在的字段名称。
  4. 根据权利要求1所述的方法，其特征在于，所述表格数据处理方法还包括：
    响应于请求更新数据的操作，更新所述指定表格中的数据，并将有变化的数据区别显示。
  5. 根据权利要求1所述的方法，其中，所述特定控件是浏览器的插件，所述表格数据处理方法由所述插件执行。
  6. 根据权利要求5所述的方法，其特征在于，在所述展示字段筛选界面的步骤之前，所述表格数据处理方法还包括：
    从所述指定表格获取已填充列所对应的字段名称，向服务器发送包含所获取的字段名称的查询请求；
    接收服务器反馈的字段名称查询请求结果；其中，所述字段名称查询请求结果是服务器根据预先存储的字段名称映射列表查询得到，所述字段名称映射列表中保存了所述至少一个系统中的各字段名称的映射关系。
  7. 根据权利要求6所述的方法，其中，
    所述指定表格的已填充列为预先指定的列或第一列。
  8. 根据权利要求5所述的方法，其特征在于，在所述指定表格中补全与已填充列的数据和各字段名称对应的数据之前，所述表格数据处理方法还包括：
    向服务器发送包含所述已填充列的数据和表格中的各字段名称的数据查询请求；
    接收服务器反馈的数据查询请求结果；其中，所述数据查询请求结果是服务器基于所述至少一个数据系统的数据进行查询得到的。
  9. 根据权利要求1所述的方法，其特征在于，所述与指定表格相关的特定控件的触发操作包括：
    在在线表格页面上触发浏览器的特定控件的操作；或者
    在特定控件中输入离线电子表格的标识并触发所述特定控件的操作。
  10. 一种表格数据处理装置，其特征在于，所述表格数据处理装置包括：
    字段筛选界面展示模块，配置为响应于与指定表格相关的特定控件的触发操作，展示字段筛选界面；其中，所述字段筛选界面中的各候选字段名称是预设的至少一个数据系统中所存在的字段名称，且所述字段筛选界面中的各候选字段名称与所述指定表格中的已填充列所对应的字段名称具有关联关系；
    字段名称添加模块，配置为响应于所述字段筛选界面上的字段名称选择操作，将所选择的字段名称添加到所述指定表格中；以及
    数据补全模块，配置为在所述指定表格中补全与已填充列的数据和各字段名称对应的数据；其中，所补全的数据是来自于所述至少一个数据系统中的数据。
  11. 一种电子设备，包括：
    至少一个存储器和至少一个处理器；
    其中，所述至少一个存储器用于存储程序代码，所述至少一个处理器用于调用所述至少一个存储器所存储的程序代码执行权利要求1至9中任一项所述的表格数据处理方法。
  12. 一种计算机可读存储介质，所述计算机可读存储介质用于存储程序代码，所述程序代码用于在被处理器运行时执行权利要求1至9中任一项所述的表格数据处理方法。
PCT/CN2022/107357 2021-07-23 2022-07-22 表格数据处理方法、装置、终端和存储介质 WO2023001281A1 (zh)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US18/523,862 US20240104298A1 (en) 2021-07-23 2023-11-29 Method and apparatus for tabular data processing, terminal, and storage medium

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202110839653.9 2021-07-23
CN202110839653.9A CN115034175A (zh) 2021-07-23 2021-07-23 表格数据处理方法、装置、终端和存储介质

Related Child Applications (1)

Application Number Title Priority Date Filing Date
US18/523,862 Continuation US20240104298A1 (en) 2021-07-23 2023-11-29 Method and apparatus for tabular data processing, terminal, and storage medium

Publications (1)

Publication Number Publication Date
WO2023001281A1 true WO2023001281A1 (zh) 2023-01-26

Family

ID=83117795

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2022/107357 WO2023001281A1 (zh) 2021-07-23 2022-07-22 表格数据处理方法、装置、终端和存储介质

Country Status (3)

Country Link
US (1) US20240104298A1 (zh)
CN (1) CN115034175A (zh)
WO (1) WO2023001281A1 (zh)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117574867A (zh) * 2023-12-08 2024-02-20 北京天圣华信息技术有限责任公司 统计表格的生成方法、装置、设备及存储介质

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109815276A (zh) * 2018-12-14 2019-05-28 中国平安财产保险股份有限公司 保单提取数据的方法、装置、计算机设备和存储介质
CN111597238A (zh) * 2020-06-10 2020-08-28 北京明朝万达科技股份有限公司 一种基于数据库的动态展示表格数据的方法及装置
CN111708801A (zh) * 2020-05-29 2020-09-25 北京金山云网络技术有限公司 报表生成方法、装置及电子设备
CN111783410A (zh) * 2020-07-22 2020-10-16 平安国际智慧城市科技股份有限公司 表格字段筛选方法、装置、计算机设备及存储介质
CN112506493A (zh) * 2020-10-30 2021-03-16 福建亿能达信息技术股份有限公司 一种基于vue的表格配置方法、装置、设备和介质

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9275031B2 (en) * 2009-10-09 2016-03-01 Microsoft Technology Licensing, Llc Data analysis expressions
US10083206B2 (en) * 2015-11-19 2018-09-25 Business Objects Software Limited Visualization of combined table data
US11341321B2 (en) * 2017-10-20 2022-05-24 Uxstorm, Llc UI enabling mapping engine system and process interconnecting spreadsheets and database-driven applications

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109815276A (zh) * 2018-12-14 2019-05-28 中国平安财产保险股份有限公司 保单提取数据的方法、装置、计算机设备和存储介质
CN111708801A (zh) * 2020-05-29 2020-09-25 北京金山云网络技术有限公司 报表生成方法、装置及电子设备
CN111597238A (zh) * 2020-06-10 2020-08-28 北京明朝万达科技股份有限公司 一种基于数据库的动态展示表格数据的方法及装置
CN111783410A (zh) * 2020-07-22 2020-10-16 平安国际智慧城市科技股份有限公司 表格字段筛选方法、装置、计算机设备及存储介质
CN112506493A (zh) * 2020-10-30 2021-03-16 福建亿能达信息技术股份有限公司 一种基于vue的表格配置方法、装置、设备和介质

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117574867A (zh) * 2023-12-08 2024-02-20 北京天圣华信息技术有限责任公司 统计表格的生成方法、装置、设备及存储介质

Also Published As

Publication number Publication date
US20240104298A1 (en) 2024-03-28
CN115034175A (zh) 2022-09-09

Similar Documents

Publication Publication Date Title
CN111581563B (zh) 页面响应方法、装置、存储介质和电子设备
WO2023056934A1 (zh) 数据处理方法、装置和电子设备
CN110909521A (zh) 在线文档信息的同步处理方法、装置及电子设备
US20240104298A1 (en) Method and apparatus for tabular data processing, terminal, and storage medium
US20230385080A1 (en) Method and apparatus for presenting information on lock screen interface, terminal, and storage medium
CN113391860B (zh) 服务请求处理方法、装置、电子设备及计算机存储介质
CN111241137B (zh) 数据处理方法、装置、电子设备及存储介质
WO2023221795A1 (zh) 生成视图的方法、装置、电子设备及存储介质
CN112988311A (zh) 一种基于web服务器的线上实验方法
WO2023124910A1 (zh) 数据处理方法、装置、电子设备和存储介质
WO2023116469A1 (zh) 信息处理方法、装置、终端和存储介质
WO2023131263A1 (zh) 一种群成员添加方法、装置、设备及介质
WO2023056841A1 (zh) 一种数据服务方法、装置及相关产品
WO2022242441A1 (zh) 电子表格导入方法、装置、设备及介质
WO2023065937A1 (zh) 数据处理方法、装置、可读介质及电子设备
CN115344688A (zh) 业务数据展示方法、装置、电子设备和计算机可读介质
CN112507676B (zh) 能源报表生成方法、装置、电子设备和计算机可读介质
CN112257039B (zh) 身份属性添加方法、装置和电子设备
CN112100211B (zh) 数据存储方法、装置、电子设备和计算机可读介质
CN113468342A (zh) 基于知识图谱的数据模型构建方法、装置、设备和介质
CN111143355A (zh) 数据处理方法及装置
CN111787043A (zh) 数据请求方法和装置
JP2024521859A (ja) フォームデータ処理方法、装置、端末および記憶媒体
CN111857879B (zh) 数据处理方法、装置、电子设备和计算机可读介质
WO2023093489A1 (zh) 页面视图生成方法、装置、电子设备及存储介质

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 22845444

Country of ref document: EP

Kind code of ref document: A1

WWE Wipo information: entry into national phase

Ref document number: 2023573427

Country of ref document: JP

NENP Non-entry into the national phase

Ref country code: DE