Parameter-Matched Table Filling for Accurate Data Transfer
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for transferring data between tables rely on manual searching and copying, leading to low efficiency and high error rates due to repetitive operations.
Innovation Solution
A method and apparatus for automatically determining a target copy range in a first table and corresponding paste cells in a second table based on associated parameters, using text recognition to enhance data transfer efficiency and reduce manual errors.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If manual searching and copying is used to transfer data between tables, then data transfer can be performed, but efficiency is low and error rate is high due to repetitive operations
Solution Approach 1:
The patent replaces manual mechanical operations (mouse clicking, copying, pasting) with an automated system that uses text recognition and parameter matching to identify and transfer data between tables. The system automatically determines source and destination cells based on associated parameters without requiring manual selection for each cell.
Solution Approach 2:
The system enables self-service data transfer by automatically identifying matching cells between tables through parameter association. Once the user initiates the transfer operation, the system autonomously completes the entire process of selecting source cells, identifying destination cells, and performing the data transfer without requiring continuous manual intervention.
2Loss of time
If manual copy and paste operations are performed repeatedly for each piece of data, then data can be transferred between tables, but the process is time-consuming and labor-intensive
Solution Approach 1:
The patent merges multiple discrete manual operations (selecting each cell, searching for the destination, copying, pasting) into a single unified automated operation. The system combines parameter matching, cell identification, and data transfer into one integrated process that executes simultaneously for all matching cells.
Solution Approach 2:
The system performs preliminary actions by pre-establishing parameter associations between tables before the actual data transfer occurs. The parameter matching logic and destination cell identification are prepared in advance, so when the transfer operation is initiated, the system can immediately execute without performing these preparatory steps for each individual cell.
3Adaptability or versatility
If manual data copying is used, then flexibility to handle different data formats is maintained, but the process becomes complex and error-prone
Solution Approach 1:
The patent uses parameter changes as the basis for matching and transferring data between tables. By identifying associated parameters (such as common identifiers, names, or keys) that exist in both tables, the system can automatically determine which cells correspond to each other and transfer data accordingly, handling different data formats through parameter-based matching rather than manual format conversion.
Data Source
Figure 1~2
Figure 3
Figure 4
AI summary
Disclosed are a method and an apparatus for filling data in a table, an electronic device and a storage medium. The method for filling data in a table includes: determining a target copy range in a first table in response to a copy operation on the first table; determining a paste cell corresponding to each copy cell in the target copy range in a second table, in which the copy cell and the corresponding paste cell have at least one associated target parameter; and filling cell data in the copy cell into the corresponding paste cell.