CN110516220B - Report data input method, system and related equipment - Google Patents
Report data input method, system and related equipment Download PDFInfo
- Publication number
- CN110516220B CN110516220B CN201910804191.XA CN201910804191A CN110516220B CN 110516220 B CN110516220 B CN 110516220B CN 201910804191 A CN201910804191 A CN 201910804191A CN 110516220 B CN110516220 B CN 110516220B
- Authority
- CN
- China
- Prior art keywords
- column
- filled
- data
- character string
- cells
- 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
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000003491 array Methods 0.000 claims description 44
- 238000013479 data entry Methods 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012905 input function Methods 0.000 abstract description 6
- 230000001960 triggered effect Effects 0.000 abstract description 6
- 230000010076 replication Effects 0.000 abstract description 5
- 230000008569 process Effects 0.000 description 11
- 238000010586 diagram Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 8
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000008676 import Effects 0.000 description 3
- 230000002159 abnormal effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000000047 product Substances 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
Abstract
The embodiment of the invention discloses a report data input method, a report data input system and related equipment, which are used for improving report data input efficiency. In the embodiment of the invention, after the report data input function is triggered, the report data input system can read the character string cache data generated for the replication operation of the first area in the existing report, analyze the character string cache data, sequentially generate the cache array corresponding to each column of cells in the first area, finally sequentially finish the data filling operation of each column of cells to be filled by taking the cell with the minimum row and column coordinates in the area to be filled as a starting point, and the editing software types of the existing report and the target report are different, thereby realizing batch input of the cell data in the reports of different types without inputting the cells one by one and improving the report data input efficiency.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a report data entry method, system, and related devices.
Background
The main characteristics of the report form on the computer are data dynamic and format diversified, and complete separation of report form data and report form format is realized, and the user can only modify the data or only modify the format. The common report is classified into an EXCEL table, a Jiuqiu report, a Jinzhui EAS report, and the like.
In the existing method, different types of report data input modes are often manually input item by item or copied and pasted, for example, when the offset entry of the combined report is edited, if the content in the catalog corresponding to the function key or the drop-down frame in the offset entry is required to be manually input, the data can only be input in one cell at a time. If the report items are more, a great deal of manpower and time are required to input the item data, and the efficiency is low.
Disclosure of Invention
The embodiment of the invention provides a report data input method, a report data input system and related equipment, which are used for improving report data input efficiency.
An embodiment of the present invention provides a report data entry method, which is characterized in that the method includes:
reading character string cache data generated by the cache region copying operation, wherein the character string cache data is generated by copying character strings in each cell of a selected first region in an existing report according to a preset storage format;
analyzing the character string cache data according to the preset storage format, taking the character strings belonging to the same column in the first area as a group of cache arrays, and sequentially generating cache arrays corresponding to each column of cells in the first area, wherein the serial numbers of each group of cache arrays are increased along with the increase of the corresponding column number in the first area;
Acquiring column coordinates of each column of cells to be filled in a target report form to be filled area and editing control types corresponding to each column of cells to be filled, wherein the existing report forms are different from editing software types of the target report forms;
and sequentially completing data filling operation of each column of cells to be filled by taking the cell with the minimum row and column coordinates in the region to be filled as a starting point, wherein the data filling operation comprises the following steps: and starting from the cell to be filled with the minimum column sequence number, sequentially reading a group of character string data in the cache array as target data of the cell to be filled of the current column according to the sequence number increment of each group of cache array, and filling the target data into the cell to be filled of the current column according to a data format matched with the editing control type corresponding to the cell to be filled of the current column.
Optionally, as a possible implementation manner, in an embodiment of the present invention, when the existing report is a spreadsheet and the cache area is a sticky board, the parsing the string cache data according to the preset storage format includes:
traversing the character string cache data, and identifying character strings belonging to the same column in the existing report form in the character string cache data according to the cell ending character and the line changing character after each line of cells are ended.
Optionally, as a possible implementation manner, the report data input method in the embodiment of the present invention further includes:
identifying the number of the corresponding rows of the first area in the existing report according to the number of the line changing symbols;
and if the number of the corresponding rows of the first area in the existing report is greater than the number of the rows of the to-be-filled area cells, adapting to increase the number of the rows of the to-be-filled area cells.
Optionally, as a possible implementation manner, in an embodiment of the present invention, the column coordinates of each column of cells to be filled in the target report to be filled area include:
receiving a frame selection instruction, wherein the frame selection instruction is used for indicating a region to be filled in a selected target report, and the row coordinates of cells in the region to be filled are continuous;
and after eliminating the column coordinates corresponding to the locked one or more columns of cells in the region to be filled, taking the column coordinates corresponding to the remaining cells in the region to be filled as the column coordinates of the cells to be filled in each column.
Optionally, as a possible implementation manner, in an embodiment of the present invention, before the step of using the strings belonging to the same column in the first area as a set of cache arrays, the method further includes:
Judging whether the read character string belongs to a preset data type, if not, discarding the currently read character string;
and/or judging whether the read character string is matched with any preset character string in the preset data set, and if the matched preset character string does not exist, discarding the currently read character string.
The embodiment of the application also provides a report data input system, which is characterized by comprising:
the reading unit is used for reading character string cache data generated by the cache region copying operation, wherein the character string cache data is generated by copying character strings in each cell of the selected first region in the existing report according to a preset storage format;
the analyzing unit is used for analyzing the character string cache data according to the preset storage format, taking the character strings belonging to the same column in the first area as a group of cache arrays, and sequentially generating the cache arrays corresponding to the unit cells of each column in the first area, wherein the serial numbers of the cache arrays of each group are increased along with the increase of the corresponding column number in the first area;
the system comprises an acquisition unit, a storage unit and a display unit, wherein the acquisition unit is used for acquiring column coordinates of all columns of cells to be filled in a target report to be filled area and editing control types corresponding to all columns of cells to be filled, and the existing report is different from the editing software types of the target report;
The filling unit is used for sequentially completing data filling operation of each column of cells to be filled by taking the cell with the minimum row and column coordinates in the region to be filled as a starting point, and the data filling operation comprises the following steps: and starting from the cell to be filled with the minimum column sequence number, sequentially reading a group of character string data in the cache array as target data of the cell to be filled of the current column according to the sequence number increment of each group of cache array, and filling the target data into the cell to be filled of the current column according to a data format matched with the editing control type corresponding to the cell to be filled of the current column.
Optionally, as a possible implementation manner, in an embodiment of the present invention, when the existing report is a spreadsheet and the cache area is a sticky board, the parsing unit includes:
the traversing module is used for traversing the character string cache data, identifying character strings belonging to the same column in the existing report form in the character string cache data according to the end characters of the cells and the line-changing symbols after each row of cells are ended, and sequentially generating cache arrays corresponding to each column of cells in the first area, wherein the sequence numbers of the cache arrays of each group are increased along with the increase of the corresponding column numbers in the first area.
Optionally, as a possible implementation manner, the report data input system in the embodiment of the present invention further includes:
the identification unit is used for identifying the number of the corresponding rows of the first area in the existing report according to the number of the line changing symbols;
and the adjusting unit is used for adapting to increase the number of the lines of the cells of the area to be filled if the number of the lines corresponding to the first area in the existing report is larger than the number of the lines of the cells of the area to be filled.
Optionally, as a possible implementation manner, the acquiring unit in the embodiment of the present invention includes:
the receiving module is used for receiving a frame selection instruction, wherein the frame selection instruction is used for indicating a region to be filled in a selected target report, and the row coordinates of the cells in the region to be filled are continuous;
and the rejecting module is used for rejecting the column coordinates corresponding to the locked one or more columns of cells in the region to be filled, and then taking the column coordinates corresponding to the rest cells in the region to be filled as the column coordinates of the cells to be filled in each column.
Optionally, as a possible implementation manner, the report data input system in the embodiment of the present invention further includes:
the first judging unit is used for judging whether the read character string belongs to a preset data type or not, and if the read character string does not belong to the preset data type, discarding the currently read character string;
And the second judging unit is used for judging whether the read character string is matched with any preset character string in the preset data set, and discarding the currently read character string if the matched preset character string does not exist.
A third aspect of the embodiments of the present application provides a computer apparatus, where the computer apparatus includes a processor, where the processor is configured to implement the steps of the report data entry method according to any one of the first aspect and the first aspect when executing a computer program stored in a memory.
A fourth aspect of the present application provides a computer-readable storage medium having stored thereon a computer program, characterized in that: the computer program when executed by a processor performs the steps of the report data entry method of any of the first aspect and the first aspect.
From the above technical solutions, the embodiment of the present invention has the following advantages:
in the embodiment of the invention, after the report data input function is triggered, the report data input system can read the character string cache data generated for the replication operation of the first area in the existing report, analyze the character string cache data, sequentially generate the cache array corresponding to each column of cells in the first area, finally sequentially finish the data filling operation of each column of cells to be filled by taking the cell with the minimum row and column coordinates in the area to be filled as a starting point, and the editing software types of the existing report and the target report are different, thereby realizing batch input of the cell data in the reports of different types without inputting the cells one by one and improving the report data input efficiency.
Drawings
FIG. 1 is a diagram of one embodiment of a report data entry method in accordance with an embodiment of the present invention;
fig. 2 is a schematic diagram of a scenario in which a copy operation generates a predetermined format of character string cache data in an Excel table in an embodiment of the present invention;
FIG. 3 is a schematic diagram of a flow chart of parsing the data of the character string cache according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a chart data pasting process in an embodiment of the present invention;
FIG. 5 is a schematic diagram of an area to be entered in an EAS system report according to an embodiment of the present invention;
FIG. 6 is a diagram of a selection area of an Excel table in an embodiment of the present invention;
FIG. 7 is a diagram of one embodiment of a report data entry system in accordance with embodiments of the present invention;
FIG. 8 is a diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a report data input method, a report data input system and related equipment, which are used for improving report data input efficiency.
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
The terms first, second, third, fourth and the like in the description and in the claims and in the above drawings are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments described herein may be implemented in other sequences than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
For ease of understanding, a specific flow in the embodiment of the present invention is described below with reference to fig. 1, and an embodiment of a report data entry method in the embodiment of the present invention may include:
101. reading character string cache data generated by the cache region copying operation;
after triggering the report data input function, the user can select the existing report, select the first area to be copied in the existing report, and the computer operating system or the report data input system can copy the filling data in each cell of the first area and generate the character string cache data corresponding to the copy operation according to the preset storage format. After the string cache data is generated, the report data entry system may read the string cache data in the sticker. Preferably, the character string cache data generated by the last copy operation of the cache area is read.
102. Analyzing the character string cache data according to a preset storage format, taking the character strings belonging to the same column in the first area as a group of cache arrays, and sequentially generating the cache arrays corresponding to the unit cells of each column in the first area;
in the embodiment of the invention, the report data input system can analyze the character string cache data according to the preset storage format, takes the character strings belonging to the same column in the first area as a group of cache arrays, and sequentially generates the cache arrays corresponding to the unit cells of each column in the first area, wherein the serial numbers of the cache arrays of each group are increased along with the increase of the corresponding column numbers in the first area.
For example, referring to fig. 2, if the existing report selected by the user is an Excel table, and the cache area is a paste board corresponding to the operating system, when the user selects a plurality of rows and columns of cells in the Excel table, a cell ending character "\t" follows a string of each cell, and a line-by-line character "\n" follows a string of each row of cells. In the process of analyzing the character string cache data, the character string cache data can be traversed, and character strings belonging to the same column in the existing report form are identified according to the ending character of the cell "\t" and the line feed character "\n" after each line of cells are ended.
Specifically, in the process of traversing the character string, according to the judgment of \t and \n, the number of columns is increased by 1 when each \t is encountered, until each \n is encountered, then 1 is added, and the process is finished, at this moment, the count value of \t is the number of columns, and the number of rows is directly judged according to the number of \n, so that the character strings belonging to the same column in the existing report are identified in the character string cache data.
It can be understood that in practical application, the preset storage format corresponding to the character strings in the cells can be determined according to the software type of the existing report, and the data can be cached according to the analysis character strings adaptively of the preset storage format, and the specific preset storage format is not limited herein. For example, when the existing report is an Excel table and the cache area is a paste board, the parsing the character string cache data according to the preset storage format includes: traversing the character string cache data, and identifying the character strings belonging to the same column in the existing report in the character string cache data according to cell ending characters (for example, the cell ending characters in Excel are "\t") and line changing characters after each line of cells are ended (for example, the line changing characters in Excel are "\n").
103. Acquiring column coordinates of each column of cells to be filled in a target report to be filled area and editing control types corresponding to each column of cells to be filled;
According to the embodiment of the invention, the data is filled in the unit of the columns, and the report data input system can acquire the column coordinates of the cells to be filled in each column in the target report to-be-filled area and the row and column coordinates of the cells with the minimum row and column coordinates in the to-be-filled area according to the operation of a user. For example, the report data entry system may operate the selected region to be filled of the target report and identify column coordinates of each column of cells to be filled according to the user's frame selection. The report data input system can receive a frame selection instruction, wherein the frame selection instruction is used for indicating a region to be filled in a target report to be selected, and the coordinates of cell lines in the region to be filled are continuous; and after eliminating the column coordinates corresponding to the locked one or more columns of cells in the region to be filled, taking the column coordinates corresponding to the rest cells in the region to be filled as the column coordinates of the cells to be filled in each column. The report data input system may further receive, in the setting input box, column coordinates of each column of cells to be filled in the target report to be filled area input by the user, and a specific obtaining manner is not limited herein. It should be noted that, preferably, in the embodiment of the present invention, the existing report is different from the type of the editing software of the target report, for example, the existing report is a table edited by Excel software, and the target report may be a report edited by a golden butterfly EAS system, and the specific type is not limited herein.
In addition, each column of the report may correspond to different types of editing controls, such as an F7 control, a drop-down box control, a text box control and other embedded controls in the golden butterfly EAS system, and different editing controls correspond to different data formats. For this purpose, the editing control types corresponding to the cells to be filled in each column are also required to be acquired. In the embodiment of the invention, the mapping relation between each column of coordinates and the editing control can be maintained in advance, and after the column of coordinates are acquired, the mark control type of each column of cells can be acquired according to the mapping relation, or the mark control type of each column of cells can be directly read from the attribute information of the cell object, and the specific acquisition mode is not limited here.
104. And sequentially completing data filling operation of the cells to be filled in each column by taking the cell with the minimum row and column coordinates in the region to be filled as a starting point.
The report data input system takes a cell with the minimum row and column coordinates in the region to be filled as a starting point, and sequentially completes data filling operation of each row of cells to be filled, wherein the data filling operation comprises the following steps: and starting from the cell to be filled with the minimum column sequence number, sequentially reading each row of character string data in a group of cache arrays according to the sequence number increment of each group of cache arrays to serve as target data of the cell to be filled in the current column, and filling the target data into the cell to be filled in the current column according to a data format matched with the editing control type corresponding to the cell to be filled in the current column.
In the embodiment of the invention, after the report data input function is triggered, the report data input system can read the character string cache data generated for the replication operation of the first area in the existing report, analyze the character string cache data, sequentially generate the cache array corresponding to each column of cells in the first area, finally sequentially finish the data filling operation of each column of cells to be filled by taking the cell with the minimum row and column coordinates in the area to be filled as a starting point, and the editing software types of the existing report and the target report are different, thereby realizing batch input of the cell data in the reports of different types without inputting the cells one by one and improving the report data input efficiency.
It should be understood that, in various embodiments of the present invention, the sequence number of each step is not meant to indicate the order of execution, and the order of execution of each step should be determined by its functions and internal logic, and should not be construed as limiting the implementation process of the embodiments of the present invention. For example, step 103 may be performed before step 101.
Optionally, as a possible implementation manner, on the basis of the embodiment shown in fig. 1, in practical application, more cell lines may need to be recorded from an existing report, so that in order to facilitate the frame selection operation of a user in a target report, only a small number of lines in an area to be filled need to be selected by the user in a frame, and the report data recording system can automatically supplement the line number of the area to be filled. Specifically, when the existing report is an electronic form, for example, an Excel form, and the cache area is a paste board, in the embodiment of the present invention, the report data input system may further identify the number of rows corresponding to the first area in the existing report according to the number of line change symbols "\n"; and if the number of the corresponding rows of the first area in the existing report is greater than the number of the rows of the cells of the area to be filled, adapting to increase the number of the rows of the cells of the area to be filled.
Alternatively, as a possible implementation manner, in practical application, in order to improve the data entry efficiency, invalid data that does not conform to the reading rule may be discarded in the data reading process based on the embodiment shown in fig. 1. Specifically, before the character strings belonging to the same column in the first area are used as a group of cache arrays, the report data input system can judge whether the read character strings belong to a preset data type, and if the read character strings do not belong to the preset data type, the current read character strings are discarded; and/or judging whether the read character string is matched with any preset character string in the preset data set, and if the matched preset character string does not exist, discarding the currently read character string.
Illustratively, taking the report in an EAS system as an example, the EAS system has the following types of cells: a. specifying the type of data entered: such as a text class, a numeric class; b. embedded control: f7, drop down box, specific data sets are bound in such controls, that is, their data sets are fixed. The specific judging method for judging whether the character string accords with the reading rule is as follows: a. the text type is directly filled in; b. the value is used in try, if abnormal, the value is not of the value type, and an array is not filled; and F7, a drop-down frame, wherein when the inquiry is triggered for the first time, the control-bound data set is stored in the system cache. Judging whether the character string is in the data set memory, if yes, filling the array, and if no, not filling.
For easy understanding, the method for inputting data in the report table in the embodiment of the invention will be described below in connection with a specific implementation process of inputting data in an Excel table into a golden butterfly EAS system report table.
After triggering the report data input function, the user selects each cell of a certain area in the Excel table to copy, character string cache data generated by copy operation is stored in a system pasting board, and the report data input system can read and analyze the data in the pasting board, and specifically comprises the following steps:
1. reading a corresponding interface for directly calling java.aawt.toolkit to obtain a character string in the system sticker;
2. the character strings obtained by the copying operation in the Excel table stored in the paste board are read and analyzed, and a specific analysis flow chart is shown in fig. 3, wherein the character strings str in the paste board are sequentially numbered str [0], str [1] and str [2] … str [ i ], the character strings are sequentially read from i=0 until the read string [ i ] is not existed, whether the read character strings meet preset conditions or not is recognized, and the character strings meeting the preset conditions are stored in an array. Wherein "\t" in the character string after Excel pasting represents the end of one cell, "\n" represents the end of one row, and according to the standard, the character string is divided, and the data of the appointed column is read. Judging whether the character string meets the preset condition, the EAS system has the following types of cells: a. specifying the type of data entered: such as a text class, a numeric class; b. embedded control: f7, drop down box, specific data sets are bound in such controls, that is, their data sets are fixed. The specific judging method for judging whether the character string accords with the reading rule is as follows: a. the text type is directly filled in; b. the value is used in try, if abnormal, the value is not of the value type, and an array is not filled; and F7, a drop-down frame, wherein when the inquiry is triggered for the first time, the control-bound data set is stored in the system cache. Judging whether the character string is in the data set memory, if yes, filling the array, and if no, not filling the array.
Before data is pasted, the relation between the pasting line number and the entry line number is judged, and if the existing entry line is smaller than the pasting line number, the corresponding entry line is increased. Paste as overlay import: if the existing entry line is greater than or equal to the entry line to be pasted, but the existing data is covered with the import instead of the insertion import, since the entry column is a fixed attribute, the existence of the pasting column is greater than the entry column, and the redundant data will not be pasted into the entry column.
In the pasting process, the number is taken according to the column: according to the starting column in the entry and the column number in the paste board, which columns need to be pasted and need to be skipped, a specific flow chart is shown in fig. 4. If there is a locked area in the EAS system report (as shown in fig. 6), such as "item name", the column may not be edited as a locked area, so the column needs to be skipped when pasting. And finally triggering corresponding filling operation according to different editing control types (F7, drop-down boxes, numerical values and texts) in different columns.
The specific process for judging whether the col column needs to be pasted is as follows: setting the starting coordinate of a report in an EAS system as (Xstart, ystart), selecting the column number a by Excel, and setting the abscissa of unfilled columns as Xignore, if Xstart is less than or equal to Xignore < (xstart+a), filling xstart+i (0 is less than or equal to i < a), wherein Xignore is less than or equal to (xstart+i) < (xstart+a), and filling uniformly and backwardly by one column at the moment, namely filling xstart+i+1 column. For example, as shown in fig. 6, in the example, a 4-column cell is framed for replication, in the EAS entry, starting with the selected minimum coordinate, assuming that the starting coordinates (3, 3) are as shown in fig. 6, the lock area is the 4 th column, i.e., the starting abscissa Xstart is 3 at this time, the unfilled "project name" column abscissa Xignore is 4, the filled column number a is 4, and the filled final column abscissa (xstart+a-1) is 7. According to the above rule, when the column 4 is filled, since two conditions of Xstart < = Xignore < = (xstart+a) and Xignore < = (xstart+i) < (xstart+a) are satisfied, the same is true for columns 5, 6, and 7 in the system.
Referring to fig. 7, an embodiment of the present application further provides a report data entry system, which is characterized in that the report data entry system includes:
the reading unit 701 is configured to read character string cache data generated by a cache region copying operation, where the character string cache data is generated by copying character strings in each cell of the selected first region in the existing report according to a preset storage format;
the parsing unit 702 is configured to parse the string cache data according to a preset storage format, and sequentially generate a cache array corresponding to each column of the unit cells in the first area, where the sequence number of each cache array increases with the increase of the corresponding column number in the first area, with the string belonging to the same column in the first area as a group of cache arrays;
the acquiring unit 703 is configured to acquire column coordinates of each column of cells to be filled in the target report to be filled area and an edit control type corresponding to each column of cells to be filled, where the existing report is different from the edit software type of the target report;
a filling unit 704, configured to sequentially complete a data filling operation of each column of cells to be filled with data, with a cell with a minimum row and column coordinate in the area to be filled as a starting point, where the data filling operation includes: and starting from the cell to be filled with the minimum column sequence number, sequentially reading each row of character string data in a group of cache arrays according to the sequence number increment of each group of cache arrays to serve as target data of the cell to be filled in the current column, and filling the target data into the cell to be filled in the current column according to a data format matched with the editing control type corresponding to the cell to be filled in the current column.
In the embodiment of the invention, after the report data input function is triggered, the report data input system can read the character string cache data generated for the replication operation of the first area in the existing report, analyze the character string cache data, sequentially generate the cache array corresponding to each column of cells in the first area, finally sequentially finish the data filling operation of each column of cells to be filled by taking the cell with the minimum row and column coordinates in the area to be filled as a starting point, realize batch input of the cell data in the report without inputting the cells one by one, and improve the report data input efficiency.
Optionally, as a possible implementation manner, in the embodiment of the present invention, when the existing report is a spreadsheet and the cache area is a sticky board, the parsing unit includes:
the traversing module 7031 is configured to traverse the string cache data, identify strings belonging to a same column in the existing report in the string cache data according to the end character of the cell and the line feed symbol after the end of each row of the cell, and sequentially generate cache arrays corresponding to each column of the cell in the first area, where the sequence number of each cache array increases with the increase of the corresponding column number in the first area.
Optionally, as a possible implementation manner, the report data input system in the embodiment of the present invention further includes:
an identifying unit 705, configured to identify, according to the number of line change symbols, the number of lines corresponding to the first area in the existing report;
and the adjusting unit 706 is adapted to increase the number of rows of the cells of the area to be filled if the number of corresponding rows of the first area in the existing report is greater than the number of rows of the cells of the area to be filled.
Optionally, as a possible implementation manner, the acquiring unit 703 in the embodiment of the present invention includes:
the receiving module 7031 receives a frame selection instruction, wherein the frame selection instruction is used for indicating a region to be filled in a selected target report, and the row coordinates of cells in the region to be filled are continuous;
and a rejection module 7032, configured to reject column coordinates corresponding to the locked one or more columns of cells in the to-be-filled area, and then take column coordinates corresponding to the remaining cells in the to-be-filled area as column coordinates of the to-be-filled cells in each column.
Optionally, as a possible implementation manner, the report data input system in the embodiment of the present invention further includes:
a first determining unit 707, configured to determine whether the read character string belongs to a preset data type, and discard the currently read character string if the read character string does not belong to the preset data type;
A second judging unit 708, configured to judge whether the read character string matches any preset character string in the preset data set, and discard the currently read character string if there is no matching preset character string.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
The embodiment of the present application further provides a computer device, as shown in fig. 8, for convenience of explanation, only the portions related to the embodiment of the present application are shown, and specific technical details are not disclosed, please refer to the method portions of the embodiment of the present application. Referring to fig. 8, the computer apparatus 8 includes: memory 810, processor 820, wired or wireless network module 830, and computer programs stored in the memory and executable on the processor. The steps of the various report data entry method embodiments described above, such as steps 101 through 104 shown in fig. 1, are implemented when the processor executes a computer program. In the alternative, the processor may implement the functions of the modules or units in the above-described embodiments of the apparatus when executing the computer program.
In some of the embodiments of the present application, the processor is configured to execute the computer program stored in the memory to implement the following steps:
reading character string cache data generated by the cache region copying operation, wherein the character string cache data is generated by copying character strings in each cell of a selected first region in an existing report according to a preset storage format;
analyzing character string cache data according to a preset storage format, taking character strings belonging to the same column in a first area as a group of cache arrays, and sequentially generating cache arrays corresponding to each column of unit cells in the first area, wherein the serial numbers of each group of cache arrays are increased along with the increase of the corresponding column numbers in the first area;
acquiring column coordinates of each column of cells to be filled in a target report form to be filled area and editing control types corresponding to each column of cells to be filled, wherein the existing report forms are different from editing software types of the target report forms;
sequentially completing data filling operation of each column of cells to be filled by taking the cell with the smallest row and column coordinates in the region to be filled as a starting point, wherein the data filling operation comprises the following steps: and starting from the cell to be filled with the minimum column sequence number, sequentially reading each row of character string data in a group of cache arrays according to the sequence number increment of each group of cache arrays to serve as target data of the cell to be filled in the current column, and filling the target data into the cell to be filled in the current column according to a data format matched with the editing control type corresponding to the cell to be filled in the current column.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
traversing the character string cache data, and identifying character strings belonging to the same column in the existing report form in the character string cache data according to the ending character of the cell and the line changing character after each line of cell is ended.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
identifying the number of lines corresponding to the first region in the existing report according to the number of line changing symbols;
and if the number of the corresponding rows of the first area in the existing report is greater than the number of the rows of the cells of the area to be filled, adapting to increase the number of the rows of the cells of the area to be filled.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
receiving a frame selection instruction, wherein the frame selection instruction is used for indicating a region to be filled in a selected target report, and the row coordinates of cells in the region to be filled are continuous;
and after eliminating the column coordinates corresponding to the locked one or more columns of cells in the region to be filled, taking the column coordinates corresponding to the rest cells in the region to be filled as the column coordinates of the cells to be filled in each column.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
Judging whether the read character string belongs to a preset data type, if not, discarding the currently read character string;
and/or judging whether the read character string is matched with any preset character string in the preset data set, and if the matched preset character string does not exist, discarding the currently read character string.
It will be appreciated by those skilled in the art that the structure shown in fig. 8 is not limiting of the computer apparatus, and that the computer apparatus 8 may include more or less components than illustrated, or may combine some of the components, or may be arranged of different components, e.g., the computer apparatus may also include input and output devices, buses, etc.
The processor may be a general purpose processor, a digital signal processor (Digital Signal Processor, DSP), an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), an off-the-shelf programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory may be used to store computer programs and/or modules, and the processor implements various functions of the computer device by running or executing the computer programs and/or modules stored in the memory, and invoking data stored in the memory. The memory may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program (such as a sound playing function, an image playing function, etc.) required for at least one function, and the like; the storage data area may store data (such as audio data, phonebook, etc.) created according to the use of the handset, etc. In addition, the memory may include high-speed random access memory, and may also include non-volatile memory, such as a hard disk, memory, plug-in hard disk, smart Media Card (SMC), secure Digital (SD) Card, flash Card (Flash Card), at least one disk storage device, flash memory device, or other volatile solid-state storage device.
The present application also provides a computer readable storage medium having a computer program stored thereon, which when executed by a processor, can implement the steps of:
Reading character string cache data generated by the cache region copying operation, wherein the character string cache data is generated by copying character strings in each cell of a selected first region in an existing report according to a preset storage format;
analyzing character string cache data according to a preset storage format, taking character strings belonging to the same column in a first area as a group of cache arrays, and sequentially generating cache arrays corresponding to each column of unit cells in the first area, wherein the serial numbers of each group of cache arrays are increased along with the increase of the corresponding column numbers in the first area;
acquiring column coordinates of each column of cells to be filled in a target report form to be filled area and editing control types corresponding to each column of cells to be filled, wherein the existing report forms are different from editing software types of the target report forms;
sequentially completing data filling operation of each column of cells to be filled by taking the cell with the smallest row and column coordinates in the region to be filled as a starting point, wherein the data filling operation comprises the following steps: and starting from the cell to be filled with the minimum column sequence number, sequentially reading each row of character string data in a group of cache arrays according to the sequence number increment of each group of cache arrays to serve as target data of the cell to be filled in the current column, and filling the target data into the cell to be filled in the current column according to a data format matched with the editing control type corresponding to the cell to be filled in the current column.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
traversing the character string cache data, and identifying character strings belonging to the same column in the existing report form in the character string cache data according to the ending character of the cell and the line changing character after each line of cell is ended.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
identifying the number of lines corresponding to the first region in the existing report according to the number of line changing symbols;
and if the number of the corresponding rows of the first area in the existing report is greater than the number of the rows of the cells of the area to be filled, adapting to increase the number of the rows of the cells of the area to be filled.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
receiving a frame selection instruction, wherein the frame selection instruction is used for indicating a region to be filled in a selected target report, and the row coordinates of cells in the region to be filled are continuous;
and after eliminating the column coordinates corresponding to the locked one or more columns of cells in the region to be filled, taking the column coordinates corresponding to the rest cells in the region to be filled as the column coordinates of the cells to be filled in each column.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
Judging whether the read character string belongs to a preset data type, if not, discarding the currently read character string;
and/or judging whether the read character string is matched with any preset character string in the preset data set, and if the matched preset character string does not exist, discarding the currently read character string.
In the several embodiments provided in this application, it should be understood that the disclosed systems, apparatuses, and methods may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (7)
1. A report data entry method, comprising:
reading character string cache data generated by the cache region copying operation, wherein the character string cache data is generated by copying character strings in each cell of a selected first region in an existing report according to a preset storage format;
analyzing the character string cache data according to the preset storage format, taking the character strings belonging to the same column in the first area as a group of cache arrays, and sequentially generating cache arrays corresponding to each column of cells in the first area, wherein the serial numbers of each group of cache arrays are increased along with the increase of the corresponding column number in the first area;
Acquiring column coordinates of each column of cells to be filled in a target report to be filled area and the types of editing controls corresponding to each column of cells to be filled, wherein the existing report is different from the types of editing software of the target report, and the editing controls bind a preset data set;
and sequentially completing data filling operation of each column of cells to be filled by taking the cell with the minimum row and column coordinates in the region to be filled as a starting point, wherein the data filling operation comprises the following steps: starting from the cell to be filled with the minimum column sequence number, sequentially reading character string data in a group of cache arrays according to the sequence number increment of each group of cache arrays to serve as target data of the cell to be filled of the current column, and filling the target data into the cell to be filled of the current column according to a data format matched with the editing control type corresponding to the cell to be filled of the current column;
when the existing report is an electronic table and the cache area is a paste board, the parsing the character string cache data according to the preset storage format includes: traversing the character string cache data, and identifying character strings belonging to the same column in the existing report form in the character string cache data according to the cell ending character and the line changing character after each line of cells are ended;
Before the character strings belonging to the same column in the first area are used as a group of cache arrays, the method further comprises: judging whether the parsed character string belongs to a preset data type, if not, discarding the currently read character string; and/or judging whether the read character string is matched with any preset character string in the preset data set, and if the matched preset character string does not exist, discarding the currently read character string.
2. The method as recited in claim 1, further comprising:
identifying the number of the first area cell lines according to the number of the line-feed symbols;
and if the number of the corresponding rows of the first area in the existing report is greater than the number of the rows of the to-be-filled area cells, adapting to increase the number of the rows of the to-be-filled area cells.
3. The method according to any one of claims 1 to 2, wherein the obtaining column coordinates of each column of cells to be filled in the target report to be filled area includes:
receiving a frame selection instruction, wherein the frame selection instruction is used for indicating a region to be filled in a selected target report, and the row coordinates of cells in the region to be filled are continuous;
And after eliminating the column coordinates corresponding to the locked one or more columns of cells in the region to be filled, taking the column coordinates corresponding to the remaining cells in the region to be filled as the column coordinates of the cells to be filled in each column.
4. A report data entry system, comprising:
the reading unit is used for reading character string cache data generated by the cache region copying operation, wherein the character string cache data is generated by copying character strings in each cell of the selected first region in the existing report according to a preset storage format;
the analyzing unit is used for analyzing the character string cache data according to the preset storage format, taking the character strings belonging to the same column in the first area as a group of cache arrays, and sequentially generating the cache arrays corresponding to the unit cells of each column in the first area, wherein the serial numbers of the cache arrays of each group are increased along with the increase of the corresponding column number in the first area;
the system comprises an acquisition unit, a storage unit and a display unit, wherein the acquisition unit is used for acquiring column coordinates of all columns of cells to be filled in a target report to be filled area and editing control types corresponding to all columns of cells to be filled in, the existing report is different from the editing software types of the target report, and the editing control is bound with a preset data set;
The filling unit is used for sequentially completing data filling operation of each column of cells to be filled by taking the cell with the minimum row and column coordinates in the region to be filled as a starting point, and the data filling operation comprises the following steps: starting from the cell to be filled with the minimum column sequence number, sequentially reading character string data in a group of cache arrays according to the sequence number increment of each group of cache arrays to serve as target data of the cell to be filled of the current column, and filling the target data into the cell to be filled of the current column according to a data format matched with the editing control type corresponding to the cell to be filled of the current column;
when the existing report is a spreadsheet and the cache area is a sticky board, the parsing unit includes: the traversing module is used for traversing the character string cache data, recognizing character strings belonging to the same column in the existing report form in the character string cache data according to the end characters of the cells and the line-changing symbols after each row of cells are ended, and sequentially generating cache arrays corresponding to each column of cells in the first area, wherein the sequence numbers of the cache arrays of each group are increased along with the increase of the corresponding column numbers in the first area;
The first judging unit is used for judging whether the read character string belongs to a preset data type or not, and if the read character string does not belong to the preset data type, discarding the currently read character string; and/or a second judging unit, configured to judge whether the read character string matches any preset character string in the preset data set, and if the matched preset character string does not exist, discard the currently read character string.
5. The system of claim 4, further comprising:
the identification unit is used for identifying the number of the corresponding rows of the first area in the existing report according to the number of the line changing symbols;
and the adjusting unit is used for adapting to increase the number of the lines of the cells of the area to be filled if the number of the lines corresponding to the first area in the existing report is larger than the number of the lines of the cells of the area to be filled.
6. A computer device comprising a processor for implementing the steps of the method according to any one of claims 1 to 3 when executing a computer program stored in a memory.
7. A computer-readable storage medium having stored thereon a computer program, characterized by: the computer program implementing the steps of the method according to any one of claims 1 to 3 when executed by a processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910804191.XA CN110516220B (en) | 2019-08-28 | 2019-08-28 | Report data input method, system and related equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910804191.XA CN110516220B (en) | 2019-08-28 | 2019-08-28 | Report data input method, system and related equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110516220A CN110516220A (en) | 2019-11-29 |
| CN110516220B true CN110516220B (en) | 2023-12-26 |
Family
ID=68627624
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910804191.XA Active CN110516220B (en) | 2019-08-28 | 2019-08-28 | Report data input method, system and related equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110516220B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112183040A (en) * | 2020-09-27 | 2021-01-05 | 金蝶软件（中国）有限公司 | Voucher generation method and related device |
| CN116029267A (en) * | 2023-02-08 | 2023-04-28 | 信利光电股份有限公司 | Excel data typesetting processing method, device and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2001325562A (en) * | 2000-05-17 | 2001-11-22 | Minolta Co Ltd | Image recognizing device, image forming device, image recognizing method, and computer-readable recording medium with image reocgnizing program stored therein |
| CN102799574A (en) * | 2012-06-29 | 2012-11-28 | 无锡永中软件有限公司 | Data partitioning and merging method for electronic forms |
| CN102819539A (en) * | 2011-09-28 | 2012-12-12 | 金蝶软件（中国）有限公司 | Repaid data type-in method and system |
| CN104616088A (en) * | 2014-09-28 | 2015-05-13 | 用友优普信息技术有限公司 | Device and method for quickly filling table |
| CN109522538A (en) * | 2018-11-28 | 2019-03-26 | 腾讯科技（深圳）有限公司 | Table content divides column method, apparatus, equipment and storage medium automatically |
-
2019
- 2019-08-28 CN CN201910804191.XA patent/CN110516220B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2001325562A (en) * | 2000-05-17 | 2001-11-22 | Minolta Co Ltd | Image recognizing device, image forming device, image recognizing method, and computer-readable recording medium with image reocgnizing program stored therein |
| CN102819539A (en) * | 2011-09-28 | 2012-12-12 | 金蝶软件（中国）有限公司 | Repaid data type-in method and system |
| CN102799574A (en) * | 2012-06-29 | 2012-11-28 | 无锡永中软件有限公司 | Data partitioning and merging method for electronic forms |
| CN104616088A (en) * | 2014-09-28 | 2015-05-13 | 用友优普信息技术有限公司 | Device and method for quickly filling table |
| CN109522538A (en) * | 2018-11-28 | 2019-03-26 | 腾讯科技（深圳）有限公司 | Table content divides column method, apparatus, equipment and storage medium automatically |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110516220A (en) | 2019-11-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108932236B (en) | File management method and device | |
| CN107391762B (en) | Log data processing method and device | |
| CN110516220B (en) | Report data input method, system and related equipment | |
| CN106570013B (en) | Method and device for processing page access data | |
| CN107992492B (en) | Data block storage method, data block reading method, data block storage device, data block reading device and block chain | |
| CN111400387B (en) | Conversion method and device for import and export data, terminal equipment and storage medium | |
| CN108875077B (en) | Column storage method and device of database, server and storage medium | |
| CN109241003B (en) | File management method and device | |
| CN102110102A (en) | Data processing method and device, and file identifying method and tool | |
| CN103699544B (en) | The method and system of cross-page selection data | |
| CN114357943A (en) | Universal efficient Excel reading processing method, tool, medium and equipment | |
| CN112307318B (en) | Content publishing method, system and device | |
| CN106599324B (en) | CAD data capturing method | |
| CN110083810B (en) | Form conversion method and device, storage medium and electronic equipment | |
| CN108038125B (en) | Method, device, equipment and storage medium for automatically comparing fund system test values | |
| CN108664505A (en) | A kind of deriving method and device of database table structure | |
| CN115065945B (en) | Short message link generation method and device, electronic equipment and storage medium | |
| CN116341514A (en) | File analysis method and device based on dynamic configuration | |
| CN111309370B (en) | Version number directed graph ordering auditing method and system for multi-project multi-system environment | |
| CN107092607A (en) | A kind of bill storage method and device | |
| CN114840586A (en) | Data conversion method, equipment, server and computer readable storage medium | |
| CN113126981B (en) | Medical data processing method and device based on Excel | |
| CN113127408A (en) | Data conversion method and device | |
| CN116821146B (en) | Apache Iceberg-based data list updating method and system | |
| CN107861956B (en) | Method and device for inquiring data record of bayonet passing vehicle |
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 |