Method and System for Transferring Data From a Scanned Document Into a Spreadsheet
First Claim
1. A method for transferring data from a document image directly into a spreadsheet, comprising:
- selecting a map that maps data types and associated data from the document to one or more cells in the spreadsheet;
scanning the document and storing the scanned document as textual data;
parsing the textual data to extract the data types and associated data from the textual data; and
using the selected map to transfer the associated data to the cells in the spreadsheet designated for the data types of said associated data by the selected map.
8 Assignments
0 Petitions
Accused Products
Abstract
A system and method that transfers data from scanned documents and document images directly into a spreadsheet. The user can construct a map that associates data types in the input scanned document with an area in the spreadsheet. The user can also use pre-stored maps that have previously been constructed by the user or by someone else. The map may be stored as an XML file in a hidden sheet of the spreadsheet or in a separate file. During use, the user selects a map, scans the document, parses the document to extract the data types and associated data, and transfers the parsed data to the spreadsheet in accordance with the selected mapping.
-
Citations
21 Claims
-
1. A method for transferring data from a document image directly into a spreadsheet, comprising:
-
selecting a map that maps data types and associated data from the document to one or more cells in the spreadsheet; scanning the document and storing the scanned document as textual data; parsing the textual data to extract the data types and associated data from the textual data; and using the selected map to transfer the associated data to the cells in the spreadsheet designated for the data types of said associated data by the selected map. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A system for transferring data from a document image directly into a spreadsheet, comprising:
-
a scanner that scans the document and stores the scanned document in a document memory as textual data; and a processor programmed to; enable a user to select a map that maps data types and associated data from the document to one or more cells in the spreadsheet; parse the textual data to extract the data types and associated data from the textual data; and transfer the associated data to the cells in the spreadsheet designated for the data types of said associated data by the selected map. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer readable storage medium having instructions stored thereon that when used to instruct a processor cause the processor to implement a method for transferring data from a document image directly into a spreadsheet, the instructions causing the processor to perform the steps of:
-
selecting a map that maps data types and associated data from the document to one or more cells in the spreadsheet; receiving a scanned representation of the document and storing the scanned representation of the document as textual data; parsing the textual data to extract the data types and associated data from the textual data; and using the selected map to transfer the associated data to the cells in the spreadsheet designated for the data types of said associated data by the selected map. - View Dependent Claims (18, 19, 20, 21)
-
Specification