Reading from a Database and Unpacking into Arrays
This spreadsheet queries a database from Python user code, using .NET System.Data.Odbc.
It queries a database and the result is put into an array - the array is unpacked to display the result in the grid. Using the unpack array feature loads the data into a specific set of cells.
The user code that reads from the database is very simple, making it easy to adapt for different types of queries.
See the documentation page (the More Information link) for the kind of database this spreadsheet expects to work with.
Uploaded by michael.
This model has been created for Resolver One, an advanced spreadsheet. You can download Resolver One here.