May 2018
Intermediate to advanced
576 pages
30h 25m
English
Spreadsheets combine data, presentation, and programs all into one file. That's perfect for power users wanting to work quickly. Like other relational databases, PostgreSQL is mainly concerned with the lowest level of data, so extracting just the data from these spreadsheets can present some challenges.
We can easily handle spreadsheet data if that spreadsheet's layout follows a very specific form, as follows:
This is a very simple layout, and more often there will be other things in the spreadsheet, ...