US 11,836,445 B2
Spreadsheet table transformation
Haoyu Dong, Beijing (CN); Shi Han, Beijing (CN); Dongmei Zhang, Beijing (CN); Jennifer M. Halberstam, Issaquah, WA (US); and Xiao Lyu, Beijing (CN)
Assigned to Microsoft Technology Licensing, LLC, Redmond, WA (US)
Appl. No. 17/627,049
Filed by Microsoft Technology Licensing, LLC, Redmond, WA (US)
PCT Filed Aug. 8, 2019, PCT No. PCT/CN2019/099796
§ 371(c)(1), (2) Date Jan. 13, 2022,
PCT Pub. No. WO2021/022553, PCT Pub. Date Feb. 11, 2021.
Prior Publication US 2022/0366129 A1, Nov. 17, 2022
Int. Cl. G06F 17/00 (2019.01); G06F 40/18 (2020.01); G06F 16/22 (2019.01); G06F 40/30 (2020.01)
CPC G06F 40/18 (2020.01) [G06F 16/2246 (2019.01); G06F 40/30 (2020.01)] 15 Claims
OG exemplary drawing
 
1. A computer-implemented method, comprising:
detecting at least one header area and a data area of a spreadsheet table, the spreadsheet table comprising data items filled in cells arranged in rows and columns, the at least one header area comprising cells filled with data items for indexing or describing data items in cells of the data area;
determining a hierarchical structure of the data items in the at least one header area;
causing presentation, in a user interface, of the hierarchical structure to a user;
receiving, via the user interface, a user selection of a hierarchical level or at least one node in the hierarchical level for transformation; and
transforming the spreadsheet table into at least one relational table based on the user selection, the at least one relational table having the data items of the spreadsheet table associated with the selected hierarchical level or at least one node in the hierarchical level arranged in a unified structure.