Spreadsheet flat data extractor

A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

• receiving a spreadsheet;
• reading the spreadsheet to produce a flat dataframe;
• splitting the dataframe into a first flat data unit comprising a first spreadsheet table and a second flat data unit comprising a second spreadsheet table, based upon a separation in the flat dataframe;
• determining a header of the first spreadsheet table by referencing at least one of alphabetic content of a cell in the first spreadsheet table, and a font of a cell in the first spreadsheet table;
• identifying a connection between the first spreadsheet table and the second spreadsheet table;
• merging the first spreadsheet table and the second spreadsheet table to produce a first merged spreadsheet table;
• and
• storing the merged spreadsheet table in a database of a non-transitory computer readable storage medium,
• wherein,
• the merging is based upon a percentage match between the first flat data unit and the second flat data unit, and
• the percentage match is based upon series values.

A computer system comprising:

• one or more processors;
• a software program, executable on said computer system, the software program configured to cause an in-memory database engine of an in-memory database to:
• receive input data in a non-flat format;
• read the input data to produce a flat dataframe;
• split the dataframe into a first flat data unit and a second flat data unit based upon a separation in the flat dataframe;
• determine a header of the first flat data unit by referencing at least one of alphabetic content of a cell in the first spreadsheet table, and a font of a cell in the first spreadsheet table;
• identify a connection between the first flat data unit and the second flat data unit;
• merge the first flat data unit and the second flat data unit to produce a merged flat data unit;
• and
• store the merged flat data unit in the in-memory database,
• wherein,
• the merge is based upon a percentage match between the first flat data unit and the second flat data unit, and
• the percentage match is based upon series values.