JPH04123262A - List type data processor - Google Patents

Abstract

PURPOSE:To save the power of data input by providing this processor with means for writing characters, codes, etc., recognized by a data recognizing means for characters/codes in a list determined by a digit allocation determining means for list formation. CONSTITUTION:An image scanner 2 and a personal computer body 1 input only segments in a list to allocate digits to the list and then input data such as characters, numerals, codes, etc., to be written in the list to write the data in the digit-allocated list. When roughly hand-written list type data on paper are read out by the scanner 2, the data are inputted to the body 1 as list type data and data processing such as operation, retrieval and rearrangement is executed. Consequently, I/O items can be automatically designed, hand-written rough list type data also can be automatically processed and power for data input can be saved.

Description

DETAILED DESCRIPTION OF THE INVENTION (Field of Industrial Application) The present invention relates to improvements in character and graphic recognition and tabular data processing devices.

(Prior art and its problems) Conventionally, in spreadsheet software for personal computers and 7-ohm input/output systems for processing tabular data, the layout and output image of the output display on the screen etc. were determined in advance. Since the information is only input as layout image data for output display, it is necessary to manually redesign the layout for converting it into tabular information on a personal computer. This work was time-consuming and labor-intensive, and the more detailed the layout, the more labor-intensive it was. Furthermore, in the past, even if the layout design was determined on paper in advance, it was necessary to reset the table layout and digit division on the personal computer. Conventionally, when displaying a table on a screen, etc., the work is often done twice, and sometimes the originally expected design image differs from the contents of the table displayed on the screen. There were many problems.

Therefore, the present invention automatically identifies ruled lines, decorative information, and other characters from the table image and item design printed on the paper, and automatically designs table digit information or 7-ohm input/output items. It is something to do.

Further, the present invention connects an image scanner to a personal computer running spreadsheet processing software, automatically determines a table or input item in the personal computer, and converts the image data read by the image scanner into table information. It is characterized by automatically converting.

(Object of the Invention) An object of the present invention is to provide a tabular data processing device that saves labor in data input in order to solve the conventional problems.

(Structure of the Invention) In a tabular data processing device for a personal computer equipped with an image scanner system and capable of processing tabular data, means for storing image data read by an image scanner system; means for discriminating horizontal and vertical line segments from read image data; means for determining digit division for creating a table from the straight line components extracted by the line segment discriminating means; and excluding straight line components not extracted by the line segment discriminating means. means for recognizing data such as characters and symbols, and means for writing the characters, symbols, etc. recognized by the data recognition means such as characters and symbols in the table determined by the digit division determining means for creating the table; It is characterized by comprising the following. Furthermore, the present invention automatically determines frame information from rough sketch documents written on paper and creates table information, and each item can be defined as an item by surrounding it with a nearly straight line. Has characteristics.

(Example) An example of the present invention will be described with reference to the drawings. Figure 1 is a block diagram showing the configuration of the present invention, Figure 2 is an overall diagram of the system according to the present invention, Figure 3 is a 70-chart showing an example of the operation of the present invention, and Figures 4 (1) and (2) are images. 4(2) is a diagram showing the result of reading only the line segments on the soil surface. In the figure, 1 is the main body of the personal computer according to the present invention. , l& is the central processing unit (CPU), 1b is the system program (R
OM), 1c is an image data storage device (RAM), 1
d is a horizontal and vertical line segment discrimination processing unit, 1e is a digit division determination processing unit, ]f is a character and symbol data recognition processing unit, ]8 is a character and symbol data writing processing unit, 2 is an image scanner, and 3 is a display device (CRT/LCD), 4 is a printer (
P RT ), 5 is a storage device (HDD/FDD).

The personal computer main body unit includes a CPLlla, a ROM 1b that stores a system program, a RAM 1c that temporarily stores image data read from the image scanner 2, and a horizontal and vertical line from the image data stored in the RAM 1c. A line segment discrimination processing unit 1d that discriminates the line segment, a digit division process n1e that executes digit division processing for the line segment discriminated by the line segment discrimination processing unit 1d, and temporarily stores Moeki image data. R A M 1
A character and symbol recognition processing unit 1f recognizes characters and symbols excluding horizontal and vertical line segments from c, and a character and symbol recognition processing unit f recognizes characters and symbols in a table divided into digits by a digit division processing unit 1e. Character and symbol data input processing 1' FIS 1g for writing the characters and symbols that have been created.

The image scanner 2 stores the image data as binary data in the RAM 1 of the personal computer main body 1.
It is transferred to and stored in c.

The display device (CRT/LCD) 3 is an image scanner 2
The image data read in is displayed, and the result of the discrimination processing performed by the line segment discrimination processing unit 1d to discriminate horizontal and vertical lines from the image data is displayed. Furthermore, the results of the digit division processing of the table by the digit division processing unit 1e are also displayed, and the results of writing characters and symbols into the table divided by the digit division processing unit 1e are also displayed.

The storage device (HDD/FDD) 5 stores image data input by the personal computer main body 1 according to the present invention, and is loaded via the CPU 1a when necessary.

Next, an example of the operation of the present invention is shown in FIGS. 3 and 4 (1) and (2).
The explanation will be based on.

(Step 1) The paper surface of the tabular data is scanned by image scan 2 and temporarily stored in RAM 1c according to the present invention.

(Step 2) The line segment discrimination processing unit 1d discriminates and extracts horizontal and vertical line segments from the image data stored in the RAM 1e in Step 1 (see (1) and (2) in Fig. 4).
.

(Step 3) The digit division processing unit 1e executes digit division processing on the linear component extracted in step 2.6 (Step 4) The character and symbol recognition processing unit 1f recognizes only characters and symbols.

(Step 5) The characters and symbols recognized by the character and symbol recognition processing MSiF in step 4 are written into a table divided by digits by the digit division processing section 1e.

In the present invention, even when the table layout is roughly drawn by hand on paper, the image scanner 2 and the personal computer main body 1 according to the present invention first read only the line segments of the table, and then divide the table into digits. Read data such as letters, numbers, symbols, etc. in a table and write data such as letters, numbers, symbols, etc. into a table divided by digits. When rough handwritten tabular data on paper is read by the image scanner according to the present invention, the personal computer main body 1 according to the present invention
Enter tabular data above and perform data processing such as calculations, searches, and sorting.

(Effects of the Invention) Since the present invention has the above configuration, it automatically distinguishes ruled lines, decorative information, and other characters from the table image and item design printed on the paper, and automatically distinguishes between the table's digit information and 7 Not only can Ohm input and output items be automatically designed, but even rough handwritten tabular data can be automatically processed.

[Brief explanation of the drawing]

Figure 1 is a block diagram showing the configuration of the present invention, Figure 2 is an overall diagram of the system according to the present invention, Figure 3 is a 70-chart showing an example of the operation of the present invention, and Figures 4 (1) and (2) are images. It is a figure which shows the reading state and result of the linear component of the table by a scanner. 1... Personal computer main body 1a according to the present invention
...Central processing unit (CPU'') 1b...System program (ROM) 1c...Image data storage device (RAM) 1d...Horizontal and vertical line segment discrimination processing section 1e...Digit division determination Processing unit 1r...Character and symbol data recognition processing unit 1g...Character and symbol data writing processing unit 2...Image scanner 3...Display device (CRT/LCD) 4...Printer (P RT ) 5...Storage device (HDD/FDD)

Claims (1)

[Scope of Claim] A tabular data processing device equipped with an image scanner system and having a tabular data processing function, further comprising means for storing image data read by the image scanner system, and horizontal and vertical data processing from the read image data. means for determining vertical line segments; means for determining digit division for creating a table from the straight line components extracted by the line segment determining means; and data such as characters and symbols excluding straight line components not extracted by the line segment determining means. and means for writing the characters, symbols, etc. recognized by the data recognition means, such as the characters and symbols, into the table determined by the digit division determining means for creating the table. tabular data processing device.