CN113962205A - Method and device for pasting spreadsheet contents, electronic equipment and storage medium - Google Patents
Method and device for pasting spreadsheet contents, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN113962205A CN113962205A CN202111217450.2A CN202111217450A CN113962205A CN 113962205 A CN113962205 A CN 113962205A CN 202111217450 A CN202111217450 A CN 202111217450A CN 113962205 A CN113962205 A CN 113962205A
- Authority
- CN
- China
- Prior art keywords
- data
- target
- column
- pasting
- contents
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Document Processing Apparatus (AREA)
Abstract
The application discloses a method for pasting spreadsheet contents, which is applied to an office system and comprises the following steps: reading table contents from the clipboard; wherein the table content is obtained by column-by-column copying of data in the electronic table; determining a data type corresponding to the column where the table content is located, and performing corresponding text formatting processing on the table content according to the data type to obtain target data; pasting the target data to a corresponding column in a target table according to the data type; the target form is a form used for entering data in the office system. The method and the device can improve the pasting efficiency of the electronic form content and improve the usability of the office system. The application also discloses a device for pasting the spreadsheet contents, an electronic device and a storage medium, which have the beneficial effects.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method and an apparatus for pasting spreadsheet contents, an electronic device, and a storage medium.
Background
Due to the difference of data formats, interfaces and analytical logics between office systems such as ERP and OA and electronic form software such as Excel and WPS, contents in the electronic forms cannot be directly copied into forms of the office systems.
In the practical application process, a demand exists for data recording processing using both the electronic forms and the office system. When a user needs to input data in a document in batch, the data content in the electronic form is directly copied and pasted for use because an office system does not support manual input one by one, and the input process is time-consuming and labor-consuming.
Therefore, how to improve the pasting efficiency of the spreadsheet contents and improve the usability of the office system is a technical problem that needs to be solved by those skilled in the art at present.
Disclosure of Invention
The application aims to provide a method and a device for pasting spreadsheet contents, an electronic device and a storage medium, which can improve the pasting efficiency of the spreadsheet contents and the usability of an office system.
In order to solve the above technical problem, the present application provides a method for pasting spreadsheet contents, which is applied to an office system, and the method for pasting spreadsheet contents includes:
reading table contents from the clipboard; wherein the table content is obtained by column-by-column copying of data in the electronic table;
determining a data type corresponding to the column where the table content is located, and performing corresponding text formatting processing on the table content according to the data type to obtain target data;
pasting the target data to a corresponding column in a target table according to the data type; the target form is a form used for entering data in the office system.
Optionally, if the table content includes multiple columns of data in the electronic table, determining a data type corresponding to a column in which the table content is located includes:
determining a field arrangement rule corresponding to each data type;
selecting table data of a current column from the table content;
matching the table data of the current column with a plurality of field arrangement rules, and setting the data type corresponding to the field arrangement rule hit by matching as the data type corresponding to the table data of the current column;
judging whether the data types of the table data of all columns in the table content are set completely;
if not, the step of selecting the table data of the current column from the table content is carried out.
Optionally, matching the table data of the current column with a plurality of field arrangement rules, and setting a data type corresponding to a field arrangement rule hit by the matching as a data type corresponding to the table data of the current column, including:
setting a rule comparison sequence; the rule comparison sequence is used for describing the comparison sequence of the table data of the current column and a plurality of field arrangement rules;
and matching the table data of the current column with a plurality of field arrangement rules in sequence according to the rule comparison sequence, and setting the data type corresponding to the field arrangement rule hit by matching as the data type corresponding to the table data of the current column.
Optionally, the setting of the rule comparison order includes:
setting an original comparison sequence according to field arrangement rules corresponding to all data types, and removing the field arrangement rules in the matching hit in the original comparison sequence to obtain the rule comparison sequence.
Optionally, after the target data is pasted to the corresponding column in the target table according to the data type, the method further includes:
judging whether the target data passes validity check according to the check logic of the office system;
and if the target data does not pass the validity check, deleting the target data in the target table.
Optionally, after determining whether the target data passes the validity check according to the checking logic of the office system, the method further includes:
if the target data passes the validity check, adding the associated attribute field of the target data to the corresponding column in the target table;
judging whether the associated attribute field of the target data passes validity check according to the check logic of the office system;
and if the associated attribute field of the target data does not pass the validity check, deleting the target data and the associated attribute field of the target data in the target table.
Optionally, after deleting the target data in the target table, the method further includes:
generating paste failure information corresponding to the target data; wherein the pasting failure information comprises the position information of the target data in the electronic form.
The present application also provides a device for pasting spreadsheet contents, the device comprising:
the content reading module is used for reading table contents from the clipboard; wherein the table content is obtained by column-by-column copying of data in the electronic table;
the formatting processing module is used for determining the data type corresponding to the column where the table content is located and executing corresponding text formatting processing on the table content according to the data type to obtain target data;
the pasting module is used for pasting the target data to a corresponding column in a target table according to the data type; the target form is a form used for entering data in an office system.
The present application also provides a storage medium having stored thereon a computer program that, when executed, implements the steps performed by the above-described method of pasting of spreadsheet contents.
The application also provides an electronic device, which comprises a memory and a processor, wherein the memory is stored with a computer program, and the processor realizes the steps executed by the pasting method of the spreadsheet contents when calling the computer program in the memory.
The application provides a method for pasting spreadsheet contents, which is applied to an office system and comprises the following steps: reading table contents from the clipboard; wherein the table content is obtained by column-by-column copying of data in the electronic table; determining a data type corresponding to the column where the table content is located, and performing corresponding text formatting processing on the table content according to the data type to obtain target data; pasting the target data to a corresponding column in a target table according to the data type; the target form is a form used for entering data in the office system.
The method includes the steps that table contents are read from a clipboard, different columns in an electronic table correspond to different data types, and through determining the data type corresponding to the column where the table contents are located, text formatting processing operation corresponding to the data type is performed on the table contents, and target data in a table which can be directly pasted to an office system are obtained. After the target data are obtained, pasting the target data to the corresponding columns in the target table according to the data types, and finishing the operation of copying the contents from the electronic table and pasting the contents to the target table of the office system. According to the method and the device, text formatting processing is carried out according to the data type of the form data, the target data which accord with the entry rule of the office system is obtained, automatic pasting of the electronic form content can be achieved, manual participation processing is not needed, therefore, the pasting efficiency of the electronic form content can be improved, and the usability of the office system is improved. The application also provides a device for pasting the spreadsheet contents, electronic equipment and a storage medium, which have the beneficial effects and are not repeated herein.
Drawings
In order to more clearly illustrate the embodiments of the present application, the drawings needed for the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings can be obtained by those skilled in the art without inventive effort.
FIG. 1 is a flow chart of a method for pasting spreadsheet contents according to an embodiment of the present application;
fig. 2 is a flowchart of a method for determining a data category according to an embodiment of the present application;
FIG. 3 is a schematic diagram illustrating a scheme for batch pasting of spreadsheet contents into an ERP system according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an apparatus for pasting spreadsheet contents according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
Referring to fig. 1, fig. 1 is a flowchart illustrating a method for pasting spreadsheet contents according to an embodiment of the present application.
The specific steps may include:
s101: reading table contents from the clipboard;
the embodiment can be applied to an Office system, and the Office system may include an ERP (Enterprise Resources Planning) system or an OA (Office Automation) system. The ERP system is a management platform which is established on the basis of information technology and provides decision operation means for enterprise decision and staff with systematic management ideas, and can provide management of integrating real-time information across regions, departments and even companies.
Before this step, there may be an operation of the user to copy data by column from the spreadsheet to obtain table contents, and the copied table contents are stored in the clipboard. Spreadsheets, also known as spreadsheets, are a class of computer programs that simulate a computational form on paper. Spreadsheets display a grid of rows and columns, and the cells may hold values, calculations, or text. The spreadsheet software referred to in this embodiment includes WPS Office, Microsoft Office Excel, and the like. The office system in this embodiment is an office system different from the target information of the electronic form, and the parameter includes any one or a combination of any several items of data format, interface, and parsing logic.
S102: determining a data type corresponding to the column where the table content is located, and performing corresponding text formatting processing on the table content according to the data type to obtain target data;
the types of each column of data in the electronic form are the same, and each data type has a corresponding field arrangement rule, so that the data in the form content can be matched according to the field arrangement rule, and the data type corresponding to the column where the grid content is located is further determined.
Each data type in the office system has a corresponding text formatting processing mode, so that target data can be obtained by performing text formatting processing corresponding to the data type on the table contents on the basis of determining the data type of each column of table contents. The target data conform to the entry rule of the office system, so that the target data can be directly pasted to the office system.
S103: pasting the target data to a corresponding column in a target table according to the data type;
upon obtaining the target data, the target data may be pasted into a target table of the office system. The target form is a form for data entry in the office system. Specifically, the target table includes a plurality of columns, and the columns of the target table have corresponding data types, so that the target data can be pasted to the target table of the office system according to the data types corresponding to the target data.
In this embodiment, table contents are read from the clipboard, different columns in the electronic table correspond to different data types, and the target data in the table that can be directly pasted to the office system is obtained by determining the data type corresponding to the column where the table contents are located and performing a text formatting processing operation corresponding to the data type on the table contents. After the target data is obtained, the present embodiment pastes the target data to a corresponding column in the target table according to the data type, and completes the operation of copying the content from the electronic form and pasting the content to the target table of the office system. According to the embodiment, text formatting processing is performed according to the data type of the form data to obtain the target data meeting the entry rule of the office system, and automatic pasting of the electronic form content can be realized without manual processing, so that the pasting efficiency of the electronic form content can be improved, and the usability of the office system is improved.
Referring to fig. 2, fig. 2 is a flowchart of a method for determining a data type according to an embodiment of the present application, where this embodiment further describes a process of S102 in the embodiment corresponding to fig. 1, and a further implementation may be obtained by combining this embodiment with the embodiment corresponding to fig. 1, where if the table content includes multiple columns of data in the electronic table, the process of determining the data type corresponding to the column of the table content includes:
s201: determining a field arrangement rule corresponding to each data type;
wherein each data type has its corresponding field arrangement rule, the following provides the field arrangement rules for several data types:
(1) if the data type is the commodity code, the commodity code at least has the following four field arrangement rules: a first step is a number; a number + letter; ③ number + sign; and fourthly, the numbers, the letters and the symbols.
(2) If the data type is an auxiliary attribute, the auxiliary attribute at least has the following four field arrangement rules: a letter; ② Chinese; ③ Chinese + letter + symbol; and fourthly, English + symbols. The auxiliary attribute is information describing the commodity attribute, and if the commodity is a mobile phone, the commodity attribute of the mobile phone comprises the memory size, the color and the like.
(3) If the data type is number, the corresponding field arrangement rule may be: number (integer, decimal).
(4) If the data type is unit price, the corresponding field arrangement rule may be: number (integer, decimal).
(5) If the data type is the tax rate, the corresponding field arrangement rule may be: percentage (D).
S202: selecting table data of a current column from the table content;
if the table content in the clipboard includes a plurality of columns of table data, the table data of the current column may be selected from the table content, so as to perform column-by-column detection on the data type in the table content.
S203: matching the table data of the current column with a plurality of field arrangement rules, and setting the data type corresponding to the field arrangement rule hit by matching as the data type corresponding to the table data of the current column;
in this embodiment, the table data in the current column may be matched with the field arrangement rule, and the data type corresponding to the field arrangement rule hit by matching is set as the data type corresponding to the table data in the current column. The above process is explained by taking the field arrangement rules of 5 data categories listed above as examples: if the table data in the current column is '36 AB +', the corresponding data type is a commodity code; if the table data in the current column is red, the corresponding data type is an auxiliary attribute; if the table data in the current column is "20%", the corresponding data type is the tax rate.
S204: judging whether the data types of the table data of all columns in the table content are set completely; if yes, ending the process; if not, the step S202 is entered;
because the table content includes multiple columns of data in the electronic table, after the data type of the table data of the current column is determined, it may be determined whether the data types of the table data of all columns in the table content are all determined, and if yes, the operation of performing corresponding text formatting processing on the table content according to the data types to obtain target data in the embodiment corresponding to fig. 1 may be performed; if not, re-determining the table data of the current column.
As a further description of the corresponding embodiment of fig. 2, the table data of the current column may be compared with a plurality of field arrangement rules one by one, specifically: a rule comparison order can be set; the rule comparison sequence is used for describing the comparison sequence of the table data of the current column and a plurality of field arrangement rules; and matching the table data of the current column with a plurality of field arrangement rules in sequence according to the rule comparison sequence, and setting the data type corresponding to the field arrangement rule hit by matching as the data type corresponding to the table data of the current column. The above-mentioned rule comparison sequence may be in turn: commodity code, auxiliary attribute, quantity, unit price and tax rate.
Further, since the data types corresponding to any two columns in the table are different, the data type of the table data in the other columns in which the data type is not specified is not the data type of the table data in the current column after the data type of the table data in the current column is specified. Specifically, the process of setting the rule comparison sequence includes: setting an original comparison sequence according to field arrangement rules corresponding to all data types, and removing the field arrangement rules in the matching hit in the original comparison sequence to obtain the rule comparison sequence. For example, the original comparison sequence is commodity code, auxiliary attribute, quantity, unit price and tax rate; after the data type of the table data in the current column is determined to be the quantity, the order of rule comparison utilized when the data type of the table data in the next column is determined is commodity code, auxiliary attribute, unit price and tax rate; after the data type of the table data in the current column is determined to be the commodity code, the rule comparison sequence used when the data type of the table data in the next column is determined is auxiliary attribute, unit price and tax rate.
As a further introduction to the corresponding embodiment of fig. 1, after the target data is pasted to the corresponding column in the target table according to the data type in S103, it may also be determined whether the target data passes the validity check according to the checking logic of the office system; and if the target data does not pass the validity check, deleting the target data in the target table.
The office system comprises a plurality of data types, wherein the data types are stored in a checking logic of the office system, and the checking logic comprises a data value range or content which can be pasted. For example, the number corresponds to a value range of 0-30%, and if the target data is 50%, it is determined that the target data does not pass the validity check. Specifically, the process of deleting the target data is as follows: all data in the table content in the column where the target data is located is deleted.
Further, after judging whether the target data passes the validity check according to the check logic of the office system, if the target data passes the validity check, adding the associated attribute field of the target data to the corresponding column in the target table; judging whether the associated attribute field of the target data passes validity check according to the check logic of the office system; and if the associated attribute field of the target data does not pass the validity check, deleting the target data and the associated attribute field of the target data in the target table. The office system can preset the associated attribute field of the target data, then the target data is added to the target form, and after the legality verification is passed, the associated attribute field can be added to the target form. For example, the product model is a certain brand of mobile phone, and the color of the mobile phone is only black, so after the product model of the certain brand of mobile phone is added to the target table, the data "red" can be added in the color column of the same row of the product model.
As a possible implementation manner, after the target data is deleted in the target form, paste failure information corresponding to the target data may be further generated so as to prompt the user of contents of paste failure in the electronic form; wherein the pasting failure information comprises the position information of the target data in the electronic form.
In the related technology, the processing is carried out by leading out a document Excel template, filling data and then leading in, and the processing logic of the processing logic is correspondingly led in through API fields or directly inserted into SQL (structured query language), and the precondition is that a user firstly maintains the data of each field in Excel and then leads in the system. For the user, the complexity of the operation is basically the same as that of the document input once in the system, the manual workload is not reduced, Excel does not have data validity check logic of an ERP system, and errors cannot be identified and corrected when data is input; meanwhile, in the scheme of the related technology, the template has too much information content for introducing verification, the performance is very low, the experience sense is very poor, and intelligent, rapid and accurate batch processing service cannot be realized. In view of various defects in the related technologies, the embodiment provides a scheme for pasting spreadsheet contents to an ERP system in batches, and in the scheme, by directly copying EXCEL contents in batches and pasting the EXCEL contents to documents in the ERP system, manual operation is reduced, product usability is improved, and working efficiency of personnel is improved.
The flow described in the above embodiment is explained below by an embodiment in practical use. Referring to fig. 3, fig. 3 is a schematic diagram of a solution for batch pasting of spreadsheet contents to an ERP system according to an embodiment of the present application, where the process includes data copying, data pasting, data parsing and formatting, data checking, and matching to fill ERP fields and return to use.
In the data copying process, a user copies the material data (codes, quantities, auxiliary attributes and the like) in the spreadsheet according to column selection, and the selective copying process supports multi-column batch copying. After the data is pasted to the clipboard, the copied data can be parsed according to the contents of the clipboard, and text formatting processing can be performed on the data. In the case of a single column, the user confirms that the corresponding situation may not need to be analyzed, and in the case of copying multiple columns of data, the user needs to perform formatting analysis (such as key fields of codes, numbers, auxiliary attributes and the like) according to a rule comparison sequence as follows: item code, auxiliary attribute, quantity, unit price, tax rate.
In the process of formatting the copied data, if the data of the copied column does not accord with the nth field arrangement rule, matching the N +1 th field arrangement rule of the column during formatting, and if the data of the copied column matches with the nth field arrangement rule, formatting. For example: the user copies three columns, the contents of which are (number + letter), number, and percentage, and when formatting, because there is no column data conforming to the "auxiliary attribute" column analysis rule, the second column data is formatted into "number" in sequence, and so on. If the corresponding column does not accord with the analysis rule, the column fails to copy and is not added into the clipboard.
Filling the formatted data into corresponding fields in the ERP system in a pasting mode; and automatically splitting the data of the multiple columns according to the analysis rule, and filling the data into the fields corresponding to the columns. And after the data is filled into a form of the ERP system, sequentially checking the validity of the data according to the checking logic of the ERP system, if the data passes the checking, keeping the row details, carrying other associated attribute fields back to fill, filling according to the rows, then filling according to the columns, checking after filling, and if the data does not pass the checking, directly deleting to check the next row or row of data. If the previous data passes the verification and the associated attribute field fails to verify, the previous data and the corresponding previous data are deleted so as to ensure the validity and the accuracy of the data.
The embodiment directly copies the data in the EXCEL in batches, and then the data can be directly pasted to the ERP system for use, so that the data in the spreadsheet is converted to accord with the entry rule of the ERP system, and the data to be filled can be directly and automatically entered, thereby improving the working efficiency and the operation usability of the ERP system.
Referring to fig. 4, fig. 4 is a schematic structural diagram of an apparatus for pasting spreadsheet contents according to an embodiment of the present application, where the apparatus may include:
a content reading module 401, configured to read table content from a clipboard; wherein the table content is obtained by column-by-column copying of data in the electronic table;
a formatting processing module 402, configured to determine a data type corresponding to a column where the table content is located, and perform corresponding text formatting processing on the table content according to the data type to obtain target data;
a pasting module 403, configured to paste the target data to a corresponding column in a target table according to the data type; the target form is a form used for entering data in an office system.
In this embodiment, table contents are read from the clipboard, different columns in the electronic table correspond to different data types, and the target data in the table that can be directly pasted to the office system is obtained by determining the data type corresponding to the column where the table contents are located and performing a text formatting processing operation corresponding to the data type on the table contents. After the target data is obtained, the present embodiment pastes the target data to a corresponding column in the target table according to the data type, and completes the operation of copying the content from the electronic form and pasting the content to the target table of the office system. According to the embodiment, text formatting processing is performed according to the data type of the form data to obtain the target data meeting the entry rule of the office system, and automatic pasting of the electronic form content can be realized without manual processing, so that the pasting efficiency of the electronic form content can be improved, and the usability of the office system is improved.
Further, the format processing module 402 includes:
an arrangement rule determining unit, configured to determine a field arrangement rule corresponding to each data type;
the data selection unit is used for selecting the table data of the current column from the table content;
the type setting unit is used for matching the table data of the current column with a plurality of field arrangement rules and setting the data type corresponding to the field arrangement rule hit by matching as the data type corresponding to the table data of the current column;
the judging unit is used for judging whether the data types of the table data of all the columns in the table content are set completely; if not, the step of selecting the table data of the current column from the table content is carried out.
Further, the category setting unit is used for setting a rule comparison sequence; the rule comparison sequence is used for describing the comparison sequence of the table data of the current column and a plurality of field arrangement rules; and the data processing device is further used for sequentially matching the table data of the current column with a plurality of field arrangement rules according to the rule comparison sequence, and setting the data type corresponding to the field arrangement rule hit by matching as the data type corresponding to the table data of the current column.
Further, the process of setting the rule comparison order by the category setting unit includes: setting an original comparison sequence according to field arrangement rules corresponding to all data types, and removing the field arrangement rules in the matching hit in the original comparison sequence to obtain the rule comparison sequence.
Further, the method also comprises the following steps:
the checking module is used for judging whether the target data passes the legality checking according to the checking logic of the office system after the target data is pasted to the corresponding column in the target table according to the data type; and deleting the target data in the target table if the target data fails in the validity check.
Further, the method also comprises the following steps:
the associated attribute field filling module is used for adding the associated attribute field of the target data to a corresponding column in the target form if the target data passes the legality check after judging whether the target data passes the legality check according to the check logic of the office system; the system is also used for judging whether the associated attribute field of the target data passes the validity check according to the checking logic of the office system; and the data processing device is also used for deleting the target data and the associated attribute field of the target data in the target table if the associated attribute field of the target data does not pass the validity check.
Further, the method also comprises the following steps:
the prompt module is used for generating paste failure information corresponding to the target data after the target data is deleted from the target table; wherein the pasting failure information comprises the position information of the target data in the electronic form.
Since the embodiments of the apparatus portion and the method portion correspond to each other, please refer to the description of the embodiments of the method portion for the embodiments of the apparatus portion, which is not repeated here.
The present application also provides a storage medium having a computer program stored thereon, which when executed, may implement the steps provided by the above-described embodiments. The storage medium may include: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The application further provides an electronic device, which may include a memory and a processor, where the memory stores a computer program, and the processor may implement the steps provided by the foregoing embodiments when calling the computer program in the memory. Of course, the electronic device may also include various network interfaces, power supplies, and the like.
The embodiments are described in a progressive manner in the specification, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description. It should be noted that, for those skilled in the art, it is possible to make several improvements and modifications to the present application without departing from the principle of the present application, and such improvements and modifications also fall within the scope of the claims of the present application.
It is further noted that, in the present specification, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Claims (10)
1. A method for pasting spreadsheet contents, applied to an office system, the method comprising:
reading table contents from the clipboard; wherein the table content is obtained by column-by-column copying of data in the electronic table;
determining a data type corresponding to the column where the table content is located, and performing corresponding text formatting processing on the table content according to the data type to obtain target data;
pasting the target data to a corresponding column in a target table according to the data type; the target form is a form used for entering data in the office system.
2. The method for pasting spreadsheet contents as claimed in claim 1, wherein if said spreadsheet contents includes a plurality of columns of data in said spreadsheet, determining the data type corresponding to the column of said spreadsheet contents comprises:
determining a field arrangement rule corresponding to each data type;
selecting table data of a current column from the table content;
matching the table data of the current column with a plurality of field arrangement rules, and setting the data type corresponding to the field arrangement rule hit by matching as the data type corresponding to the table data of the current column;
judging whether the data types of the table data of all columns in the table content are set completely;
if not, the step of selecting the table data of the current column from the table content is carried out.
3. The method for pasting spreadsheet contents according to claim 2, wherein matching the table data in the current column with a plurality of field arrangement rules and setting the data type corresponding to the field arrangement rule hit by the matching as the data type corresponding to the table data in the current column comprises:
setting a rule comparison sequence; the rule comparison sequence is used for describing the comparison sequence of the table data of the current column and a plurality of field arrangement rules;
and matching the table data of the current column with a plurality of field arrangement rules in sequence according to the rule comparison sequence, and setting the data type corresponding to the field arrangement rule hit by matching as the data type corresponding to the table data of the current column.
4. The method for pasting spreadsheet contents as claimed in claim 3, wherein said setting the rule comparison order comprises:
setting an original comparison sequence according to field arrangement rules corresponding to all data types, and removing the field arrangement rules in the matching hit in the original comparison sequence to obtain the rule comparison sequence.
5. The method for pasting spreadsheet contents as claimed in claim 1, further comprising after pasting said target data to a corresponding column in a target table according to said data category:
judging whether the target data passes validity check according to the check logic of the office system;
and if the target data does not pass the validity check, deleting the target data in the target table.
6. The method for pasting spreadsheet contents according to claim 5, further comprising after determining whether said target data passes validity check according to check logic of said office system:
if the target data passes the validity check, adding the associated attribute field of the target data to the corresponding column in the target table;
judging whether the associated attribute field of the target data passes validity check according to the check logic of the office system;
and if the associated attribute field of the target data does not pass the validity check, deleting the target data and the associated attribute field of the target data in the target table.
7. The method for pasting spreadsheet contents according to claim 5, further comprising after deleting said target data in said target table:
generating paste failure information corresponding to the target data; wherein the pasting failure information comprises the position information of the target data in the electronic form.
8. An apparatus for pasting of spreadsheet contents, said apparatus comprising:
the content reading module is used for reading table contents from the clipboard; wherein the table content is obtained by column-by-column copying of data in the electronic table;
the formatting processing module is used for determining the data type corresponding to the column where the table content is located and executing corresponding text formatting processing on the table content according to the data type to obtain target data;
the pasting module is used for pasting the target data to a corresponding column in a target table according to the data type; the target form is a form used for entering data in an office system.
9. An electronic device, characterized by comprising a memory in which a computer program is stored and a processor which, when calling the computer program in the memory, implements the steps of the paste method of spreadsheet contents according to any of claims 1 to 7.
10. A storage medium having stored thereon computer-executable instructions which, when loaded and executed by a processor, carry out the steps of a method of pasting of spreadsheet contents as claimed in any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111217450.2A CN113962205A (en) | 2021-10-19 | 2021-10-19 | Method and device for pasting spreadsheet contents, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111217450.2A CN113962205A (en) | 2021-10-19 | 2021-10-19 | Method and device for pasting spreadsheet contents, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113962205A true CN113962205A (en) | 2022-01-21 |
Family
ID=79464502
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111217450.2A Pending CN113962205A (en) | 2021-10-19 | 2021-10-19 | Method and device for pasting spreadsheet contents, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113962205A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115237863A (en) * | 2022-09-22 | 2022-10-25 | 中建电子商务有限责任公司 | EXCEL data import method based on WPS loading item |
-
2021
- 2021-10-19 CN CN202111217450.2A patent/CN113962205A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115237863A (en) * | 2022-09-22 | 2022-10-25 | 中建电子商务有限责任公司 | EXCEL data import method based on WPS loading item |
| CN115237863B (en) * | 2022-09-22 | 2023-01-10 | 中建电子商务有限责任公司 | EXCEL data import method based on WPS loading item |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7996759B2 (en) | Data insertion from a database into a fixed electronic template form that supports overflow data | |
| US9495347B2 (en) | Systems and methods for extracting table information from documents | |
| CN112035653B (en) | Policy key information extraction method and device, storage medium and electronic equipment | |
| US9613115B2 (en) | Generating programs based on input-output examples using converter modules | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| CN115061721A (en) | Report generation method and device, computer equipment and storage medium | |
| US10089285B2 (en) | Method to automatically convert proposal documents | |
| SG185058A1 (en) | Automatic report generation system and method therefor | |
| WO2023179386A1 (en) | Data processing method, device, storage medium, and program product | |
| CN113962205A (en) | Method and device for pasting spreadsheet contents, electronic equipment and storage medium | |
| US20240143899A1 (en) | Systems and methods for conversion of documents to reusable content types | |
| CN113362025A (en) | Data accounting system, method, computer readable storage medium, electronic device | |
| CN108536715B (en) | Preview page generation method, device, equipment and storage medium | |
| CN115809228A (en) | Data comparison method and device, storage medium and electronic equipment | |
| KR20200091560A (en) | Method and system extracting terms within documention for automating customs declaration process | |
| KR20200091558A (en) | Method and system for automating customs declaration process | |
| CN114169306A (en) | Method, device and equipment for generating electronic receipt and readable storage medium | |
| CN113689198A (en) | Project file generation method and device, storage medium and terminal equipment | |
| CN112949274A (en) | Document data entry method and system | |
| CN111159234A (en) | Method and device for comparing reports | |
| CN111090978A (en) | Receipt processing method and device and storage medium | |
| CN115063211B (en) | Method and device for acquiring commodity attribute data | |
| CN114255335A (en) | Electronic invoice recognition method, system, electronic device and medium | |
| CN116340404A (en) | Method, system, electronic equipment and medium for supporting Excel batch import of synchronous data | |
| CN115358191A (en) | Teaching material data conversion method, device, equipment and storage medium based on middleware |
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 |