Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
use: the euro will be converted to digital form, digital form by the euro currency is converted to the form of EU member states, or the use of the euro as currency among the EU member states by a number of currency into another currency in the EU member states forms (triangular relationship between the conversion). Syntax: EUROCONVERT (number, source, target, full_precision, triangulation_precision) Parameters: Number in order to convert the currency value, or contains the value of the reference cell. Source is composed of three-letter string, or string that contains the cell reference, the source string corresponds to the ISO currency code. EUROCONVERT function can use the following currency code:
2.SQL.REQUEST Purposes: to connect with external data sources, run queries from the worksheet, and then the query results SQL.REQUEST to return to the form of an array without the need for macro programming. Syntax: SQL.REQUEST (connection_string, output_ref, driver_prompt, query_text, col_names_logical) Parameters: Connection_string to provide information, such as the data source name, user ID and password. Output_ref for storage of a complete connection string of the reference cell. Driver_prompt designated driver when the dialog box shows as well as what options are available. Column_names_logical indicates whether the results will be listed as the first line of the return. If you are listing as the first line of the return of the results, please set the parameter TRUE. If you do not need to return to the list, then set to FALSE. If omitted column_names_logical, the function does not return SQL.REQUEST listing. |
