Table conversion and editing support system

Abstract

To provide a support system that is capable of converting image data including form information into a table format and performing editing, outputting, and linking in one go, which solves conventional issues of difficulty in recognizing lines in both handwritten and printed text that makes post-conversion correction and formatting cumbersome, as well as lack of flexibility for reuse and external linking.SOLUTION: The present invention provides a table conversion and editing support system comprising a conversion module configured to analyze character strings and lines from document images and reconstruct a matrix structure, a user UI configured to enable visual editing, means of supporting handwriting, item classification, CSV / PDF outputting, and cloud storage, and a mechanism for linking with other systems.SELECTED DRAWING: None

Description

[Technical Field]

[0001] The present invention relates to a technology that enables extraction, conversion, and editing of tabular data from image data that includes form information, and in particular to a table conversion and editing support system that analyzes structural information from form images, automatically converts it into tabular data, and allows users to visually edit it. [Background technology]

[0002] Previously, digitizing tabular data from paper forms or scanned images required manually recognizing the table structure and re-entering it into Excel or other programs, which required a great deal of time and effort. OCR processing accuracy was particularly poor for handwritten text or images with unclear borders, making formatting and correction work tedious. Furthermore, specialized software was required to edit and reuse the converted data, making it inconvenient for average users. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent No. 6918740 [Patent Document 2] Patent No. 6481282 Summary of the Invention [Problem to be solved by the invention]

[0004] Accurately extracting and formatting tabular data from form images and outputting it in an editable state requires improved recognition accuracy for text and ruled lines, reconstruction of matrix structures, intuitive support for cell editing, flexible output formats, and compatibility with other systems. The purpose of this invention is to provide a system that automatically converts image data into tabular data, supports users in visually correcting and editing, and achieves the efficient digitization of business forms. [Means for solving the problem]

[0005] The present invention is a table conversion support system that takes image data including form information as input, analyzes the matrix structure or partition information within the image, and automatically converts it into tabular data, and is equipped with an image input means, a structural analysis module that recognizes character strings and lines within the image, a conversion module that reconstructs the matrix structure based on the recognition results, and an output means that outputs the tabular data on an editable user interface.

[0006] The structural analysis module supports both handwritten and printed input, and automatically determines cell separators, merging, matrix width, and height. It also has an item identification function that recognizes item names and label information and can classify them into categories such as days of the week, dates, staff names, roles, and working hours.

[0007] The user interface allows for cell modification, insertion, deletion, delimiter change, merging, character modification, etc., and has an editing support mechanism that allows the conversion results to be visually confirmed and edited.

[0008] The converted tabular data is provided with an output conversion means for exporting it in Excel, PDF, or CSV format, and further includes a data output structure that can be saved on the cloud and linked to other work adjustment systems or report generation systems. [Effects of the Invention]

[0009] This invention allows for the simple and highly accurate conversion of form image data into tabular data, which can then be edited visually and flexibly, significantly reducing the labor required for conventional manual input and reconstruction work. Furthermore, by supporting export formats and linking with other systems, it is possible to promote the efficiency of the entire business flow and a paperless system, and provide a form processing platform with excellent versatility and scalability.

Claims

1. This table conversion and editing support system takes image data including form information as input, analyzes the matrix structure or partition information within the image, and automatically converts it into tabular data. The table conversion and editing support system is characterized by comprising an image input means, a structural analysis module that recognizes character strings and ruled lines within the image, a conversion module that reconstructs the matrix structure based on the recognition results, and an output means that outputs the tabular data on an editable user interface.

2. The table conversion and editing support system according to claim 1, wherein the structural analysis module is capable of handling both handwritten and printed input, and automatically determines cell separators, joins, matrix widths, and heights.

3. The table conversion and editing support system according to claim 1 or 2 is characterized in that the user interface is provided with an editing support mechanism that enables modification, insertion, deletion, delimiter change, merging, and character modification of cells, and enables visual confirmation and editing of the conversion results.

4. 4. The table conversion and editing support system according to claim 1, further comprising an output conversion means capable of exporting converted table format data in Excel format, PDF format, or CSV format.

5. 5. The table conversion and editing support system according to claim 1, wherein the structural analysis module has an item identification function that automatically recognizes item names or label information in a table and classifies the information into categories such as days of the week, dates, staff names, roles, and working hours.

6. A table conversion and editing support system according to any one of claims 1 to 5, characterized in that the system stores converted table-format data on a cloud and has a data output structure that can be linked to other work adjustment systems or report generation systems.