摘要 |
Systems and methods are provided for importing data into a spreadsheet from an external data source. A set of cells containing formulas is identified. A first user defined function is executed to access a particular data record from the external data source. The execution of the first user defined function includes determining which of the stored formulas contain user defined functions to access data records from the external data source, resolving parameters of the identified user defined functions, generating a bulk query to the external data source requesting data for certain user defined functions having sufficient parameters resolved for identifying a data record plus more data records than are specified by the user defined functions, storing the data records specified in a hash table, storing the more data records than are specified in a memory, and returning the particular data record to the spreadsheet. |