Table content correction method and device

Abstract

The invention provides a table content correction method and device, and the method comprises the steps: carrying out the content extraction of a to-be-corrected table, and obtaining the to-be-corrected content; determining a correction rule corresponding to the to-be-corrected content; performing content correction on the to-be-corrected content according to the correction rule to obtain target content; and replacing the to-be-corrected content in the to-be-corrected table with the target content to obtain a target table, so that the content of the to-be-corrected table can be automatically corrected, and the efficiency is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for correcting table content, electronic equipment and a storage medium. Background technique [0002] A spreadsheet is composed of multiple cells. Depending on the row or column, the content in the cell can be a number type, such as time, balance, currency, etc., or a text type, such as name, project name, note text, etc. . [0003] In the prior art, when identifying the content in the electronic form, the following problems will be encountered. For example, when the data exported or downloaded by the user is opened using the electronic form, the default number format is a text value, which makes the number unable to participate in the subsequent Calculation of charts or formulas; another example is when multiple people collaborate to edit a spreadsheet, due to the inconsistent data input habits of each user, there may be multiple digital formats at the sa...

AI Technical Summary

Problems solved by technology

[0003] In the prior art, when identifying the content in the electronic form, the following problems will be encountered. For example, when the data exported or downloaded by the user is opened using the electronic form, the default number format is a text value, which makes the number unable to participate in the subsequent Calculation of charts or formulas; another example is when multiple people collaborate to edit a spreadsheet, due to the inconsistent data input habits of each user, there may be multiple digital formats at the same time, such as January 1, 2021, 2021 / 1 / 1, 2021 -1-1 etc., affect reading and comprehension

[0004] However, when the above problems occur in the prior art, the user needs to find and correct them one by one, which is inefficient and the user experience is not good

Images