- Patent Title: Automatically converting spreadsheet tables to relational tables
-
Application No.: US15443531Application Date: 2017-02-27
-
Publication No.: US10599627B2Publication Date: 2020-03-24
- Inventor: Rishabh Singh , Sumit Gulwani , Dana Drachsler Cohen
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
- Current Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
- Current Assignee Address: US WA Redmond
- Agency: Faegre Drinker Biddle & Reath LLP
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/25

Abstract:
Techniques are disclosed which provide for transforming a hierarchical table to a relational table. A hierarchical table may be received, in which a headline row is identified. A candidate row may be determined in the hierarchical table. The process may include systematically classifying headlines as data headlines or descriptors. For each data headline a new column may be generated, while for each descriptor headline, the table may be split to produce a resultant table. The resultant table may be stored and the process may be repeated until there are no headlines left to be classified. The steps performed by the system to transform the table can then be displayed on a user device using a program in the Domain-specific language, which can then be further inspected or modified to perform the desired table transformation.
Public/Granted literature
- US20180246915A1 AUTOMATICALLY CONVERTING SPREADSHEET TABLES TO RELATIONAL TABLES Public/Granted day:2018-08-30
Information query