Funkcije vanjske
Posljednja promjena 24.07.2005
|
External Function |
||||
| Name | Source | Type | Description | Syntax |
| CALL | Built In | External | Calls a procedure in a dynamic link library or code resource | =CALL(register_id,argument1,…)
With Register.id =CALL(module_text,procedure,type_text, argument1,…) |
| EUROCONVERT | Add-in | External | Converts a number to or from Euros to or from a member currency or converts between one euro member currency to another using the Euro as an intermediary (triangulation) | =EUROCONVERT(number,source,target,full_precision, triangulation_precision) |
| GETPIVOTDATA | Built In | External | Returns data stored in a pivot table | =GETPIVOTDATA(data_field,pivot_table,field1,item1, field2,item2,…) |
| REGISTER.ID | Built In | External | Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered | =REGISTER.ID(module_text,procedure, type_text) |
| SQL.REQUEST | ODBC | External | Connects with an external data source, and runs a query from a worksheet. SQL.REQUEST then returns the result as an array | =SQL.REQUEST(connection_string, output_ref,driver_prompt,query_text,col_names_logical) |