IP Library Patent Application 16551734
Patent Application
App. No. 16/551,734

INFORMATION PROCESSING APPARATUS AND NON-TRANSITORY COMPUTER READABLE MEDIUM

Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US None
App. No.
16/551,734
Abstract

An information processing apparatus includes a searching unit, an identifying unit, and an extracting unit. The searching unit searches for multiple cells from a table having cells arranged in a matrix. The multiple cells contain character strings that at least partially match a character string input as a key by a user. The identifying unit identifies a header range expressing a header row and a header column in the table based on distribution of the multiple cells found by the searching unit. The extracting unit extracts values corresponding to key cells by regarding the multiple cells included in the header range identified by the identifying unit as the key cells.

Claims (43)

1 . An information processing apparatus comprising:

a searching unit that searches for a plurality of cells from a table having cells arranged in a matrix, the plurality of cells containing character strings that at least partially match a character string input as a key by a user;

an identifying unit that identifies a header range expressing a header row and a header column in the table based on distribution of the plurality of cells found by the searching unit; and

an extracting unit that extracts values corresponding to key cells by regarding the plurality of cells included in the header range identified by the identifying unit as the key cells.

2 . The information processing apparatus according to claim 1 ,

wherein the identifying unit identifies a first header range candidate expressed as a combination including the plurality of cells found by the searching unit from all combinations of rows and columns that may serve as the header range in the table,

wherein the identifying unit identifies a second header range candidate from the identified first header range candidate, the second header range candidate being expressed as a combination including at least one of a row and a column where a first cell serving as any of the plurality of cells found by the searching unit exists, and

wherein if a third header range candidate having a minimum number of cells is identified as a single combination from the identified second header range candidate, the identifying unit sets the third header range candidate as the header range.

3 . The information processing apparatus according to claim 2 ,

wherein if the third header range candidate is identified as a plurality of combinations of a one-dimensional table and a two-dimensional table, the identifying unit sets the third header range candidate of the two-dimensional table as the header range.

4 . The information processing apparatus according to claim 2 ,

wherein the first cell is a combined cell constituted of two or more combined cells.

5 . The information processing apparatus according to claim 3 ,

wherein the first cell is a combined cell constituted of two or more combined cells.

6 . The information processing apparatus according to claim 1 ,

wherein, in a rectangular region that includes a predetermined reference cell of the table and a diagonal cell located diagonally to the reference cell and that does not include the plurality of cells found by the searching unit in a row direction and a column direction, the identifying unit identifies, from the table, a range excluding a rectangular region having a maximum number of cells as the header range.

7 . The information processing apparatus according to claim 6 ,

wherein the reference cell is a cell located at a lower right corner of the table, and

wherein the diagonal cell is a cell located diagonally at an upper left side of the cell located at the lower right corner.

8 . The information processing apparatus according to claim 1 ,

wherein the plurality of cells found by the searching unit are distributed in a row direction and a column direction of the header range.

9 . The information processing apparatus according to claim 2 ,

wherein the plurality of cells found by the searching unit are distributed in a row direction and a column direction of the header range.

10 . The information processing apparatus according to claim 3 ,

wherein the plurality of cells found by the searching unit are distributed in a row direction and a column direction of the header range.

11 . The information processing apparatus according to claim 4 ,

wherein the plurality of cells found by the searching unit are distributed in a row direction and a column direction of the header range.

12 . The information processing apparatus according to claim 5 ,

wherein the plurality of cells found by the searching unit are distributed in a row direction and a column direction of the header range.

13 . The information processing apparatus according to claim 6 ,

wherein the plurality of cells found by the searching unit are distributed in the row direction and the column direction of the header range.

14 . The information processing apparatus according to claim 7 ,

wherein the plurality of cells found by the searching unit are distributed in the row direction and the column direction of the header range.

15 . The information processing apparatus according to claim 8 ,

wherein the number of the plurality of cells found by the searching unit is smaller than the number of key cells included in the header range.

16 . A non-transitory computer readable medium storing a program causing a computer to execute a process, the process comprising:

searching for a plurality of cells from a table having cells arranged in a matrix, the plurality of cells containing character strings that at least partially match a character string input as a key by a user;

identifying a header range expressing a header row and a header column in the table based on distribution of the plurality of cells; and

extracting values corresponding to key cells by regarding the plurality of cells included in the header range as the key cells.

17 . An information processing apparatus comprising:

searching means for searching for a plurality of cells from a table having cells arranged in a matrix, the plurality of cells containing character strings that at least partially match a character string input as a key by a user;

identifying means for identifying a header range expressing a header row and a header column in the table based on distribution of the plurality of cells found by the searching means; and

extracting means for extracting values corresponding to key cells by regarding the plurality of cells included in the header range identified by the identifying means as the key cells.

Assignments (2)
CHANGE OF NAME Recorded May 13, 2021
From: FUJI XEROX CO., LTD.
To: FUJIFILM BUSINESS INNOVATION CORP.
Reel/Frame 056223/0236 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 2, 2019
From: ZHANG, YIFAN
To: FUJI XEROX CO., LTD.
Reel/Frame 050236/0730 →