Database Reference
In-Depth Information
Spreadsheet import process
This approach works in most of the common spreadsheet solutions out there
(MicrosoftExcel,OpenOficeCalc,GoogleSheets,AppleNumbers)asitrelies
on a very simple mechanism: using string concatenation based on cell values to
compose a query statement. Let's take a brief look at this.
First, let's assume that we have a simple data table with
people
like the one in the
followingigure.Thesepeoplehaveauniqueidentiier(irstcolumn),aname
(secondcolumn),andatype/label(thirdcolumn):
Nodes in a spreadsheet
