Spreadsheet table transformation
US12307193B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 23, 2023 |
| Grant date | May 20, 2025 |
| Priority date | — |
| Expiry date | Oct 23, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/30
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Implementations of the present disclosure provide a solution for spreadsheet table transformation. In this solution, one or more header areas and a data area of a spreadsheet table are detected. A hierarchical structure of each of the header areas is determined by analysis of cell merging and/or indents in the header area, and/or a function relationship between data items in corresponding cells of the data area. The spreadsheet table can be transformed to a relational table based on recognition of the hierarchical structure of the header area. In this way, by facilitating understanding of header structures based on the header hierarchy, it is possible to achieve automated transformation from spreadsheet tables to relational tables.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.