Method and device for converting table in image into spreadsheet

A technology in electronic forms and images, which is applied in the field of image recognition, can solve problems such as cell position error, form line misdetection, form line missed detection, etc., and achieve the effect of maintaining consistent layout, high accuracy and good integrity

Pending Publication Date: 2021-11-23
SHANGHAI HEHE INFORMATION TECH DEV +3
View PDF7 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to problems in printing quality, shooting angle, shooting light, paper bending, etc., the existing conversion methods often have misdetection of table lines, missed detection of table lines, wrong cell positions, and missing cells, which makes the spreadsheet Error reverting layout for

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for converting table in image into spreadsheet
  • Method and device for converting table in image into spreadsheet
  • Method and device for converting table in image into spreadsheet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] see figure 1 , the method for converting tables in images into electronic tables proposed by this application includes the following steps.

[0020] Step S1: Convert and correct the image according to the text line and table line information in the image. For example, the text in the image is usually arranged horizontally, and the table lines usually include horizontal lines and vertical lines. Due to the shooting angle and the bending of the paper, the text and table lines in the image may be tilted and distorted. This step detects the angle of the text line and the table line, and arranges each line of text in the image approximately horizontally, so that the lines close to the horizontal are approximately horizontal, and the lines close to the vertical are approximately vertical. Perform rectification and correction. The image processed in this way can improve the accuracy of the subsequent detection of the position of the form and the correct rate of the structure...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method for converting a table in an image into a spreadsheet. The method comprises the following steps: S1, correcting and correcting an image according to character lines and lines in the image; S2, determining the position of a table in the image by adopting an anchor-free target detection method in the image, wherein the position is also called as a table area of the image; S3, detecting a table line in the table area of the image; S4, according to character line information obtained by performing optical character recognition on the table area of the image, removing the false table line to obtain a real table line; S5, according to the position relation between the table lines, classifying all the table lines into groups of all the rows and all the columns; S6, constructing cells according to the groups to which the table lines belong, and serving the optical character recognition result in the range of each cells as character information in the cell to be stored; and S7, if the missing cells exist, supplementing the cells at the corresponding positions so as to obtain a complete structured spreadsheet.

Description

technical field [0001] The present application relates to an image recognition method, in particular to a method for recognizing a form in an image and converting it into an electronic form (such as an Excel file). Background technique [0002] As a common document form, tables are widely used in office and daily life. In financial processing, data analysis, etc., there is a large demand for converting tables in images (pictures) into spreadsheets. Due to problems in printing quality, shooting angle, shooting light, paper bending, etc., the existing conversion methods often have misdetection of table lines, missed detection of table lines, wrong cell positions, and missing cells, which makes the spreadsheet There was an error restoring the layout for . Contents of the invention [0003] The technical problem to be solved in this application is to provide a method for converting tables of different formats in images of different image quality into electronic tables with a...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06K9/00G06K9/20G06K9/34G06K9/62G06N3/04G06N3/08
CPCG06N3/08G06N3/045G06F18/214
Inventor 郭丰俊龙伟丁凯龙腾
Owner SHANGHAI HEHE INFORMATION TECH DEV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap